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

github.com | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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