Re: Issues with writing data to Cassandra column family using a Hive script

2013-02-10 Thread Dinusha Dilrukshi
e. > > http://www.datastax.com/docs/datastax_enterprise2.2/solutions/about_hive#hive-to-cassandra-table-mapping > > Cheers > > > - > Aaron Morton > Freelance Cassandra Developer > New Zealand > > @aaronmorton > http://www.thelastpickle.com > &g

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
umn 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 c

Re: Error when using CQL driver : No indexed columns present in by-columns clause with "equals" operator

2013-01-31 Thread Dinusha Dilrukshi
; select * from users where birth_year = 1965 > but your query is not supported (for 2nd indexes that is). > > -- > Sylvain > > > On Thu, Jan 31, 2013 at 7:22 AM, Dinusha Dilrukshi > wrote: > >> Hi All, >> >> I have created a column family as

Error when using CQL driver : No indexed columns present in by-columns clause with "equals" operator

2013-01-30 Thread Dinusha Dilrukshi
Hi All, I have created a column family as follows. (With secondary indexes.) create column family users with comparator=UTF8Type and key_validation_class = 'UTF8Type' and default_validation_class = 'UTF8Type' and column_metadata=[{column_name: full_name, validation_class: UTF8Type}, {column_nam

Cassandra-jdbc-1.1.1 driver compatibility with Cassandra servers

2012-08-09 Thread Dinusha Dilrukshi
Does cassandra-jdbc-1.1.1 driver can be used with Cassandra server 1.0.0 version ? Or does it support only the Cassandra server versions 1.1.0 and later ? Regards, ~Dinusha~

Re: Any improvements in Cassandra JDBC driver ?

2012-03-29 Thread Dinusha Dilrukshi
all act like "UPDATE OR INSERT", if the > thing is there it get over written, if it isn't there it gets inserted. > > -Jeremiah > > > -- > *From:* Dinusha Dilrukshi [sdddilruk...@gmail.com] > *Sent:* Wednesday, March 28, 2012 11:41

Any improvements in Cassandra JDBC driver ?

2012-03-28 Thread Dinusha Dilrukshi
Hi, We are using Cassandra JDBC driver (found in [1]) to call to Cassandra sever using CQL and JDBC calls. One of the main disadvantage is, this driver is not available in maven repository where people can publicly access. Currently we have to checkout the source and build ourselves. Is there any

Re: Cassandra jdbc-driver: no viable alternative at character '?'

2011-12-08 Thread Dinusha Dilrukshi
Hi Evans, On Thu, Dec 8, 2011 at 8:59 PM, Eric Evans wrote: > On Thu, Dec 8, 2011 at 4:20 AM, Dinusha Dilrukshi > wrote: > > I am using cassandra-jdbc driver and following is my code snip written > for > > delete a entry from column family. > > Where did you get th

Cassandra jdbc-driver: no viable alternative at character '?'

2011-12-08 Thread Dinusha Dilrukshi
Hi, I am using cassandra-jdbc driver and following is my code snip written for delete a entry from column family. String query1 = "delete from USER where key=?"; PreparedStatement stmt = con.prepareStatement(query1); stmt.setString(1, "dinusha"); stmt.execute(); But I am getting following except

Re: Setting Key Validation Class

2011-12-05 Thread Dinusha Dilrukshi
ass=>column_values > comparator=>column_name > > default_validation_class is global scope of validation_class > > > > On Mon, Dec 5, 2011 at 10:10 PM, Dinusha Dilrukshi > wrote: > >> Hi, >> >> I am using apache-cassandra-1.0.0 and I tried to insert/retrieve da

Setting Key Validation Class

2011-12-05 Thread Dinusha Dilrukshi
Hi, I am using apache-cassandra-1.0.0 and I tried to insert/retrieve data in a column family using cassandra-jdbc program. Here is how I created 'USER' column family using cassandra-cli. create column family USER with comparator=UTF8Type and column_metadata=[{column_name: user_id, validation_clas