# Logstash Cassandra JDBC Connection CQL Error

**URL:** <https://discuss.elastic.co/t/logstash-cassandra-jdbc-connection-cql-error/59885>\
**Category:** Logstash\
**Created:** [September 6, 2016, 2:12pm UTC](https://discuss.elastic.co/t/logstash-cassandra-jdbc-connection-cql-error/59885 "2016-09-06T14:12:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![brantkev](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@brantkev](https://discuss.elastic.co/u/brantkev)\
**Post date:** [September 6, 2016, 2:12pm UTC](https://discuss.elastic.co/t/logstash-cassandra-jdbc-connection-cql-error/59885/1 "2016-09-06T14:12:22Z")

</div>

When executing Logstash with JDBC for Cassandra I am getting the error below

Java::ComDatastaxDriverCoreExceptions::SyntaxError: line 1:174 missing EOF at ')' (....logs\_all\_3\_0\_0 where event\_id \> '1970-01-01 00:00:00.000000'[)] AS...): SELECT count(\*) AS "COUNT" FROM (select event\_id, event\_name, machine\_name, payload from adamtestlog.logs\_all\_3\_0\_0 where event\_id \> '1970-01-01 00:00:00.000000') AS "T1" LIMIT 1 {:level=\>:error, :file=\>"sequel/database/logging.rb", :line=\>"87", :method=\>"lo  
Exception when executing JDBC query {:exception=\># '1970-01-01 00:0[)] AS...)\>, :level=\>:warn, :file=\>"logstash/plugin\_mixins/jdbc.rb", :line=\>"219", :method=\>"execute\_statement"}

The config file is as follows:

input {  
jdbc {  
jdbc\_driver\_library =\> "/opt/logstash/bin/jdbc-jar/cassandrajdbc1.1.jar"  
jdbc\_driver\_class =\> "com.dbschema.CassandraJdbcDriver"  
jdbc\_connection\_string =\> "jdbc:cassandra://172.30.0.96:9042/"  
jdbc\_user =\> "\***"  
jdbc\_password =\> "**"  
schedule =\> " \* \* \* \*"  
use\_column\_value =\> true  
tracking\_column =\> "event\_id"  
last\_run\_metadata\_path =\> "/.logstash\_jdbc\_last\_run"  
statement =\> "select event\_id, recorded\_on, event\_name, machine\_name, payload from adamtestlog.logs\_all\_3\_0\_0 where event\_id \> :sql\_last\_value"  
}  
}  
output{  
stdout{  
codec =\>json\_lines  
}  
}

My understanding is due to Cassandra it is unable to execute a select count(\*) from (select \* from ...) statement.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:39am UTC](https://discuss.elastic.co/t/logstash-cassandra-jdbc-connection-cql-error/59885/2 "2017-07-06T04:39:39Z")

</div>