RE: COPY command not working

2013-03-01 Thread Pushkar Prasad
Aleksey, Thanks for the update. Can you tell me if there is any workaround for this? I want to use compound keys, and want to use COPY command. Thanks Pushkar -Original Message- From: Aleksey Yeschenko [mailto:alek...@yeschenko.com] Sent: 01 March 2013 23:12 To: dev@cassandra.apache.org

Re: Column Family missing from system.schema_columns

2013-03-01 Thread Haithem Jarraya
thanks, it works like a charm. On 1 March 2013 17:37, Aleksey Yeschenko wrote: > You are missing key_aliases and column_aliases from > system.schema_columnfamies. > > -- > AY > > > On Friday, March 1, 2013 at 18:38 PM, Haithem Jarraya wrote: > > > Hi, > > > > I wanted to retrieve all the column

Re: COPY command not working

2013-03-01 Thread Aleksey Yeschenko
This is being caused by stricter validation in 1.2.2. I opened a ticket https://issues.apache.org/jira/browse/CASSANDRA-5305 - thanks for the report. -- AY On Friday, March 1, 2013 at 19:08 PM, Pushkar Prasad wrote: > Hi, > > I am unable to run the COPY command in cassandra. Here is the Col

Re: Column Family missing from system.schema_columns

2013-03-01 Thread Aleksey Yeschenko
You are missing key_aliases and column_aliases from system.schema_columnfamies. -- AY On Friday, March 1, 2013 at 18:38 PM, Haithem Jarraya wrote: > Hi, > > I wanted to retrieve all the column families related to mykeyspace, so I > ran the following query: > > SELECT columnfamily_name FROM s

COPY command not working

2013-03-01 Thread Pushkar Prasad
Hi, I am unable to run the COPY command in cassandra. Here is the ColumnFamily that I am using CREATE TABLE ap_perf_sample_data_tbl( ap_mac varchar, ap_proto int, stime int, ap_active_status int, bytes_from_dev int, bytes_to_dev int, locatio

RE: Column Family missing from system.schema_columns

2013-03-01 Thread Pushkar Prasad
Hi, I am unable to run the COPY command in cassandra. Here is the ColumnFamily that I am using CREATE TABLE ap_perf_sample_data_tbl( ap_mac varchar, ap_proto int, stime int, ap_active_status int, bytes_from_dev int, bytes_to_dev int, locatio

Column Family missing from system.schema_columns

2013-03-01 Thread Haithem Jarraya
Hi, I wanted to retrieve all the column families related to mykeyspace, so I ran the following query: SELECT columnfamily_name FROM system.schema_columns WHERE keyspace_name='mykeyspace'; I am missing two column family, I am not sure if this is the normal behavior or not? Are there any other way