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%+

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

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

Re: Storing Counters in Hive

2012-03-20 Thread Sunit Randhawa
- 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 Hive: DROP TABLE IF EXISTS Counters; create external

HColumn.getName() appending special characters

2012-05-02 Thread Sunit Randhawa
Hello, Code snippet below is printing out column names and values: MultigetSliceQueryString, String, String multigetSliceQuery = HFactory.createMultigetSliceQuery(keyspace, stringSerializer, stringSerializer, stringSerializer); for (HColumnString, String column : c){

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

Re: Composite Slice Query returning non-sliced data

2012-07-05 Thread Sunit Randhawa
? 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: #1 : set CF['RowKey']['1000']='A=1,B=2'; #2: set CF['RowKey']['1000:C1']='A=2,B=3

Re: Composite Slice Query returning non-sliced data

2012-07-06 Thread Sunit Randhawa
- Aaron Morton 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

Re: Composite Slice Query returning non-sliced data

2012-07-09 Thread Sunit Randhawa
, at 1:28 PM, Sunit Randhawa wrote: Aaron, For writing, i am using cli. Below is the piece of code that is reading column names of different types. Composite start = new Composite(); start.addComponent(0, beginTime, Composite.ComponentEquality.EQUAL); if (columns != null){ int colCount =1

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