Re: CDH4 + Cassandra 1.2 Integration Issue

2013-04-11 Thread aaron morton 
cqlsh in cassandra 1.2 defaults to cql 3. 
-
Aaron Morton
Freelance Cassandra Consultant
New Zealand

@aaronmorton
http://www.thelastpickle.com

On 10/04/2013, at 6:55 PM, Gurminder Gill gurminde...@hotmail.com wrote:

 Ah ha. So, the client defaults to CQL 2. Anyway of changing that? I tired 
 libthrift 0.9 as well but it doesn't work.
 
 Thanks.
 
 
 On Tue, Apr 9, 2013 at 11:29 PM, Shamim sre...@yandex.ru wrote:
 Hello,
   if you created your table user with cql then you have to add COMPACT 
 STORAGE as follows:
 CREATE TABLE user (
   id int PRIMARY KEY,
   age int,
   fname text,
   lname text
 ) WITH COMPACT STORAGE
 
 
 
 
 --
 Best regards
   Shamim A.
 
 
 
 10.04.2013, 08:22, Gurminder Gill gurminde...@hotmail.com:
  I was able to start a MR job after patching Cassandra.Hadoop as per 
  CASSANDRA-5201.
 
  But then, ColumnFamilyRecordReader pukes within the MapTask. It is unable 
  to read CF definition in the sample keyspace. The CF user does exist.
  How can cf_defs below be possibly empty? Any pointers?
 
  KsDef.toString() during Read Operation from within the MapTask :-
 
  KsDef(name:wordcount, 
  strategy_class:org.apache.cassandra.locator.SimpleStrategy, 
  strategy_options:{replication_factor=1}, cf_defs:[], durable_writes:true)
 
  Output from cqlsh :-
 
  cqlsh describe keyspace wordcount;
 
  CREATE KEYSPACE wordcount WITH replication = {
'class': 'SimpleStrategy',
'replication_factor': '1'
  };
 
  USE wordcount;
 
  CREATE TABLE user (
id int PRIMARY KEY,
age int,
fname text,
lname text
  ) WITH
bloom_filter_fp_chance=0.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
read_repair_chance=0.10 AND
replicate_on_write='true' AND
compaction={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};

Re: CDH4 + Cassandra 1.2 Integration Issue

2013-04-10 Thread Gurminder Gill 
Ah ha. So, the client defaults to CQL 2. Anyway of changing that? I tired
libthrift 0.9 as well but it doesn't work.

Thanks.


On Tue, Apr 9, 2013 at 11:29 PM, Shamim sre...@yandex.ru wrote:

 Hello,
   if you created your table user with cql then you have to add COMPACT
 STORAGE as follows:
 CREATE TABLE user (
   id int PRIMARY KEY,
   age int,
   fname text,
   lname text
 ) WITH COMPACT STORAGE




 --
 Best regards
   Shamim A.



 10.04.2013, 08:22, Gurminder Gill gurminde...@hotmail.com:
  I was able to start a MR job after patching Cassandra.Hadoop as
 per CASSANDRA-5201.
 
  But then, ColumnFamilyRecordReader pukes within the MapTask. It is
 unable to read CF definition in the sample keyspace. The CF user does
 exist.
  How can cf_defs below be possibly empty? Any pointers?
 
  KsDef.toString() during Read Operation from within the MapTask :-
 
  KsDef(name:wordcount,
 strategy_class:org.apache.cassandra.locator.SimpleStrategy,
 strategy_options:{replication_factor=1}, cf_defs:[], durable_writes:true)
 
  Output from cqlsh :-
 
  cqlsh describe keyspace wordcount;
 
  CREATE KEYSPACE wordcount WITH replication = {
'class': 'SimpleStrategy',
'replication_factor': '1'
  };
 
  USE wordcount;
 
  CREATE TABLE user (
id int PRIMARY KEY,
age int,
fname text,
lname text
  ) WITH
bloom_filter_fp_chance=0.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
read_repair_chance=0.10 AND
replicate_on_write='true' AND
compaction={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};