[ https://issues.apache.org/jira/browse/CASSANDRA-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Capriolo updated CASSANDRA-4959: --------------------------------------- Description: [cqlsh 2.3.0 | Cassandra 1.2.0-beta2-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.35.0] Use HELP for help. cqlsh> help INSERT INSERT INTO [<keyspace>.]<tablename> ( <colname1>, <colname2> [, <colname3> [, ...]] ) VALUES ( <colval1>, <colval2> [, <colval3> [, ...]] ) [USING TIMESTAMP <timestamp>] [AND TTL <timeToLive]]; Should be. {quote} [AND TTL <timeToLive>]]; {quote} Also it was not clear to me initially that you could just do: {quote} USING TTL <timeToLive> {quote} But maybe that is just me. was: [cqlsh 2.3.0 | Cassandra 1.2.0-beta2-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.35.0] Use HELP for help. cqlsh> help INSERT INSERT INTO [<keyspace>.]<tablename> ( <colname1>, <colname2> [, <colname3> [, ...]] ) VALUES ( <colval1>, <colval2> [, <colval3> [, ...]] ) [USING TIMESTAMP <timestamp>] [AND TTL <timeToLive]]; Should be. {quote} [AND TTL = <timeToLive>]]; {quote} And I thing should probably be {quote} [USING TIMESTAMP <timestamp> [AND TTL = <timeToLive>]]; {quote} You should be able to set a TTL without a timestamp because c* magically does that for regular columns, but since you cant the help should reflect the syntax > CQLSH insert help has typo > -------------------------- > > Key: CASSANDRA-4959 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4959 > Project: Cassandra > Issue Type: Improvement > Components: Documentation & website > Affects Versions: 1.2.0 beta 2 > Reporter: Edward Capriolo > > [cqlsh 2.3.0 | Cassandra 1.2.0-beta2-SNAPSHOT | CQL spec 3.0.0 | Thrift > protocol 19.35.0] > Use HELP for help. > cqlsh> help INSERT > INSERT INTO [<keyspace>.]<tablename> > ( <colname1>, <colname2> [, <colname3> [, ...]] ) > VALUES ( <colval1>, <colval2> [, <colval3> [, ...]] ) > [USING TIMESTAMP <timestamp>] > [AND TTL <timeToLive]]; > Should be. > {quote} > [AND TTL <timeToLive>]]; > {quote} > Also it was not clear to me initially that you could just do: > {quote} > USING TTL <timeToLive> > {quote} > But maybe that is just me. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira