java.lang.RuntimeException: [1.2] failure: ``with'' expected but identifier CREATE found 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" ) ^

DataStax JIRA | Piotr Kołaczkowski | 1 year ago
  1. 0

    {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}

    DataStax JIRA | 1 year ago | Piotr Kołaczkowski
    java.lang.RuntimeException: [1.2] failure: ``with'' expected but identifier CREATE found 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" ) ^
  2. 0

    {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}

    DataStax JIRA | 1 year ago | Piotr Kołaczkowski
    java.lang.RuntimeException: [1.2] failure: ``with'' expected but identifier CREATE found 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" ) ^
  3. 0

    generating data fails

    GitHub | 1 year ago | hansbogert
    java.lang.RuntimeException: [6.12] failure: \`\`union'' expected but `by' found DISTRIBUTE BY ^
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    spark sql query with percentage issue

    Stack Overflow | 12 months ago | Carson Pun
    java.lang.RuntimeException: [1.14] failure: ``distinct'' expected but `%' found SELECT score(%) FROM df ^
  6. 0

    Spark SQL: Cross Join with sub-queries

    Stack Overflow | 9 months ago | Timo
    java.lang.RuntimeException: [1.67] failure: ``union'' expected but identifier CROSS found SELECT * FROM ( SELECT obj as origProperty1 FROM a LIMIT 10) tab1 CROSS JOIN ( SELECT obj AS origProperty2 FROM b LIMIT 10) tab2 ^

  1. rp 1 times, last 1 week ago
  2. Handemelindo 1 times, last 3 weeks ago
  3. rp 4 times, last 2 months ago
  4. balintn 3 times, last 2 months ago
  5. max_samebug 2 times, last 2 months ago
13 more registered users
70 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.lang.RuntimeException

    [1.2] failure: ``with'' expected but identifier CREATE found 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" ) ^

    at scala.sys.package$.error()
  2. Scala
    package$.error
    1. scala.sys.package$.error(package.scala:27)
    1 frame
  3. Spark Project Catalyst
    DefaultParserDialect.parse
    1. org.apache.spark.sql.catalyst.AbstractSparkSQLParser.parse(AbstractSparkSQLParser.scala:36)
    2. org.apache.spark.sql.catalyst.DefaultParserDialect.parse(ParserDialect.scala:67)
    2 frames
  4. Spark Project SQL
    SparkSQLParser$$anonfun$org$apache$spark$sql$SparkSQLParser$$others$1.apply
    1. org.apache.spark.sql.SQLContext$$anonfun$2.apply(SQLContext.scala:145)
    2. org.apache.spark.sql.SQLContext$$anonfun$2.apply(SQLContext.scala:145)
    3. org.apache.spark.sql.SparkSQLParser$$anonfun$org$apache$spark$sql$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:95)
    4. org.apache.spark.sql.SparkSQLParser$$anonfun$org$apache$spark$sql$SparkSQLParser$$others$1.apply(SparkSQLParser.scala:94)
    4 frames
  5. 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