Cassandra Insert Table using nested c...

Cassandra Insert Table using nested collection type

Posted in the Ebensburg Forum

Rabindra Bramhane

Madison Heights, MI

#1 Aug 11, 2017
I need some help on inserting data in a table (with nested collection TYPE) columns.
I am getting the following error:
Error from server: code=2200 [Invalid query] message="Unknown field 'icon_id' in value of user defined type tst_diag_msg_typ"
Thanks in advance for your help !!
Here is what I am doing.

CREATE TYPE cs_veh.tst_icon_typ (
icon_id text,
icon_val text
);
CREATE TYPE cs_veh.tst_diag_msg_typ (
msg_id text,
msg_priority int,
msg_text text,
IconReason SET <FROZEN<tst_icon_typ> >
);
CREATE TABLE test_veh_health
(VIN text,
eventtimestamp timestamp,
DiagnosticMessages SET < FROZEN <tst_diag_msg_typ>>,
PRIMARY KEY((VIN),eventtimestamp ))
WITH CLUSTERING ORDER BY (eventtimestamp DESC);
insert into test_veh_health
( VIN,
eventtimestamp
, DiagnosticMessages
)
values
('TEST122227751',
toTimestamp(now())
,{{msg_id :'24.0:ENGINE:MESSAGE', msg_priority : 37, msg_text :'Oil pressure: Engine off! See owners manual.'}
,{ icon_id :'xx', icon_val:'text'}
}
);

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Ebensburg Discussions

Title Updated Last By Comments
brother in prison in loretto (Feb '10) Sep '18 MountainGal 23
hey May '18 Homesick 1
News Police looking for missing PSU student with tie... (Sep '12) May '18 AL BUSILLO 5 STAR 2
News Cop charged with taping fellow officers (Dec '09) Feb '18 Todd 6
Dr erlinda Perez Aquino (Apr '13) Jul '17 Rachel 2
Frank Bucci (Jun '17) Jun '17 Tom Mack 1
News Man remembered for love of Lilly, family (Jan '17) Jan '17 Jeremy 2

Ebensburg Jobs

Personal Finance

Ebensburg Mortgages