incubator-cassandra-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Kjellman <mkjell...@barracuda.com>
Subject Re: Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
Date Tue, 12 Mar 2013 18:01:20 GMT
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.jarraya@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 <mkjellman@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.jarraya@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 <jbellis@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.jarraya@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.

Mime
View raw message