Column Family missing from system.schema_columns
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 to get column families of a keyspace via CQL? But when I do from cqlsh terminal describe keyspace my keyspace; I retrieve all the column families. What am I missing? I am running a cassandra V1.2.1 Many Thanks, H
Re: Column Family missing from system.schema_columns
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 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 to get column families of a keyspace via CQL? > > > > But when I do from cqlsh terminal describe keyspace my keyspace; > > I retrieve all the column families. What am I missing? > > > > I am running a cassandra V1.2.1 > > > > > > Many Thanks, > > > > H > >
Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
Hi there, I am seeing an issue that I do not understand fully, I have a table A with columns a1 blob,a2 int ,a3 int, a4 uuid. I upgraded from 1.2.1 to 1.2.2 and also changed the compaction level to LeveledCompaction. Then I found that 2 of the 4 columns in my tables changed names. It is now Table A (a1 blob, column1 int, column2 int, a4 uuid) Nothing in the logs, when I do describe table A; I get column1 and column2. How this is possible? Also how to change my columns names to the previous names? All my prepared queries are failing now. Many Thanks, Haithem
Re: Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
Could you please point me to the right syntax for ALTER Table? couldn't find it Thanks, On 12 March 2013 17:45, Jonathan Ellis wrote: > You should use ALTER TABLE to give the columns meaningful names. The > autogenerated names are there as a convenience, and we do not > guarantee that they won't change between releases. > > On Tue, Mar 12, 2013 at 12:41 PM, Haithem Jarraya > wrote: > > Hi there, > > > > > > > > I am seeing an issue that I do not understand fully, > > > > I have a table A with columns a1 blob,a2 int ,a3 int, a4 uuid. > > > > I upgraded from 1.2.1 to 1.2.2 and also changed the compaction level to > > LeveledCompaction. > > > > Then I found that 2 of the 4 columns in my tables changed names. > > > > It is now Table A (a1 blob, column1 int, column2 int, a4 uuid) > > > > Nothing in the logs, when I do describe table A; I get column1 and > column2. > > > > How this is possible? > > > > Also how to change my columns names to the previous names? All my > prepared > > queries are failing now. > > > > > > > > Many Thanks, > > > > > > > > Haithem > > > > > > > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder, http://www.datastax.com > @spyced >
Re: Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
I have seen this doc, but it is to change the type of the column not the column name. On 12 March 2013 17:53, Michael Kjellman wrote: > http://www.datastax.com/docs/1.2/index > http://www.datastax.com/docs/1.2/cql_cli/using/alter > > The users list might be a better place for this discussion if you need > further help. > > On 3/12/13 10:50 AM, "Haithem Jarraya" wrote: > > >Could you please point me to the right syntax for ALTER Table? couldn't > >find it > > > >Thanks, > > > > > >On 12 March 2013 17:45, Jonathan Ellis wrote: > > > >> You should use ALTER TABLE to give the columns meaningful names. The > >> autogenerated names are there as a convenience, and we do not > >> guarantee that they won't change between releases. > >> > >> On Tue, Mar 12, 2013 at 12:41 PM, Haithem Jarraya > >> wrote: > >> > Hi there, > >> > > >> > > >> > > >> > I am seeing an issue that I do not understand fully, > >> > > >> > I have a table A with columns a1 blob,a2 int ,a3 int, a4 uuid. > >> > > >> > I upgraded from 1.2.1 to 1.2.2 and also changed the compaction level > >>to > >> > LeveledCompaction. > >> > > >> > Then I found that 2 of the 4 columns in my tables changed names. > >> > > >> > It is now Table A (a1 blob, column1 int, column2 int, a4 uuid) > >> > > >> > Nothing in the logs, when I do describe table A; I get column1 and > >> column2. > >> > > >> > How this is possible? > >> > > >> > Also how to change my columns names to the previous names? All my > >> prepared > >> > queries are failing now. > >> > > >> > > >> > > >> > Many Thanks, > >> > > >> > > >> > > >> > Haithem > >> > > >> > > >> > > >> > >> > >> > >> -- > >> Jonathan Ellis > >> Project Chair, Apache Cassandra > >> co-founder, http://www.datastax.com > >> @spyced > >> > > > Copy, by Barracuda, helps you store, protect, and share all your amazing > > things. Start today: www.copy.com. >
Re: Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
Thanks! On 12 March 2013 18:01, Michael Kjellman wrote: > Showed up as the first result on Google for me: > > http://www.datastax.com/docs/1.2/cql_cli/cql/ALTER_TABLE#rename-col > > > On 3/12/13 10:56 AM, "Haithem Jarraya" wrote: > > >I have seen this doc, but it is to change the type of the column not the > >column name. > > > > > >On 12 March 2013 17:53, Michael Kjellman wrote: > > > >> http://www.datastax.com/docs/1.2/index > >> http://www.datastax.com/docs/1.2/cql_cli/using/alter > >> > >> The users list might be a better place for this discussion if you need > >> further help. > >> > >> On 3/12/13 10:50 AM, "Haithem Jarraya" > >>wrote: > >> > >> >Could you please point me to the right syntax for ALTER Table? > >>couldn't > >> >find it > >> > > >> >Thanks, > >> > > >> > > >> >On 12 March 2013 17:45, Jonathan Ellis wrote: > >> > > >> >> You should use ALTER TABLE to give the columns meaningful names. The > >> >> autogenerated names are there as a convenience, and we do not > >> >> guarantee that they won't change between releases. > >> >> > >> >> On Tue, Mar 12, 2013 at 12:41 PM, Haithem Jarraya > >> >> wrote: > >> >> > Hi there, > >> >> > > >> >> > > >> >> > > >> >> > I am seeing an issue that I do not understand fully, > >> >> > > >> >> > I have a table A with columns a1 blob,a2 int ,a3 int, a4 uuid. > >> >> > > >> >> > I upgraded from 1.2.1 to 1.2.2 and also changed the compaction > >>level > >> >>to > >> >> > LeveledCompaction. > >> >> > > >> >> > Then I found that 2 of the 4 columns in my tables changed names. > >> >> > > >> >> > It is now Table A (a1 blob, column1 int, column2 int, a4 uuid) > >> >> > > >> >> > Nothing in the logs, when I do describe table A; I get column1 and > >> >> column2. > >> >> > > >> >> > How this is possible? > >> >> > > >> >> > Also how to change my columns names to the previous names? All my > >> >> prepared > >> >> > queries are failing now. > >> >> > > >> >> > > >> >> > > >> >> > Many Thanks, > >> >> > > >> >> > > >> >> > > >> >> > Haithem > >> >> > > >> >> > > >> >> > > >> >> > >> >> > >> >> > >> >> -- > >> >> Jonathan Ellis > >> >> Project Chair, Apache Cassandra > >> >> co-founder, http://www.datastax.com > >> >> @spyced > >> >> > >> > >> > >> Copy, by Barracuda, helps you store, protect, and share all your amazing > >> > >> things. Start today: www.copy.com. > >> > > > Copy, by Barracuda, helps you store, protect, and share all your amazing > > things. Start today: www.copy.com. >
