Re: Composite Slice Query returning non-sliced data

2012-07-10 Thread Sunit Randhawa
I have tested this extensively and EOC has huge issue in terms of usability of CompositeTypes in Cassandra. As an example: If you have 2 Composite Columns such as A:B:C and A:D:C. And if you do search on A:B as start and end Composite Components, it will return D as well. Because it returns all t

Re: Composite Slice Query returning non-sliced data

2012-07-09 Thread Sunit Randhawa
te in CLI and this is what it printed. > > and then > > This is how I did the read in the CLI and this is what it printed. > > It's hard to imagine what data is in cassandra based on code. > > cheers > > ----- > Aaron Morton > Freelance Developer &

Re: Composite Slice Query returning non-sliced data

2012-07-06 Thread Sunit Randhawa
> Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 6/07/2012, at 11:30 AM, Sunit Randhawa wrote: > > HI Aaron, > > It is > > create column family CF >with comparator = > 'CompositeType(org.apache.cassandra.db.marshal.Int32Type,org.

Re: Composite Slice Query returning non-sliced data

2012-07-05 Thread Sunit Randhawa
F definition ? > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 6/07/2012, at 7:26 AM, Sunit Randhawa wrote: > > Hello, > > I have 2 Columns for a 'RowKey' as below: > >

Composite Slice Query returning non-sliced data

2012-07-05 Thread Sunit Randhawa
Hello, I have 2 Columns for a 'RowKey' as below: #1 : set CF['RowKey']['1000']='A=1,B=2'; #2: set CF['RowKey']['1000:C1']='A=2,B=3''; #2 has the Composite Column and #1 does not. Now when I execute the Composite Slice query by 1000 and C1, I do get both the columns above. I am hoping get #2

HColumn.getName() appending special characters

2012-05-02 Thread Sunit Randhawa
Hello, Code snippet below is printing out column names and values: MultigetSliceQuery multigetSliceQuery = HFactory.createMultigetSliceQuery(keyspace, stringSerializer, stringSerializer, stringSerializer); for (HColumn column : c){ System.out.println("C

Re: Storing Counters in Hive

2012-03-20 Thread Sunit Randhawa
ounters. > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 20/03/2012, at 1:09 PM, Sunit Randhawa wrote: > > I am trying to store Counters CF from cassandra to Hive. Below is the > CREATE TABLE syntax in

Storing Counters in Hive

2012-03-19 Thread Sunit Randhawa
I am trying to store Counters CF from cassandra to Hive. Below is the CREATE TABLE syntax in Hive: DROP TABLE IF EXISTS Counters; create external table Counters(row_key string, column_name string, value string) STORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler' WITH SERDEPROPERTI

CLI command for adding composite Key

2012-01-13 Thread Sunit Randhawa
Hello, Wondering how would one add Composite Keys rows using CLI. Supposing we have CF defined below: create column family ListTransactions with comparator = 'CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.IntegerType)' and keys_cached=1 and rows_cache

Deciding on CF

2012-01-05 Thread Sunit Randhawa
Hello, We are working on some new cassandra requirements and I wanted to get your recommendations on how to go ahead and put schema in place in terms of how many CF one should have for below scenario: 1- There are 10 applications. Out of which 1 or 2 applications are very active giving 90%+ load.