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
When you run a cql query like select Json from table where pk=? , you will get the value which is a full Json .but if you have a requirement to query the Json by using some fields inside Json ,you have to create additional columns for that fields and create a secondary index on it . Then you

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
This has to be done in your app. You can store your data as JSON in a text column. You can use your favourite serializer. You can cast floats to strings. You can even build a custom type. You can store it serialized as blob. But there is no all purpose store all data in a magic way field. Am

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

2017-02-01 Thread Rajeswari Menon
Could you please help me on this. I am a newbie in Cassandra. So If I need to add json as a String, I can define the table as below. create table data ( id int primary key, json text ); The insert query will be as follows: insert into data (id, json) values (1, '{

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

2017-02-01 Thread Harikrishnan Pillai
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

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

2017-02-01 Thread Rajeswari Menon
Yes. I know that. My intension is to do an aggregate query on value field (in json). Will that be possible if I store the entire json as String? I will have to parse it according to my need right? Regards, Rajeswari From: Harikrishnan Pillai [mailto:hpil...@walmartlabs.com] Sent: 02 February

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

2017-02-01 Thread Harikrishnan Pillai
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 > wrote: Yes. Is there any way to define value to accept any data type as the json value data may

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

2017-02-01 Thread Rajeswari Menon
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] Sent: 01 February 2017 15:36 To: user@cassandra.apache.org

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

2017-02-01 Thread Peter Reilly
Example: cqlsh> use dc_god_emperor ; cqlsh:dc_god_emperor> create table data ( id int primary key, value text ) ; cqlsh:dc_god_emperor> insert into data JSON'{"id": 1, "value": "hello world"}' ... ; cqlsh:dc_god_emperor> select * from data; id | value +- 1 |

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 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" : > Given below is the sql query I executed. > > > > *insert* *into* data JSON'{ > > "id": 1, > >"address":"", > >

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

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

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. > > > > { > >