You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Vivek Mishra <mi...@gmail.com> on 2013/08/25 15:34:55 UTC

Issue with CQLsh

Hi,
I have created a column family using Cassandra-cli as:

create column family default;

and then inserted some record as:

set default[1]['type']='bytes';

Then i tried to alter table it via cqlsh as:

alter table default alter key type text;  // it works

alter table default alter column1 type text; // it goes for a toss

surprisingly any command after that, simple hangs and i need to reset
connection.


Any suggestions?

Re: Issue with CQLsh

Posted by Vivek Mishra <mi...@gmail.com>.
I understand that CQL <-> Thrift interoperability is an issue. For
Application which were build earlier(using thrift) there must be a way and
it should be at least give some error message, but it simply hangs with out
any error.

-Vivek


On Mon, Aug 26, 2013 at 8:42 AM, Jonathan Haddad <jo...@jonhaddad.com> wrote:

> My understanding is that if you want to use CQL, you should create your
> tables via CQL.  Mixing thrift calls w/ CQL seems like it's just asking for
> problems like this.
>
>
> On Sun, Aug 25, 2013 at 6:53 PM, Vivek Mishra <mi...@gmail.com>wrote:
>
>> cassandra 1.2.4
>>
>>
>> On Mon, Aug 26, 2013 at 2:51 AM, Nate McCall <na...@thelastpickle.com>wrote:
>>
>>> What version of cassandra are you using?
>>>
>>>
>>> On Sun, Aug 25, 2013 at 8:34 AM, Vivek Mishra <mi...@gmail.com>wrote:
>>>
>>>> Hi,
>>>> I have created a column family using Cassandra-cli as:
>>>>
>>>> create column family default;
>>>>
>>>> and then inserted some record as:
>>>>
>>>> set default[1]['type']='bytes';
>>>>
>>>> Then i tried to alter table it via cqlsh as:
>>>>
>>>> alter table default alter key type text;  // it works
>>>>
>>>> alter table default alter column1 type text; // it goes for a toss
>>>>
>>>> surprisingly any command after that, simple hangs and i need to reset
>>>> connection.
>>>>
>>>>
>>>> Any suggestions?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>
>
> --
> Jon Haddad
> http://www.rustyrazorblade.com
> skype: rustyrazorblade
>

Re: Issue with CQLsh

Posted by Jonathan Haddad <jo...@jonhaddad.com>.
My understanding is that if you want to use CQL, you should create your
tables via CQL.  Mixing thrift calls w/ CQL seems like it's just asking for
problems like this.


On Sun, Aug 25, 2013 at 6:53 PM, Vivek Mishra <mi...@gmail.com> wrote:

> cassandra 1.2.4
>
>
> On Mon, Aug 26, 2013 at 2:51 AM, Nate McCall <na...@thelastpickle.com>wrote:
>
>> What version of cassandra are you using?
>>
>>
>> On Sun, Aug 25, 2013 at 8:34 AM, Vivek Mishra <mi...@gmail.com>wrote:
>>
>>> Hi,
>>> I have created a column family using Cassandra-cli as:
>>>
>>> create column family default;
>>>
>>> and then inserted some record as:
>>>
>>> set default[1]['type']='bytes';
>>>
>>> Then i tried to alter table it via cqlsh as:
>>>
>>> alter table default alter key type text;  // it works
>>>
>>> alter table default alter column1 type text; // it goes for a toss
>>>
>>> surprisingly any command after that, simple hangs and i need to reset
>>> connection.
>>>
>>>
>>> Any suggestions?
>>>
>>>
>>>
>>>
>>>
>>
>


-- 
Jon Haddad
http://www.rustyrazorblade.com
skype: rustyrazorblade

Re: Issue with CQLsh

Posted by Vivek Mishra <mi...@gmail.com>.
cassandra 1.2.4


On Mon, Aug 26, 2013 at 2:51 AM, Nate McCall <na...@thelastpickle.com> wrote:

> What version of cassandra are you using?
>
>
> On Sun, Aug 25, 2013 at 8:34 AM, Vivek Mishra <mi...@gmail.com>wrote:
>
>> Hi,
>> I have created a column family using Cassandra-cli as:
>>
>> create column family default;
>>
>> and then inserted some record as:
>>
>> set default[1]['type']='bytes';
>>
>> Then i tried to alter table it via cqlsh as:
>>
>> alter table default alter key type text;  // it works
>>
>> alter table default alter column1 type text; // it goes for a toss
>>
>> surprisingly any command after that, simple hangs and i need to reset
>> connection.
>>
>>
>> Any suggestions?
>>
>>
>>
>>
>>
>

Re: Issue with CQLsh

Posted by Nate McCall <na...@thelastpickle.com>.
What version of cassandra are you using?


On Sun, Aug 25, 2013 at 8:34 AM, Vivek Mishra <mi...@gmail.com> wrote:

> Hi,
> I have created a column family using Cassandra-cli as:
>
> create column family default;
>
> and then inserted some record as:
>
> set default[1]['type']='bytes';
>
> Then i tried to alter table it via cqlsh as:
>
> alter table default alter key type text;  // it works
>
> alter table default alter column1 type text; // it goes for a toss
>
> surprisingly any command after that, simple hangs and i need to reset
> connection.
>
>
> Any suggestions?
>
>
>
>
>