No, you can't. Keep in mind parts of the primary key are immutable, so
there would be no usability difference between a frozen UDT in your PK and
a non-frozen one other than the frozen keyword.
On Mon, Oct 10, 2016 at 10:07 PM Andrew Tolbert
wrote:
> Is it possible to use fields on the UDT as p
>
> Is it possible to use fields on the UDT as primary / cluster keys?
That is not supported as far as I know. In that case it's probably best to
either use a frozen UDT or make the field a separate column.
Thanks,
Andy
On Mon, Oct 10, 2016 at 11:50 PM, Jonathan Haddad wrote:
> Works for me.
Is it possible to use fields on the UDT as primary / cluster keys?
On Tue, Oct 11, 2016 at 9:49 AM, Ali Akhtar wrote:
> Yeah, you're right, it does work if I run it thru cqlsh. I was using
> DevCenter which shows that error.
>
> On Tue, Oct 11, 2016 at 9:48 AM, Andrew Tolbert <
> andrew.tolb...@
Works for me. You can see the version, CREATE TYPE, CREATE TABLE,
insertion, and describing the table
jhaddad@rustyrazorblade ~/dev/cassandra$ bin/cqlsh
c1fa214
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]
Use HELP for
Yeah, you're right, it does work if I run it thru cqlsh. I was using
DevCenter which shows that error.
On Tue, Oct 11, 2016 at 9:48 AM, Andrew Tolbert wrote:
> That works for me. Are you sure you are on 3.6+? What error message are
> you getting?
>
> Thanks,
> Andy
>
> On Mon, Oct 10, 2016 at
That works for me. Are you sure you are on 3.6+? What error message are
you getting?
Thanks,
Andy
On Mon, Oct 10, 2016 at 11:25 PM Ali Akhtar wrote:
> CREATE TYPE test (
> foo text,
> bar text
> );
>
> CREATE TABLE test_table (
> id text,
> this_doesnt_work test,
> PRIMARY KEY (id)
> );
>
>
CREATE TYPE test (
foo text,
bar text
);
CREATE TABLE test_table (
id text,
this_doesnt_work test,
PRIMARY KEY (id)
);
On Tue, Oct 11, 2016 at 9:23 AM, Andrew Tolbert wrote:
> Can you please share an example where it doesn't work?
>
> Thanks,
> Andy
>
> On Mon, Oct 10, 2016 at 11:21 PM Ali Akht
Can you please share an example where it doesn't work?
Thanks,
Andy
On Mon, Oct 10, 2016 at 11:21 PM Ali Akhtar wrote:
> Not sure I understand the question, sorry.
>
> The column isn't part of the primary key.
>
> I defined a UDT and then I tried to define a column (not primary or
> cluster key
Not sure I understand the question, sorry.
The column isn't part of the primary key.
I defined a UDT and then I tried to define a column (not primary or cluster
key) as being of that type, but it doesn't let me do that unless i set it
as frozen. Docs indicate otherwise though
On Tue, Oct 11, 201
Is the column you are using that has the UDT type is the or is part of the
primary key? If that is the case it still needs to be frozen (the same
goes for list, set, tuple as part of primary key). This is the error I get
when I try that:
InvalidRequest: Error from server: code=2200 [Invalid quer
According to
http://docs.datastax.com/en/cql/3.3/cql/cql_using/useCreateUDT.html
> In Cassandra 3.6 and later, the frozen keyword is not required for UDTs
that contain only non-collection fields.
However if I create a type with 4-5 all text fields, and try to use that
type in another table, I ge
11 matches
Mail list logo