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

2017-02-01 Thread Rajeswari Menon
Ok, got it. Many thanks for your help. Regards, Rajeswari From: Harikrishnan Pillai [mailto:hpil...@walmartlabs.com] Sent: 02 February 2017 11:30 To: user@cassandra.apache.org Subject: Re: Is it possible to have a column which can hold any data type (for inserting as json) When you run a cql

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

2017-02-01 Thread Harikrishnan Pillai
w how can I query the value field? From: Harikrishnan Pillai [mailto:hpil...@walmartlabs.com] Sent: 02 February 2017 10:18 To: user@cassandra.apache.org<mailto:user@cassandra.apache.org> Subject: Re: Is it possible to have a column which can hold any data type (for inserting as json) You can cre

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

2017-02-01 Thread Rajeswari Menon
Ok, got it. Many thanks for your help. Regards, Rajeswari From: Benjamin Roth [mailto:benjamin.r...@jaumo.com] Sent: 02 February 2017 11:09 To: user@cassandra.apache.org Subject: RE: Is it possible to have a column which can hold any data type (for inserting as json) This has to be done in

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

2017-02-01 Thread Benjamin Roth
m:* Benjamin Roth [mailto:benjamin.r...@jaumo.com] > *Sent:* 01 February 2017 15:36 > *To:* user@cassandra.apache.org > *Subject:* RE: Is it possible to have a column which can hold any data > type (for inserting as json) > > > > Value is defined as text column and you try to

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

2017-02-01 Thread Rajeswari Menon
Sorry for the red color in my question. It happened by mistake. Regards, Rajeswari. From: Rajeswari Menon Sent: 02 February 2017 10:47 To: 'user@cassandra.apache.org' Subject: RE: Is it possible to have a column which can hold any data type (for inserting as json) Could you please

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

2017-02-01 Thread Rajeswari Menon
8, "quality":"GOOD" }'); Now how can I query the value field? From: Harikrishnan Pillai [mailto:hpil...@walmartlabs.com] Sent: 02 February 2017 10:18 To: user@cassandra.apache.org Subject: Re: Is it possible to have a column which can hold any data type (for inser

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

2017-02-01 Thread Harikrishnan Pillai
bruary 2017 10:08 To: user@cassandra.apache.org<mailto:user@cassandra.apache.org> Subject: Re: Is it possible to have a column which can hold any data type (for inserting as json) You can use text type in Cassandra and store the full Json string . Sent from my iPhone On Feb 1, 2017

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

2017-02-01 Thread Rajeswari Menon
2017 10:08 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 can use text type in Cassandra and store the full Json string . Sent from my iPhone On Feb 1, 2017, at 8:30 PM, Rajeswari Menon mailto:rajeswar

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

2017-02-01 Thread Harikrishnan Pillai
:1485923271718, "quality":"GOOD" }'; Regards, Rajeswari From: Benjamin Roth [mailto:benjamin.r...@jaumo.com<mailto:benjamin.r...@jaumo.com>] Sent: 01 February 2017 12:35 To: user@cassandra.apache.org<mailto:user@cassandra.apache.org> Subject: Re: Is it pos

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

2017-02-01 Thread Rajeswari Menon
: RE: Is it possible to have a column which can hold any data type (for inserting as json) Value is defined as text column and you try to insert a double. That's simply not allowed Am 01.02.2017 09:02 schrieb "Rajeswari Menon" mailto:rajeswar...@thinkpalm.com>>: Given bel

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

2017-02-01 Thread Peter Reilly
, >> >>"name":"Longitude", >> >>"attributes":{ >> >> "ID":"1" >> >>}, >> >> "category":"REAL", >> >> "value":1.390692, >> &g

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

2017-02-01 Thread Benjamin Roth
; >"value":1.390692, > >"timestamp":1485923271718, > > "quality":"GOOD" > > }'; > > > > Regards, > > Rajeswari > > > > *From:* Benjamin Roth [mailto:benjamin.r...@jaumo.com] > *Sent:* 01 Feb

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

2017-02-01 Thread Rajeswari Menon
"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:

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

2017-01-31 Thread Benjamin Roth
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 : > Hi, > > > > I have a json data as shown below. > > > > { > > "address":"12

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

2017-01-31 Thread Rajeswari Menon
Hi, I have a json data as shown below. { "address":"127.0.0.1", "datatype":"DOUBLE", "name":"Longitude", "attributes":{ "Id":"1"