Hi,
Is there a possibility to insert formatted JSON and XML in same coulmn?
Application team want to save log as column value.Logs can be in XML or JSON and they are looking for the possibility.
e.g.
cassandra@cqlsh:omsdb> Create TABLE omsdb.EVENT(Id int PRIMARY KEY,Event_data text); cassandra@cqlsh:omsdb> INSERT INTO omsdb.EVENT(Id, EVENT_DATA) VALUES (1,'<note> </note>'); cassandra@cqlsh:omsdb> select * from EVENT; id | event_data ----+---------------- 1 | <note> </note>
Is that possible to insert JSON here?
I am facing error to insert query
INSERT INTO omsdb.EVENT(Id, EVENT_DATA) VALUES (2,'{productid: 5545, item : 'wire', amount : 200}');