search

jorgebay / node-cassandra-cql

Node.js driver for Apache Cassandra
MIT License
144 stars 42 forks source link

Uppercase in keyspace #66

Open momohuri opened 10 years ago

momohuri commented 10 years ago

Hey, When I do that : var client = new cql.Client({hosts: ['myHost'], keyspace: 'Sources_RAW'});

I have the following error : message: 'Keyspace \'sources_raw\' does not exist',

I needed to re-create my keyspace lowercase for it to work (I am using cassandra 1.12)

And I am sure that the problem come from node-cassandra-cql because I ve tried with cassandra-client and it worked.

Thanks

jorgebay commented 10 years ago

The driver does not transform the keyspace casing in any way, Cassandra does.

Apparently, you created the keyspace case sensitive (probably with another driver), you can read a full thread about it.

In this case, you could use double quotes on the keyspace name to avoid Cassandra from lower casing it.

var client = new cql.Client({hosts: ['myHost'], keyspace: '"Sources_RAW"'});

I would avoid using case sensitive identifiers for keyspaces and column families when possible...