osdir.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Is it possible to have a column which can hold any data type (for inserting as json)


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