Given below is the sql query I executed. insert into data JSON'{ "id": 1, "address":"", "datatype":"DOUBLE", "name":"Longitude", "attributes":{ "ID":"1" }, "category":"REAL", "value":1.390692, "timestamp":1485923271718, "quality":"GOOD" }';
Regards, Rajeswari From: Benjamin Roth [mailto:benjamin.r...@jaumo.com] Sent: 01 February 2017 12:35 To: user@cassandra.apache.org Subject: Re: Is it possible to have a column which can hold any data type (for inserting as json) You should post the whole CQL query you try to execute! Why don't you use a native JSON type for your JSON data? 2017-02-01 7:51 GMT+01:00 Rajeswari Menon <rajeswar...@thinkpalm.com<mailto:rajeswar...@thinkpalm.com>>: Hi, I have a json data as shown below. { "address":"127.0.0.1", "datatype":"DOUBLE", "name":"Longitude", "attributes":{ "Id":"1" }, "category":"REAL", "value":1.390692, "timestamp":1485923271718, "quality":"GOOD" } To store the above json to Cassandra, I defined a table as shown below create table data ( id int primary key, address text, datatype text, name text, attributes map < text, text >, category text, value text, "timestamp" timestamp, quality text ); When I try to insert the data as JSON I got the error : Error decoding JSON value for value: Expected a UTF-8 string, but got a Double: 1.390692. The message is clear that a double value cannot be inserted to text column. The real issue is that the value can be of any data type, so the schema cannot be predefined. Is there a way to create a column which can hold value of any data type. (I don’t want to hold the entire json as string. My preferred way is to define a schema.) Regards, Rajeswari -- Benjamin Roth Prokurist Jaumo GmbH · www.jaumo.com<http://www.jaumo.com> Wehrstraße 46 · 73035 Göppingen · Germany Phone +49 7161 304880-6 · Fax +49 7161 304880-1 AG Ulm · HRB 731058 · Managing Director: Jens Kammerer