Re: Being asked to use frozen for UDT in 3.9

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

Re: Being asked to use frozen for UDT in 3.9

> > 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

Re: Being asked to use frozen for UDT in 3.9

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

Re: Being asked to use frozen for UDT in 3.9

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

Re: Being asked to use frozen for UDT in 3.9

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, >

Re: Being asked to use frozen for UDT in 3.9

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, >

Re: Being asked to use frozen for UDT in 3.9

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,

Re: Being asked to use frozen for UDT in 3.9

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

Re: Being asked to use frozen for UDT in 3.9

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,

Re: Being asked to use frozen for UDT in 3.9

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