Thanks!
On 12 March 2013 18:01, Michael Kjellman <mkjell...@barracuda.com> 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" <haithem.jarr...@struq.com> 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 <mkjell...@barracuda.com> 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" <haithem.jarr...@struq.com> > >>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 <jbel...@gmail.com> 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 > >> >> <haithem.jarr...@struq.com> 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. >
