Presto 0.75 (& 0.76) with Cassandra 2.1.0

[Francisco Andrades Grassi]

Hi All,

We are trying to use Presto 0.75 (and as of today we also tried with 0.76 with the same results) with our newly installed Cassandra 2.1.0 cluster and we are getting some metadata errors:

2014-09-19T16:19:13.826+0000 INFO query-execution-4 com.facebook.presto.event.query.QueryMonitor TIMELINE: Query 20140919_161912_00000_ikmz5 :: elapsed 1223.00ms :: planning 201.64ms :: scheduling 515.00ms :: running 342.00ms :: finishing 164.00ms :: begin 2014-09-19T16:19:12.449Z :: end 2014-09-19T16:19:13.672Z
2014-09-19T16:19:14.658+0000 ERROR SplitRunner-2-42 com.facebook.presto.execution.TaskExecutor Error processing Split 20140919_161913_00001_ikmz5.1.0-0 (start = 1411143554007, wall = 555 ms, cpu = 0 ms, calls = 1)
java.lang.IllegalArgumentException: replicate_on_write is not a column defined in this metadata
at com.datastax.driver.core.ColumnDefinitions.getAllIdx(ColumnDefinitions.java:273) ~[na:na]
at com.datastax.driver.core.ColumnDefinitions.getFirstIdx(ColumnDefinitions.java:279) ~[na:na]
at com.datastax.driver.core.Row.getBool(Row.java:117) ~[na:na]
at com.datastax.driver.core.TableMetadata$Options.<init>(TableMetadata.java:474) ~[na:na]
at com.datastax.driver.core.TableMetadata.build(TableMetadata.java:107) ~[na:na]
at com.datastax.driver.core.Metadata.buildTableMetadata(Metadata.java:128) ~[na:na]
at com.datastax.driver.core.Metadata.rebuildSchema(Metadata.java:89) ~[na:na] 

We can see that the plugin/cassandra libraries are for Cassandra 2.0.4, and I'm guessing that's the problem. Replacing the driver with the 2.1 one does not work as the problem is now some API incompatibilities (it seems like com.datastax.driver.core.Session is now an interface and it was a class before).

Are there any plans to support Cassandra 2.1.0 in the near future? We rather stay on 2.1.0 than downgrade, but if presto support is too far away (and since we are just setting up this cluster) this is the time to do so.

Thanks in advance.

[Dain Sundstrom]

We got a pull request yesterday that looks like it fixes this:

  https://github.com/facebook/presto/pull/1694

Assuming it works, I expect to get this in the next release.

-dain

[Brenden Matthews]

Would be nice to see this merged.  Querying Cassandra with Presto is currently broken for everyone in our organization, and we store a bunch of useful data in there.

--
You received this message because you are subscribed to the Google Groups "Presto" group.
To unsubscribe from this group and stop receiving emails from it, send an email to presto-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Dain Sundstrom]

Sorry, this has been on my plate for a while now.  I'll try to merge it in when I get back on Tuesday. 

-dain

Sent from my iPhone