org.apache.spark.sql.hive.HiveQl$ParseException: Failed to parse: show tablesss

github.com | 3 months 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: show tablesss

      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:225)
      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$2$$anonfun$apply$14.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)
      6. scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1$$anonfun$apply$2.apply(Parsers.scala:254)
      7. scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1$$anonfun$apply$2.apply(Parsers.scala:254)
      8. scala.util.parsing.combinator.Parsers$Failure.append(Parsers.scala:202)
      9. scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1.apply(Parsers.scala:254)
      10. scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1.apply(Parsers.scala:254)
      11. scala.util.parsing.combinator.Parsers$$anon$3.apply(Parsers.scala:222)
      12. scala.util.parsing.combinator.Parsers$$anon$2$$anonfun$apply$14.apply(Parsers.scala:891)
      13. scala.util.parsing.combinator.Parsers$$anon$2$$anonfun$apply$14.apply(Parsers.scala:891)
      13 frames
    4. Scala
      DynamicVariable.withValue
      1. scala.util.DynamicVariable.withValue(DynamicVariable.scala:57)
      1 frame
    5. scala-parser-combinators
      PackratParsers$$anon$1.apply
      1. scala.util.parsing.combinator.Parsers$$anon$2.apply(Parsers.scala:890)
      2. scala.util.parsing.combinator.PackratParsers$$anon$1.apply(PackratParsers.scala:110)
      2 frames
    6. Spark Project Catalyst
      AbstractSparkSQLParser.apply
      1. org.apache.spark.sql.catalyst.AbstractSparkSQLParser.apply(SparkSQLParser.scala:31)
      1 frame
    7. Spark Project Hive
      HiveQl$$anonfun$3.apply
      1. org.apache.spark.sql.hive.HiveQl$$anonfun$3.apply(HiveQl.scala:130)
      2. org.apache.spark.sql.hive.HiveQl$$anonfun$3.apply(HiveQl.scala:130)
      2 frames
    8. Spark Project Catalyst
      SparkSQLParser$$anonfun$org$apache$spark$sql$catalyst$SparkSQLParser$$others$1.apply
      1. org.apache.spark.sql.catalyst.SparkSQLParser$$anonfun$org$apache$spark$sql$catalyst$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:184)
      2. org.apache.spark.sql.catalyst.SparkSQLParser$$anonfun$org$apache$spark$sql$catalyst$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:183)
      2 frames
    9. scala-parser-combinators
      Parsers$$anon$2$$anonfun$apply$14.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)
      6. scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1$$anonfun$apply$2.apply(Parsers.scala:254)
      7. scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1$$anonfun$apply$2.apply(Parsers.scala:254)
      8. scala.util.parsing.combinator.Parsers$Failure.append(Parsers.scala:202)
      9. scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1.apply(Parsers.scala:254)
      10. scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1.apply(Parsers.scala:254)
      11. scala.util.parsing.combinator.Parsers$$anon$3.apply(Parsers.scala:222)
      12. scala.util.parsing.combinator.Parsers$$anon$2$$anonfun$apply$14.apply(Parsers.scala:891)
      13. scala.util.parsing.combinator.Parsers$$anon$2$$anonfun$apply$14.apply(Parsers.scala:891)
      13 frames
    10. Scala
      DynamicVariable.withValue
      1. scala.util.DynamicVariable.withValue(DynamicVariable.scala:57)
      1 frame
    11. scala-parser-combinators
      PackratParsers$$anon$1.apply
      1. scala.util.parsing.combinator.Parsers$$anon$2.apply(Parsers.scala:890)
      2. scala.util.parsing.combinator.PackratParsers$$anon$1.apply(PackratParsers.scala:110)
      2 frames
    12. Spark Project Catalyst
      AbstractSparkSQLParser.apply
      1. org.apache.spark.sql.catalyst.AbstractSparkSQLParser.apply(SparkSQLParser.scala:31)
      1 frame
    13. Spark Project Hive
      HiveContext.sql
      1. org.apache.spark.sql.hive.HiveQl$.parseSql(HiveQl.scala:221)
      2. org.apache.spark.sql.hive.HiveContext.sql(HiveContext.scala:98)
      2 frames
    14. org.apache.spark
      SparkSQLCLIDriver.processCmd
      1. org.apache.spark.sql.hive.thriftserver.SparkSQLDriver.run(SparkSQLDriver.scala:58)
      2. org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver.processCmd(SparkSQLCLIDriver.scala:274)
      2 frames
    15. org.apache.hadoop
      CliDriver.processLine
      1. org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
      1 frame
    16. org.apache.spark
      SparkSQLCLIDriver.main
      1. org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver$.main(SparkSQLCLIDriver.scala:209)
      2. org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver.main(SparkSQLCLIDriver.scala)
      2 frames