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
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
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
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
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, '{
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
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
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
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
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 |
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":"",
>
>
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,
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.
>
>
>
> {
>
>
13 matches
Mail list logo