Hi,
I know one way is to execute cql query via thrift client to create a
column family having compound primary/composite columns. But is it the only
way?
Looks like i would end up creating own "CQLTranslator/Wrapper" to deal
with compound primary/composite columns!(Or may be something else in n
Ok the '--' was the problem ... LOL
2012/6/26 Juan Ezquerro
> Hi,
>
> I create this column family:
>
>
> CREATE COLUMN FAMILY Clients
> WITH column_type='Super'
> AND key_validation_class = LongType -- master_id
> A
Hi,
I create this column family:
CREATE COLUMN FAMILY Clients
WITH column_type='Super'
AND key_validation_class = LongType -- master_id
AND comparator = LongType -- client_id
AND subcomparator = UTF8Type
AND column_metadata = [
{column_name: client_name, valida
On Wed, May 23, 2012 at 3:07 PM, aaron morton wrote:
> When you say
>
> comparator=BytesType
>
>
> You are telling cassandra that the column names in the CF's are just
> bytes. But when you create the column meta data you are specifying the
> column names as strings.
>
> use UTF8Type as the compa
reelance Developer
@aaronmorton
http://www.thelastpickle.com
On 22/05/2012, at 11:09 PM, Roshan Dawrani wrote:
> Hi,
>
> I use Cassandra 0.8.5 and am suddenly noticing some strange behavior. I run a
> "create column family" command with some column meta-data and it runs fine,
>
Type
> Index Name: ACUserIdIdx
> Index Type: KEYS
>
>
> On Tue, May 22, 2012 at 6:16 PM, samal wrote:
>
>> Change your comparator to utf8type.
>> On 22-May-2012 4:32 PM, "Roshan Dawrani" wrote:
>>
>>> Hi,
>>>
&
:32 PM, "Roshan Dawrani" wrote:
>
>> Hi,
>>
>> I use Cassandra 0.8.5 and am suddenly noticing some strange behavior. I
>> run a "create column family" command with some column meta-data and it runs
>> fine, but when I do "describe keyspace", i
Change your comparator to utf8type.
On 22-May-2012 4:32 PM, "Roshan Dawrani" wrote:
> Hi,
>
> I use Cassandra 0.8.5 and am suddenly noticing some strange behavior. I
> run a "create column family" command with some column meta-data and it runs
> fine, but when
Hi,
I use Cassandra 0.8.5 and am suddenly noticing some strange behavior. I run
a "create column family" command with some column meta-data and it runs
fine, but when I do "describe keyspace", it shows me different column names
for those index columns.
a) Here is what I
Hi,
I use Cassandra 0.8.5 and am suddenly noticing some strange behavior. I run
a "create column family" command with some column meta-data and it runs
fine, but when I do "describe keyspace", it shows me different column names
for those index columns.
a) Here is what I
thank u *:))*
On Sat, Mar 31, 2012 at 4:51 AM, aaron morton wrote:
> This works…
>
>
> create column family student
> with comparator = 'AsciiType'
> and column_metadata =
> [{
> column_name : name,
> validation_class : 'AsciiType'
>
pt:
>>
>>
>> create COLUMNFAMILY users
>>
>> (KY uuid PRIMARY KEY*,*
>>
>> firstname text,
>>
>> lastname text,
>>
>> email text,
>>
>> address text,
>>
>> zip int,
>>
>> state text);**
>>
>&g
> email text,
>
> address text,
>
> zip int,
>
> state text);
>
>
> From: puneet loya [mailto:puneetl...@gmail.com]
> Sent: Tuesday, March 27, 2012 5:54 PM
> To: user@cassandra.apache.org
> Subject: create column family
>
>
> create colum
This works…
create column family student
with comparator = 'AsciiType'
and column_metadata =
[{
column_name : name,
validation_class : 'AsciiType'
}];
* use compatator instead of coluimn_type.
* closing ' missing
Cheers
-
Aaron M
27, 2012 5:54 PM
> *To:* user@cassandra.apache.org
> *Subject:* create column family
>
>
>
> create column family users
>
> (uuid PRIMARY KEY
>
> firstname text,
>
> lastname text,
>
> email text,
>
> address text,
>
> zip int,
>
create column family users
(uuid PRIMARY KEY
firstname text,
lastname text,
email text,
address text,
zip int,
state text);
Is dis above statement correct?
I m getting an error " Syntax error at position 27: missing EOF at '(' "
Do reply
Can u suggest the most stable version of cassandra??
create column family student
with column_type = 'AsciiType'
and column_metadata =
[{
column_name : name,
validation_class : 'AsciiType
}];
On Tue, Mar 27, 2012 at 1:48 PM, Guy Incognito wrote:
> why don't you show us the command you're actually trying to
can i use comparator='utf8' or not??
Please reply
On Mon, Mar 26, 2012 at 9:17 PM, R. Verlangen mailto:ro...@us2.nl>> wrote:
You should use the full type names, e.g.
create column family MyColumnFamily with comparator=UTF8Type;
ype before.. It gave the same error.
>>
>> On executing help assume command it is giving 'utf8' as a type.
>>
>> so can i use comparator='utf8' or not??
>>
>>
>> Please reply
>>
>>
>> On Mon, Mar 26, 2012 at 9:
; so can i use comparator='utf8' or not??
>
>
> Please reply
>
>
> On Mon, Mar 26, 2012 at 9:17 PM, R. Verlangen wrote:
>
>> You should use the full type names, e.g.
>>
>> create column family MyColumnFamily with comparator=UTF8Type;
>>
>&g
names, e.g.
>
> create column family MyColumnFamily with comparator=UTF8Type;
>
>
> 2012/3/26 puneet loya
>
>> It is giving errors like " Unable to find abstract-type class
>> 'org.apache.cassandra.db.marshal.utf8' "
>>
>> and java.lan
You should use the full type names, e.g.
create column family MyColumnFamily with comparator=UTF8Type;
2012/3/26 puneet loya
> It is giving errors like " Unable to find abstract-type class
> 'org.apache.cassandra.db.marshal.utf8' "
>
>
It is giving errors like " Unable to find abstract-type class
'org.apache.cassandra.db.marshal.utf8' "
and java.lang.RuntimeException:
org.apache.cassandra.db.marshal.MarshalException: cannot parse
'catalogueId' as hex bytes
where catalogueId is a column that has utf8 as its data type. they may b
not too late to deprecate the old,
unclear syntax.
Don
From: ehers...@gmail.com [ehers...@gmail.com]
Sent: Thursday, December 22, 2011 10:20 AM
To: user@cassandra.apache.org
Subject: Re: Suggestion about syntax of CREATE COLUMN FAMILY
Doesn't CQL have t
m:* Stephen Pope [stephen.p...@quest.com]
> *Sent:* Monday, December 12, 2011 6:34 AM
> *To:* user@cassandra.apache.org
> *Subject:* RE: Suggestion about syntax of CREATE COLUMN FAMILY
>
> I’d like to second this. I’ve been working with Cassandra for a good
> while now, but when
t; cqlsh is 'the future.'"
Don
From: Stephen Pope [stephen.p...@quest.com]
Sent: Monday, December 12, 2011 6:34 AM
To: user@cassandra.apache.org
Subject: RE: Suggestion about syntax of CREATE COLUMN FAMILY
I’d like to second this. I’ve been working
fusing.
>
>
> ** **
>
> *From:* Don Smith [mailto:dsm...@likewise.com]
> *Sent:* Friday, December 09, 2011 3:41 PM
> *To:* user@cassandra.apache.org
> *Subject:* Suggestion about syntax of CREATE COLUMN FAMILY
>
> ** **
>
> Currently, the syntax for creating co
syntax of CREATE COLUMN FAMILY
Currently, the syntax for creating column families is like this:
create column family Users
with comparator=UTF8Type
and default_validation_class=UTF8Type
and key_validation_class=UTF8Type;
It's not clear what "comparator" and "default_validation_
Currently, the syntax for creating column families is like this:
create column family Users
with comparator=UTF8Type
and default_validation_class=UTF8Type
and key_validation_class=UTF8Type;
It's not clear what "comparator" and "default_validation_class" refer to. Much
ng it easier for the next person, I
> repurposed this message to document what I figured out. I'll also
> update the wiki. Here is the syntax:
>
> create column family MyCF
>with key_validation_class = 'CompositeType(UTF8Type, IntegerType)'
>and comp
n the hope of making it easier for the next person, I
repurposed this message to document what I figured out. I'll also
update the wiki. Here is the syntax:
create column family MyCF
with key_validation_class = 'CompositeType(UTF8Type, IntegerType)'
and comparator = 'Compos
That does the trick. Thanks. I should've read FAQ more thoroughly.
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/create-column-family-or-keyspace-returns-null-tp6658215p6658464.html
Sent from the cassandra-u...@incubator.apache.org ma
e 139) Fatal exception in thread Thread[HintedHandoff:4,1,main]
>
> keeps on coming back. And I still can't create any column family or
> keyspace.
>
> --
> View this message in context:
> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/create-
space.
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/create-column-family-or-keyspace-returns-null-tp6658215p6658286.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive at
Nabble.com.
seeing the
> exact problem reported in
> https://issues.apache.org/jira/browse/CASSANDRA-2946. And any "create
> column family xyz" returns null. Is it related to CASSANDRA-2946?
>
> --
> View this message in context:
> http://cassandra-user-incubator-apache-org.30651
I got a 5-node cluster running on 0.8.2. From the system log I'm seeing the
exact problem reported in
https://issues.apache.org/jira/browse/CASSANDRA-2946. And any "create
column family xyz" returns null. Is it related to CASSANDRA-2946?
--
View this message in context:
http:/
k, didn´t know that. Now it starts up, but throws a new exception:
>
> --------- Log --
>
> [defa...@test] create column family Test with comparator=LexicalUUIDType
> and column_metadata=[{column_name:test1, validation_class:LexicalUUIDType,
> index_type
ata. AaronOn 17 Nov, 2010,at 10:29 AM, André Fiedler wrote:Ah ok, didn´t know that. Now it starts up, but throws a new exception:- Log --[defa...@test] create column family Test with comparator=LexicalUUIDType and column_metadata
Ah ok, didn´t know that. Now it starts up, but throws a new exception:
- Log --
[defa...@test] create column family Test with comparator=LexicalUUIDType and
column_metadata=[{column_name:test1, validation_class:LexicalUUIDType,
index_type:0
startup. And get the log below. How to fix this?
----- Action ------
create column family Test with comparator=LexicalUUIDType and column_metadata=[
{column_name:test1, validation_class:LexicalUUIDType, index_type:0, index_name:test1},
{column_name:test2, validatio
an...@googlemail.com> wrote:
>>>
>>>> I try to perform the following action after a clean startup. And get the
>>>> log below. How to fix this?
>>>>
>>>> - Action --
>>>>
>>>&g
6, 2010 at 3:38 PM, André Fiedler <
>> fiedler.an...@googlemail.com> wrote:
>>
>>> I try to perform the following action after a clean startup. And get the
>>> log below. How to fix this?
>>>
>>> - Action -
he following action after a clean startup. And get the
>> log below. How to fix this?
>>
>> ----- Action --
>>
>> create column family Test with comparator=LexicalUUIDType and
>> column_metadata=[
>>
- Action ------
>
> create column family Test with comparator=LexicalUUIDType and
> column_metadata=[
>
> {column_name:test1, validation_class:LexicalUUIDType, index_type:0,
> index_name:test1},
>
> {column_name:test2, validation_class:UTF8Ty
I try to perform the following action after a clean startup. And get the log
below. How to fix this?
- Action --
create column family Test with comparator=LexicalUUIDType and
column_metadata=[
{column_name:test1
This is fixed in trunk.
On Wed, Oct 13, 2010 at 5:41 PM, Dmitri Smirnov wrote:
> I am experiencing an error while using cassandra_cli while attempting to
> create a column familiy.
> Using 0.7beta2.
>
> create column family ABTest with column_type = 'Super' and comp
I am experiencing an error while using cassandra_cli while attempting to
create a column familiy.
Using 0.7beta2.
create column family ABTest with column_type = 'Super' and comparator =
'LongType' and rows_cached = 1 and subcomparator = 'UTF8Type' and
47 matches
Mail list logo
