Tjyylli

Patience, young "Padovan"

What is the meaning of "of trouble" in the following sentence?

How do I create uniquely male characters?

Is "plugging out" electronic devices an American expression?

Ideas for 3rd eye abilities

"listening to me about as much as you're listening to this pole here"

Lied on resume at previous job

How to make payment on the internet without leaving a money trail?

Why doesn't a const reference extend the life of a temporary object passed via a function?

What does 'script /dev/null' do?

Why is the design of haulage companies so “special”?

What causes the sudden spool-up sound from an F-16 when enabling afterburner?

Is this food a bread or a loaf?

How to move the player while also allowing forces to affect it

Can I legally use front facing blue light in the UK?

Is there a way to make member function NOT callable from constructor?

Why airport relocation isn't done gradually?

Is it wise to focus on putting odd beats on left when playing double bass drums?

How to make particles emit from certain parts of a 3D object?

Is domain driven design an anti-SQL pattern?

Add an angle to a sphere

Are objects structures and/or vice versa?

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

aging parents with no investments

How to store nested json objects in Cassandra so that nested data can be queried easily [on hold]

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

0

I am new to cassanadra and need to understand solutions for be low problem.
I would like to store nested json objects in Cassandra DB and would like to query as well. I am looking for creating table for the same.

1 record data looks like this –

{ “id”: “100”,
“timestamp” : "2018-03-13T12:00:00.000"
“foo” :[
{"url":"log1.abc.com","zone":["news", “web”] },
{"url":"log2.xyz.com/test","zone":["news"]},
{"url":"log3.server.com/test2","zone":["web", “test”, “hello”]}
],

With above data, how should I create table to store specially “foo” so that I should be able to query in table to find all records where "zone" contains value as "news". i.e. Find all records where foo.zone contains "news" ?

I tried creating user defined data type like as follows –

CREATE TYPE nest (
url text,
zone list
);

CREATE TABLE my_table (
id int,
foo set>,
PRIMARY KEY (id) );

But the restriction with approach is that, it doesn’t allow to query the data stored under frozen. i.e. I am not able to query as I stated above; i.e. to fetch only those records having ”web” as string in "zone" column value.

Please guide.

nosql-manager

share|improve this question

asked 2 days ago

SSainiSSaini

1

New contributor

SSaini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

put on hold as too broad by DavidPostill♦ 2 days ago

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment | 

0

I am new to cassanadra and need to understand solutions for be low problem.
I would like to store nested json objects in Cassandra DB and would like to query as well. I am looking for creating table for the same.

1 record data looks like this –

{ “id”: “100”,
“timestamp” : "2018-03-13T12:00:00.000"
“foo” :[
{"url":"log1.abc.com","zone":["news", “web”] },
{"url":"log2.xyz.com/test","zone":["news"]},
{"url":"log3.server.com/test2","zone":["web", “test”, “hello”]}
],

With above data, how should I create table to store specially “foo” so that I should be able to query in table to find all records where "zone" contains value as "news". i.e. Find all records where foo.zone contains "news" ?

I tried creating user defined data type like as follows –

CREATE TYPE nest (
url text,
zone list
);

CREATE TABLE my_table (
id int,
foo set>,
PRIMARY KEY (id) );

But the restriction with approach is that, it doesn’t allow to query the data stored under frozen. i.e. I am not able to query as I stated above; i.e. to fetch only those records having ”web” as string in "zone" column value.

Please guide.

nosql-manager

share|improve this question

asked 2 days ago

SSainiSSaini

1

New contributor

SSaini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

put on hold as too broad by DavidPostill♦ 2 days ago

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment | 

I am new to cassanadra and need to understand solutions for be low problem.
I would like to store nested json objects in Cassandra DB and would like to query as well. I am looking for creating table for the same.

1 record data looks like this –

{ “id”: “100”,
“timestamp” : "2018-03-13T12:00:00.000"
“foo” :[
{"url":"log1.abc.com","zone":["news", “web”] },
{"url":"log2.xyz.com/test","zone":["news"]},
{"url":"log3.server.com/test2","zone":["web", “test”, “hello”]}
],

With above data, how should I create table to store specially “foo” so that I should be able to query in table to find all records where "zone" contains value as "news". i.e. Find all records where foo.zone contains "news" ?

I tried creating user defined data type like as follows –

CREATE TYPE nest (
url text,
zone list
);

CREATE TABLE my_table (
id int,
foo set>,
PRIMARY KEY (id) );

But the restriction with approach is that, it doesn’t allow to query the data stored under frozen. i.e. I am not able to query as I stated above; i.e. to fetch only those records having ”web” as string in "zone" column value.

Please guide.

nosql-manager

share|improve this question

asked 2 days ago

SSainiSSaini

1

New contributor

SSaini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 2 days ago

SSainiSSaini

1

New contributor

SSaini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 2 days ago

SSainiSSaini

1

New contributor

SSaini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 days ago

SSainiSSaini

1

New contributor

SSaini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 days ago

SSainiSSaini

1