column_aliases is not a column defined in this metadata

[dipietro-salvatore]

Hi everyone,
I am new user and I am trying to use YCSB (version 0.2.0) with Cassandra (version 2.2) on Debian 8 64bits. As I read in this thread (#154), I tried to configure them and I created the cassandra database with the command (from cqlsh):

cqlsh> CREATE KEYSPACE ycsb WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
cqlsh> use ycsb ;
cqlsh:usertable> create table usertable ( y_id varchar primary key, field0 varchar, field1 varchar, field2 varchar, field3 varchar, field4 varchar, field5 varchar, field6 varchar, field7 varchar, field8 varchar, field9 varchar);

and I ran the YCSB command:
bin/ycsb load cassandra-cql -p host="127.0.0.1" -p port=9042 -P workloads/workloadb -s > /dev/null

Unfortunatelly, as you can see below, it doesn't work.
The number of operations remain 0 and it crash with the error "column_aliases is not a column defined in this metadata".
What is it wrong in my settings? How can I fix it?

Thank you very much

~/git/ycsb-0.2.0$ bin/ycsb load cassandra-cql -p host="127.0.0.1" -p port=9042 -P workloads/workloada -s > /dev/null
/usr/lib/jvm/java-8-oracle/bin/java -cp /home/user/git/ycsb-0.2.0/cassandra-binding/conf:/home/user/git/ycsb-0.2.0/conf:/home/user/git/ycsb-0.2.0/lib/HdrHistogram-2.1.4.jar:/home/user/git/ycsb-0.2.0/lib/jackson-core-asl-1.9.4.jar:/home/user/git/ycsb-0.2.0/lib/core-0.2.0.jar:/home/user/git/ycsb-0.2.0/lib/jackson-mapper-asl-1.9.4.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/jline-1.0.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/high-scale-lib-1.1.2.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/concurrentlinkedhashmap-lru-1.3.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/httpclient-4.0.1.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/netty-3.5.9.Final.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/commons-logging-1.1.1.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/compress-lzf-0.8.4.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/jetty-util-6.1.22.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/cassandra-thrift-1.2.9.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/libthrift-0.7.0.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/snakeyaml-1.6.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/servlet-api-2.5-20081211.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/jackson-mapper-asl-1.9.2.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/guava-13.0.1.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/slf4j-log4j12-1.7.2.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/stringtemplate-3.2.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/snaptree-0.1.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/jbcrypt-0.3m.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/commons-codec-1.2.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/jamm-0.2.5.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/antlr-3.2.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/log4j-1.2.16.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/antlr-2.7.7.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/slf4j-api-1.6.4.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/json-simple-1.1.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/jackson-core-asl-1.9.2.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/antlr-runtime-3.2.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/httpcore-4.0.1.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/cassandra-driver-core-1.0.3.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/metrics-core-2.0.3.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/commons-cli-1.1.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/cassandra-binding-0.2.0.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/cassandra-all-1.2.9.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/jetty-6.1.22.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/lz4-1.1.0.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/servlet-api-2.5.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/commons-lang-2.6.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/avro-1.4.0-cassandra-1.jar:/home/user/git/ycsb-0.2.0/cassandra-binding/lib/snappy-java-1.0.5.jar com.yahoo.ycsb.Client -db com.yahoo.ycsb.db.CassandraCQLClient -p host=127.0.0.1 -p port=9042 -P workloads/workloadb -s -load
Loading workload...
Starting test.
2015-07-23 10:33:43:592 0 sec: 0 operations;
log4j:WARN No appenders could be found for logger (com.datastax.driver.core.Cluster).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
com.yahoo.ycsb.DBException: java.lang.IllegalArgumentException: column_aliases is not a column defined in this metadata
at com.yahoo.ycsb.db.CassandraCQLClient.init(CassandraCQLClient.java:158)
at com.yahoo.ycsb.DBWrapper.init(DBWrapper.java:63)
at com.yahoo.ycsb.ClientThread.run(Client.java:195)
Caused by: java.lang.IllegalArgumentException: column_aliases is not a column defined in this metadata
at com.datastax.driver.core.ColumnDefinitions.getIdx(ColumnDefinitions.java:268)
at com.datastax.driver.core.Row.getString(Row.java:414)
at com.datastax.driver.core.TableMetadata.build(TableMetadata.java:88)
at com.datastax.driver.core.Metadata.buildTableMetadata(Metadata.java:124)
at com.datastax.driver.core.Metadata.rebuildSchema(Metadata.java:88)
at com.datastax.driver.core.ControlConnection.refreshSchema(ControlConnection.java:265)
at com.datastax.driver.core.ControlConnection.tryConnect(ControlConnection.java:220)
at com.datastax.driver.core.ControlConnection.reconnectInternal(ControlConnection.java:168)
at com.datastax.driver.core.ControlConnection.connect(ControlConnection.java:81)
at com.datastax.driver.core.Cluster$Manager.init(Cluster.java:644)
at com.datastax.driver.core.Cluster$Manager.access$100(Cluster.java:586)
at com.datastax.driver.core.Cluster.(Cluster.java:69)
at com.datastax.driver.core.Cluster.buildFrom(Cluster.java:96)
at com.datastax.driver.core.Cluster$Builder.build(Cluster.java:567)
at com.yahoo.ycsb.db.CassandraCQLClient.init(CassandraCQLClient.java:131)
... 2 more
2015-07-23 10:33:53:582 10 sec: 0 operations;

[busbey]

I suspect this is the known incompatibility with Cassandra 2.1+ (ref #293). The error looks different, but it still comes down to a client incompatibility. Presuming no one is opposed, I'll update the release notes to call out "Cassandra 2.1+" instead of the current "Cassandra 2.1".

Unfortunately, that's not much help for you @dipietro-salvatore. I'm hoping the merging of #98 will bring us up to date, but I haven't had a chance to test. Those changes look like they won't be available until the August release.

If you have some time to test out some options we could work on some troubleshooting?

[cmccoy]

This should be fixed by #454 - closing. Feel free to re-open if you're having trouble with the latest master.

[kirankumar1991]

I made a clean build from the master but I'm still facing the same problem.

Update: I ran with cassandra2-cql and it worked. Thank you.