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

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