java.lang.RuntimeException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Spark SQL: Cross Join with sub-queries
    via Stack Overflow by Timo
    ,
  • generating data fails
    via GitHub by hansbogert
    ,
  • spark sql query with percentage issue
    via Stack Overflow by Carson Pun
    ,
  • {noformat} CassandraPrunedScanSpec: [info] Exception encountered when attempting to run a suite with class name: com.datastax.spark.connector.sql.CassandraPrunedScanSpec *** ABORTED *** (157 milliseconds) [info] java.lang.RuntimeException: [1.2] failure: ``with'' expected but identifier CREATE found [info] [info] CREATE TEMPORARY TABLE tmpTable USING org.apache.spark.sql.cassandra OPTIONS ( c_table "test1", keyspace "sql_ds_test", push_down "false", spark_cassandra_input_page_row_size "10", spark_cassandra_output_consistency_level "ONE", spark_cassandra_connection_timeout_ms "1000", spark_cassandra_connection_host "127.0.0.1" ) [info] ^ {noformat} {noformat} [info] CassandraDataSourceSpec: [info] Exception encountered when attempting to run a suite with class name: com.datastax.spark.connector.sql.CassandraDataSourceSpec *** ABORTED *** (14 milliseconds) [info] java.lang.RuntimeException: [1.2] failure: ``with'' expected but identifier CREATE found [info] [info] CREATE TEMPORARY TABLE tmpTable USING org.apache.spark.sql.cassandra OPTIONS ( c_table "test1", keyspace "sql_ds_test", push_down "true", spark_cassandra_input_page_row_size "10", spark_cassandra_output_consistency_level "ONE", spark_cassandra_connection_timeout_ms "1000", spark_cassandra_connection_host "127.0.0.1" ) [info] ^ [info] at scala.sys.package$.error(package.scala:27) [info] at org.apache.spark.sql.catalyst.AbstractSparkSQLParser.parse(AbstractSparkSQLParser.scala:36) [info] at org.apache.spark.sql.catalyst.DefaultParserDialect.parse(ParserDialect.scala:67) [info] at org.apache.spark.sql.SQLContext$$anonfun$2.apply(SQLContext.scala:145) [info] at org.apache.spark.sql.SQLContext$$anonfun$2.apply(SQLContext.scala:145) [info] at org.apache.spark.sql.SparkSQLParser$$anonfun$org$apache$spark$sql$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:95) [info] at org.apache.spark.sql.SparkSQLParser$$anonfun$org$apache$spark$sql$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:94) [info] at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:136) [info] at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:135) [info] at scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242) [info] at scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242) [info] at scala.util.parsing.combinator.Parsers$$anon$3.apply(Parsers.scala:222) {noformat}
    via by Piotr Kołaczkowski,
  • {noformat} CassandraPrunedScanSpec: [info] Exception encountered when attempting to run a suite with class name: com.datastax.spark.connector.sql.CassandraPrunedScanSpec *** ABORTED *** (157 milliseconds) [info] java.lang.RuntimeException: [1.2] failure: ``with'' expected but identifier CREATE found [info] [info] CREATE TEMPORARY TABLE tmpTable USING org.apache.spark.sql.cassandra OPTIONS ( c_table "test1", keyspace "sql_ds_test", push_down "false", spark_cassandra_input_page_row_size "10", spark_cassandra_output_consistency_level "ONE", spark_cassandra_connection_timeout_ms "1000", spark_cassandra_connection_host "127.0.0.1" ) [info] ^ {noformat} {noformat} [info] CassandraDataSourceSpec: [info] Exception encountered when attempting to run a suite with class name: com.datastax.spark.connector.sql.CassandraDataSourceSpec *** ABORTED *** (14 milliseconds) [info] java.lang.RuntimeException: [1.2] failure: ``with'' expected but identifier CREATE found [info] [info] CREATE TEMPORARY TABLE tmpTable USING org.apache.spark.sql.cassandra OPTIONS ( c_table "test1", keyspace "sql_ds_test", push_down "true", spark_cassandra_input_page_row_size "10", spark_cassandra_output_consistency_level "ONE", spark_cassandra_connection_timeout_ms "1000", spark_cassandra_connection_host "127.0.0.1" ) [info] ^ [info] at scala.sys.package$.error(package.scala:27) [info] at org.apache.spark.sql.catalyst.AbstractSparkSQLParser.parse(AbstractSparkSQLParser.scala:36) [info] at org.apache.spark.sql.catalyst.DefaultParserDialect.parse(ParserDialect.scala:67) [info] at org.apache.spark.sql.SQLContext$$anonfun$2.apply(SQLContext.scala:145) [info] at org.apache.spark.sql.SQLContext$$anonfun$2.apply(SQLContext.scala:145) [info] at org.apache.spark.sql.SparkSQLParser$$anonfun$org$apache$spark$sql$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:95) [info] at org.apache.spark.sql.SparkSQLParser$$anonfun$org$apache$spark$sql$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:94) [info] at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:136) [info] at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:135) [info] at scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242) [info] at scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242) [info] at scala.util.parsing.combinator.Parsers$$anon$3.apply(Parsers.scala:222) {noformat}
    via by Piotr Kołaczkowski,
  • LEFT and RIGHT function in PySpark SQL
    via Stack Overflow by Green
    ,
    • java.lang.RuntimeException: [1.139] failure: ``union\u0027\u0027 expected but identifier VIEW found\n\nSELECT (90000 + people.index) as id, people.name.text as name, people.bio.text as bio, people.hero.src as img FROM actresses_temp LATERAL VIEW explode(results.people) p AS people\n ^ at scala.sys.package$.error(package.scala:27) at org.apache.spark.sql.catalyst.AbstractSparkSQLParser.parse(AbstractSparkSQLParser.scala:36) at org.apache.spark.sql.catalyst.DefaultParserDialect.parse(ParserDialect.scala:67) at org.apache.spark.sql.SQLContext$$anonfun$3.apply(SQLContext.scala:175) at org.apache.spark.sql.SQLContext$$anonfun$3.apply(SQLContext.scala:175) at org.apache.spark.sql.SparkSQLParser$$anonfun$org$apache$spark$sql$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:115) at org.apache.spark.sql.SparkSQLParser$$anonfun$org$apache$spark$sql$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:114) at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:136) at scala.util.parsing.combinator.Parsers$Success.map(Parsers.scala:135) at scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242) at scala.util.parsing.combinator.Parsers$Parser$$anonfun$map$1.apply(Parsers.scala:242) at scala.util.parsing.combinator.Parsers$$anon$3.apply(Parsers.scala:222) at scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1$$anonfun$apply$2.apply(Parsers.scala:254) at scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1$$anonfun$apply$2.apply(Parsers.scala:254) at scala.util.parsing.combinator.Parsers$Failure.append(Parsers.scala:202) at scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1.apply(Parsers.scala:254) at scala.util.parsing.combinator.Parsers$Parser$$anonfun$append$1.apply(Parsers.scala:254) at scala.util.parsing.combinator.Parsers$$anon$3.apply(Parsers.scala:222) at scala.util.parsing.combinator.Parsers$$anon$2$$anonfun$apply$14.apply(Parsers.scala:891) at scala.util.parsing.combinator.Parsers$$anon$2$$anonfun$apply$14.apply(Parsers.scala:891) at scala.util.DynamicVariable.withValue(DynamicVariable.scala:57) at scala.util.parsing.combinator.Parsers$$anon$2.apply(Parsers.scala:890) at scala.util.parsing.combinator.PackratParsers$$anon$1.apply(PackratParsers.scala:110) at org.apache.spark.sql.catalyst.AbstractSparkSQLParser.parse(AbstractSparkSQLParser.scala:34) at org.apache.spark.sql.SQLContext$$anonfun$2.apply(SQLContext.scala:172) at org.apache.spark.sql.SQLContext$$anonfun$2.apply(SQLContext.scala:172) at org.apache.spark.sql.execution.datasources.DDLParser.parse(DDLParser.scala:42) at org.apache.spark.sql.SQLContext.parseSql(SQLContext.scala:195) at org.apache.spark.sql.SQLContext.sql(SQLContext.scala:725)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    guizmaiiguizmaii
    7 times, last one,
    gpgekkogpgekko
    1 times, last one,
    90 more bugmates