org.apache.spark.sql.hive.HiveQl$ParseException: Failed to parse: SELECT json_val from temp_hum_table lateral view explode_map( json_map(*, 'int,string')) x as json_key, json_val

Stack Overflow | venuktan | 2 years ago
  1. 0

    read json key-values with hive/sql and spark

    Stack Overflow | 2 years ago | venuktan
    org.apache.spark.sql.hive.HiveQl$ParseException: Failed to parse: SELECT json_val from temp_hum_table lateral view explode_map( json_map(*, 'int,string')) x as json_key, json_val

    Root Cause Analysis

    1. org.apache.spark.sql.hive.HiveQl$ParseException

      Failed to parse: SELECT json_val from temp_hum_table lateral view explode_map( json_map(*, 'int,string')) x as json_key, json_val

      at org.apache.spark.sql.hive.HiveQl$.createPlan()
    2. Spark Project Hive
      ExtendedHiveQlParser$$anonfun$hiveQl$1.apply
      1. org.apache.spark.sql.hive.HiveQl$.createPlan(HiveQl.scala:239)
      2. org.apache.spark.sql.hive.ExtendedHiveQlParser$$anonfun$hiveQl$1.apply(ExtendedHiveQlParser.scala:50)
      3. org.apache.spark.sql.hive.ExtendedHiveQlParser$$anonfun$hiveQl$1.apply(ExtendedHiveQlParser.scala:49)
      3 frames
    3. scala-parser-combinators
      Parsers$$anon$3.apply
      1. scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:136)
      2. scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:135)
      3. scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242)
      4. scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242)
      5. scala.util.parsing.combinator.Parsers$$anon$3.apply(Parsers.scala:222)
      5 frames