Row_key from sstable2json to actual value of the key

2014-04-03 Thread ng 
sstable2json tomcat-t5-ic-1-Data.db -e
gives me

0021
001f
0020


How do I convert this (hex) to actual value of column so I can do below

select * from tomcat.t5 where c1='concerted value';

Thanks in advance for the help.

Re: Row_key from sstable2json to actual value of the key

2014-04-03 Thread Colin Blower 
Hey ng,

You can use CQL and Cassandra do the conversion if you would like. If
your table uses int type keys:
 select * from tomcat.tx where c1 = blobAsInt(0x0021);

The relevant section of the CQL3 docs are here:
http://cassandra.apache.org/doc/cql3/CQL.html#blobFun

You can use blobAs... for any type. I hope this help.


On 04/03/2014 08:50 AM, ng wrote:
 sstable2json tomcat-t5-ic-1-Data.db -e
 gives me
  
 0021
 001f
 0020
  
  
 How do I convert this (hex) to actual value of column so I can do below
  
 select * from tomcat.t5 where c1='concerted value';
  
 Thanks in advance for the help.



-- 
*Colin Blower*
/Software Engineer/
Barracuda Networks Inc.
+1 408-342-5576 (o)

===

Find out how eSigning generates significant financial benefit.
Read the Barracuda SignNow ROI whitepaper at 
https://signnow.com/l/business/esignature_roi