Insert into in python cql throwing syntax error

Question

I tried creating table in cassandra using the following code in python

CREATE TABLE videos(
id uuid,
added_date TEXT,
title text,
PRIMARY KEY(id));

I tried to insert values using the following code

INSERT INTO videos(id,added_date,title)
VALUES(uuid(),"2014-01-29","Cassandra History");

I am getting the following error

SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 2:45 no 
viable alternative at input ',' (...,title)VALUES(uuid(),["2014-01-2]9",...)">

@Ralf Thank you its working perfectly.I did not expect that the error will be due to quotes — Balajee
– Balajee, Commented Apr 25, 2016 at 2:18

Balajee · Accepted Answer · 2016-04-26 06:27:04Z

1

As pointed out by @Ralf double quotes caused the error.When single quotes is used around the string it worked perfectly.

INSERT INTO videos(id,added_date,title)
VALUES(uuid(),'2014-01-29','Cassandra History');

answered Apr 26, 2016 at 6:27

Balajee

1431 gold badge2 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Muneer Over a year ago

That helped me too.

Collectives™ on Stack Overflow

Insert into in python cql throwing syntax error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related