Re: JSON Cassandra 2.2 - insert syntax

2015-06-02 Thread Sylvain Lebresne
Well, your column is not called "address", it's called "addresses". It's your type that is called "address". On Tue, Jun 2, 2015 at 4:39 AM, Michel Blase wrote: > Zach, > > this is embarrassing.you were right, I was running 2.1 > > shame on me! but now I'm getting the error: > > *Invalid

Re: JSON Cassandra 2.2 - insert syntax

2015-06-01 Thread Michel Blase
Zach, this is embarrassing.you were right, I was running 2.1 shame on me! but now I'm getting the error: *InvalidRequest: code=2200 [Invalid query] message="JSON values map contains unrecognized column: address"* any idea? This is the sequence of commands that I'm running: CREATE KEYSPA

Re: JSON Cassandra 2.2 - insert syntax

2015-06-01 Thread Zach Kurey
Hi Michel, My only other guess is that you actually are running Cassandra 2.1, since thats the exact error I get if I try to execute a JSON statement against a version earlier than 2.2. On Mon, Jun 1, 2015 at 6:13 PM, Michel Blase wrote: > Thanks Zach, > > tried that but I get the same error:

Re: JSON Cassandra 2.2 - insert syntax

2015-06-01 Thread Michel Blase
Thanks Zach, tried that but I get the same error: *SyntaxException: * On Mon, Jun 1, 2015 at 6:12 PM, Zach Kurey wrote: > Looks like you have your use of single vs. double quotes inverted. What > you want is: > > INSERT INTO users JSON '{"id": 123,"name": "jbellis","address": {"home": > {"st

Re: JSON Cassandra 2.2 - insert syntax

2015-06-01 Thread Zach Kurey
Looks like you have your use of single vs. double quotes inverted. What you want is: INSERT INTO users JSON '{"id": 123,"name": "jbellis","address": {"home": { "street": "123 Cassandra Dr","city": "Austin","zip_code": 78747,"phones": [ 2101234567]}}}'; HTH On Mon, Jun 1, 2015 at 6:03 PM, Miche

JSON Cassandra 2.2 - insert syntax

2015-06-01 Thread Michel Blase
Hi all, I'm trying to test the new JSON functionalities in C* 2.2. I'm using this example: https://issues.apache.org/jira/browse/CASSANDRA-7970 I believe there is a typo in the CREATE TABLE statement that requires frozen: CREATE TABLE users (id int PRIMARY KEY,name text,addresses map>); but m