Create a user-defined type with Cassandra

Question

I am trying to create a user defined type with Cassandra. I am using cqlsh and the example provided in the documentation (http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/cqlRefcreateType.html):

REATE TYPE address (
  street text,
  city text,
  zip_code int,
  phones set<text>
)

But this returns:

Bad Request: line 1:7 no viable alternative at input 'TYPE'

Using the help command, I found the 'CREATE_TABLE_TYPES' but I could not get it to work either.

What is the correcft syntax to get this to work?

Many thanks

Which Cassandra version are you using? User-types are part of 2.1 and later — Mikhail Stepura, Nov 03 '14 at 19:06

score 1 · Answer 1 · answered Nov 03 '14 at 21:43

1

Looks like you need to create a keyspace first:

cqlsh> CREATE KEYSPACE excelsior
   ...   WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 };
cqlsh> use excelsior;
cqlsh:excelsior> CREATE TYPE address (
             ...   street text,
             ...   city text,
             ...   zip_code int,
             ...   phones set<text>
             ... );

answered Nov 03 '14 at 21:43

catpaws

2,263
16
18

That's not the case. He/she was using 2.0.x, which doesn't support user types; – Mikhail Stepura Nov 03 '14 at 22:31

score 0 · Accepted Answer · answered Dec 01 '14 at 10:48

0

I also struck with same problem. User type doesn't supported by earlier version of 2.1. Now i am using 2.1.2 version of cassandra.

You can find it NEW FEATURES of Cassandra

answered Dec 01 '14 at 10:48

rahul

1,062
5
15
31

Create a user-defined type with Cassandra

2 Answers2