java.io.IOException

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.

  • GitHub comment 12#37273045
    via GitHub by pyr
    ,
    • java.io.IOException: Exception during preparation of _**SELECT "dtid", "created", "deleted" FROM "metricsdb"."device_counts_by_hour" WHERE token("period") > ? AND token("period") <= ? AND period = 2016033123 ALLOW FILTERING**_: period cannot be restricted by more than one relation if it includes an Equal at com.datastax.spark.connector.rdd.CassandraTableScanRDD.createStatement(CassandraTableScanRDD.scala:288)[spark-cassandra-connector_2.10-1.6.0-M2.jar:1.6.0-M2] at com.datastax.spark.connector.rdd.CassandraTableScanRDD.com$datastax$spark$connector$rdd$CassandraTableScanRDD$$fetchTokenRange(CassandraTableScanRDD.scala:302)[spark-cassandra-connector_2.10-1.6.0-M2.jar:1.6.0-M2] at com.datastax.spark.connector.rdd.CassandraTableScanRDD$$anonfun$18.apply(CassandraTableScanRDD.scala:328)[spark-cassandra-connector_2.10-1.6.0-M2.jar:1.6.0-M2] at com.datastax.spark.connector.rdd.CassandraTableScanRDD$$anonfun$18.apply(CassandraTableScanRDD.scala:328)[spark-cassandra-connector_2.10-1.6.0-M2.jar:1.6.0-M2] at scala.collection.Iterator$$anon$13.hasNext(Iterator.scala:371)[scala-library-2.10.5.jar:na] at com.datastax.spark.connector.util.CountingIterator.hasNext(CountingIterator.scala:12)[spark-cassandra-connector_2.10-1.6.0-M2.jar:1.6.0-M2] at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327)[scala-library-2.10.5.jar:na] at org.apache.spark.shuffle.sort.BypassMergeSortShuffleWriter.write(BypassMergeSortShuffleWriter.java:126)[spark-core_2.10-1.6.0.jar:1.6.0] at org.apache.spark.scheduler.ShuffleMapTask.runTask(ShuffleMapTask.scala:73)[spark-core_2.10-1.6.0.jar:1.6.0] at org.apache.spark.scheduler.ShuffleMapTask.runTask(ShuffleMapTask.scala:41)[spark-core_2.10-1.6.0.jar:1.6.0] at org.apache.spark.scheduler.Task.run(Task.scala:89)[spark-core_2.10-1.6.0.jar:1.6.0] at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:213)[spark-core_2.10-1.6.0.jar:1.6.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_60] at java.lang.Thread.run(Thread.java:745)[na:1.8.0_60] Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: period cannot be restricted by more than one relation if it includes an Equal at com.datastax.driver.core.exceptions.InvalidQueryException.copy(InvalidQueryException.java:50)[cassandra-driver-core-3.0.0.jar:na] at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37)[cassandra-driver-core-3.0.0.jar:na] at com.datastax.driver.core.AbstractSession.prepare(AbstractSession.java:110)[cassandra-driver-core-3.0.0.jar:na] at com.datastax.spark.connector.cql.PreparedStatementCache$.prepareStatement(PreparedStatementCache.scala:45)[spark-cassandra-connector_2.10-1.6.0-M2.jar:1.6.0-M2] at com.datastax.spark.connector.cql.SessionProxy.invoke(SessionProxy.scala:28)[spark-cassandra-connector_2.10-1.6.0-M2.jar:1.6.0-M2] at com.sun.proxy.$Proxy21.prepare(Unknown Source)[na:na] at com.datastax.spark.connector.rdd.CassandraTableScanRDD.createStatement(CassandraTableScanRDD.scala:274)[spark-cassandra-connector_2.10-1.6.0-M2.jar:1.6.0-M2] ... 14 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    6 more bugmates