You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cassandra.apache.org by Haithem Jarraya <ha...@struq.com> on 2013/03/12 18:41:59 UTC
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
Posted by Haithem Jarraya <ha...@struq.com>.
Thanks!
On 12 March 2013 18:01, Michael Kjellman <mk...@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" <ha...@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 <mk...@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" <ha...@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 <jb...@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
> >> >> <ha...@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.
>
Re: Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
Posted by Michael Kjellman <mk...@barracuda.com>.
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" <ha...@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 <mk...@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" <ha...@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 <jb...@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
>> >> <ha...@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.
Re: Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
Posted by Haithem Jarraya <ha...@struq.com>.
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 <mk...@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" <ha...@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 <jb...@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
> >> <ha...@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.
>
Re: Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
Posted by Michael Kjellman <mk...@barracuda.com>.
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" <ha...@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 <jb...@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
>> <ha...@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.
Re: Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
Posted by Haithem Jarraya <ha...@struq.com>.
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 <jb...@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
> <ha...@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
>
Re: Issue Upgrade to 1.2.2 from 1.2.1 Table column names changed
Posted by Jonathan Ellis <jb...@gmail.com>.
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
<ha...@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