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
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
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:
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
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
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