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

2013-02-10 Thread Dinusha Dilrukshi
FloatType. 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 On 10/02/2013, at 4:15 PM, Dinusha Dilrukshi

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
: 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

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

2013-01-31 Thread Dinusha Dilrukshi
= 1965 but your query is not supported (for 2nd indexes that is). -- Sylvain On Thu, Jan 31, 2013 at 7:22 AM, Dinusha Dilrukshi sdddilruk...@gmail.com wrote: Hi All, I have created a column family as follows. (With secondary indexes.) create column family users with comparator=UTF8Type

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},

Re: Any improvements in Cassandra JDBC driver ?

2012-03-29 Thread Dinusha Dilrukshi
, 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 PM *To:* user@cassandra.apache.org *Subject:* Any improvements in Cassandra JDBC

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

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 exception

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 eev...@acunu.com wrote: On Thu, Dec 8, 2011 at 4:20 AM, Dinusha Dilrukshi sdddilruk...@gmail.com 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

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,

Re: Setting Key Validation Class

2011-12-05 Thread Dinusha Dilrukshi
=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 sdddilruk...@gmail.com wrote: Hi, I am using apache-cassandra-1.0.0 and I tried to insert/retrieve data in a column family using cassandra-jdbc