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

2017-02-01 Thread Rajeswari Menon
from table where address=?,assuming you created a secondary index on address column . Regards Hari Sent from my iPhone On Feb 1, 2017, at 9:18 PM, Rajeswari Menon mailto:rajeswar...@thinkpalm.com>> wrote: Could you please help me on this. I am a newbie in Cassandra. So If I need to add jso

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

2017-02-01 Thread Rajeswari Menon
"Rajeswari Menon" mailto:rajeswar...@thinkpalm.com>>: Yes. Is there any way to define value to accept any data type as the json value data may vary? Or is there any way to do the same without defining a schema? Regards, Rajeswari From: Benjamin Roth [mailto:benjamin.r...@jaumo.com&l

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
ting as json) You can create additional columns and create secondary index based on fields you want to query . Best option is store full Json in Cassandra and index fields you want to query on in solr . Sent from my iPhone On Feb 1, 2017, at 8:41 PM, Rajeswari Menon mailto:rajeswar...@thinkpalm.

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 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 Rajeswari Menon
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 mailto:rajeswar...@thinkpalm.

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"