Re: Why CQL returns data in byte format, while Hive de-serialize and return the data in readable format

2013-02-11 Thread aaron morton
I suggest trying Int32Type and Double http://www.datastax.com/docs/datastax_enterprise2.1/analytics/about_hive#mapping-hive-external-tables-to-cassandra-column-families Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On

Re: Why CQL returns data in byte format, while Hive de-serialize and return the data in readable format

2013-02-08 Thread Dinusha Dilrukshi
[1] If we insert the data using CQL and retrieve using CQL then it returns readable data. (not byte type). [2] If we insert the data using hive query and retrieve using hive query, it also returns readable data. (not byte type.) [3] Only if we insert data using hive query and then retrieve the data

Re: Why CQL returns data in byte format, while Hive de-serialize and return the data in readable format

2013-02-07 Thread Edward Capriolo
In cql3 a column must be all the same type . Since cql transposes columns the only thing they can be is byte array. Cql2 is better at compact tables in. This regard. On Thursday, February 7, 2013, Dinusha Dilrukshi wrote: > Hi, > > We are using same underlying column family and extract the data