[jira] [Commented] (CASSANDRA-5341) Select writetime Exception when data doesn't exist
[ https://issues.apache.org/jira/browse/CASSANDRA-5341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13619372#comment-13619372 ] Aleksey Yeschenko commented on CASSANDRA-5341: -- +1 Select writetime Exception when data doesn't exist Key: CASSANDRA-5341 URL: https://issues.apache.org/jira/browse/CASSANDRA-5341 Project: Cassandra Issue Type: Bug Components: API Affects Versions: 1.2.2 Reporter: julien campan Assignee: Sylvain Lebresne Priority: Minor Fix For: 1.2.4 Attachments: 5341.txt Hi, When I try do to a “select writetime” on a empty column, I have an Exception. For example : Create table test (id int, value int, value2 int, primary key (id)); INSERT INTO test (id, value ) VALUES ( 1,100) ; select * from test where id =1; == id | value | value2 +---+ 1 | 100 | null It’s working. select WRITETIME(value) from test where id =1; == writetime(value) -- 1363184789539000 It’s working select WRITETIME(value2) from test where id =1; ==TSocket read 0 bytes I have an Exception. -- 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
[jira] [Commented] (CASSANDRA-5341) Select writetime Exception when data doesn't exist
[ https://issues.apache.org/jira/browse/CASSANDRA-5341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13612536#comment-13612536 ] julien campan commented on CASSANDRA-5341: -- This is the exception : ERROR [Thrift:25] 2013-03-25 11:18:38,889 CustomTThreadPoolServer.java (line 217) Error occurred during processing of message. java.lang.NullPointerException at org.apache.cassandra.cql3.statements.Selection$ResultSetBuilder.add(Selection.java:254) at org.apache.cassandra.cql3.statements.SelectStatement.handleGroup(SelectStatement.java:842) at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:709) at org.apache.cassandra.cql3.statements.SelectStatement.processResults(SelectStatement.java:147) at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:136) at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:62) at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:132) at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:143) at org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1733) at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4074) at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4062) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34) at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:199) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Select writetime Exception when data doesn't exist Key: CASSANDRA-5341 URL: https://issues.apache.org/jira/browse/CASSANDRA-5341 Project: Cassandra Issue Type: Bug Components: API Affects Versions: 1.2.2 Reporter: julien campan Assignee: Sylvain Lebresne Priority: Minor Fix For: 1.2.4 Attachments: 5341.txt Hi, When I try do to a “select writetime” on a empty column, I have an Exception. For example : Create table test (id int, value int, value2 int, primary key (id)); INSERT INTO test (id, value ) VALUES ( 1,100) ; select * from test where id =1; == id | value | value2 +---+ 1 | 100 | null It’s working. select WRITETIME(value) from test where id =1; == writetime(value) -- 1363184789539000 It’s working select WRITETIME(value2) from test where id =1; ==TSocket read 0 bytes I have an Exception. -- 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
[jira] [Commented] (CASSANDRA-5341) Select writetime Exception when data doesn't exist
[ https://issues.apache.org/jira/browse/CASSANDRA-5341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13612588#comment-13612588 ] Jonathan Ellis commented on CASSANDRA-5341: --- Why are we adding null columns in the first place? Select writetime Exception when data doesn't exist Key: CASSANDRA-5341 URL: https://issues.apache.org/jira/browse/CASSANDRA-5341 Project: Cassandra Issue Type: Bug Components: API Affects Versions: 1.2.2 Reporter: julien campan Assignee: Sylvain Lebresne Priority: Minor Fix For: 1.2.4 Attachments: 5341.txt Hi, When I try do to a “select writetime” on a empty column, I have an Exception. For example : Create table test (id int, value int, value2 int, primary key (id)); INSERT INTO test (id, value ) VALUES ( 1,100) ; select * from test where id =1; == id | value | value2 +---+ 1 | 100 | null It’s working. select WRITETIME(value) from test where id =1; == writetime(value) -- 1363184789539000 It’s working select WRITETIME(value2) from test where id =1; ==TSocket read 0 bytes I have an Exception. -- 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
[jira] [Commented] (CASSANDRA-5341) Select writetime Exception when data doesn't exist
[ https://issues.apache.org/jira/browse/CASSANDRA-5341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13612592#comment-13612592 ] Sylvain Lebresne commented on CASSANDRA-5341: - Cause this method is expected to be called for every CQL3 column of the result set and this for every row, even if the result to return is 'null'. Select writetime Exception when data doesn't exist Key: CASSANDRA-5341 URL: https://issues.apache.org/jira/browse/CASSANDRA-5341 Project: Cassandra Issue Type: Bug Components: API Affects Versions: 1.2.2 Reporter: julien campan Assignee: Sylvain Lebresne Priority: Minor Fix For: 1.2.4 Attachments: 5341.txt Hi, When I try do to a “select writetime” on a empty column, I have an Exception. For example : Create table test (id int, value int, value2 int, primary key (id)); INSERT INTO test (id, value ) VALUES ( 1,100) ; select * from test where id =1; == id | value | value2 +---+ 1 | 100 | null It’s working. select WRITETIME(value) from test where id =1; == writetime(value) -- 1363184789539000 It’s working select WRITETIME(value2) from test where id =1; ==TSocket read 0 bytes I have an Exception. -- 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
[jira] [Commented] (CASSANDRA-5341) Select writetime Exception when data doesn't exist
[ https://issues.apache.org/jira/browse/CASSANDRA-5341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13611568#comment-13611568 ] Jonathan Ellis commented on CASSANDRA-5341: --- What exception do you see in your server log? Select writetime Exception when data doesn't exist Key: CASSANDRA-5341 URL: https://issues.apache.org/jira/browse/CASSANDRA-5341 Project: Cassandra Issue Type: Bug Components: API Affects Versions: 1.2.2 Reporter: julien campan Priority: Minor Hi, When I try do to a “select writetime” on a empty column, I have an Exception. For example : Create table test (id int, value int, value2 int, primary key (id)); INSERT INTO test (id, value ) VALUES ( 1,100) ; select * from test where id =1; == id | value | value2 +---+ 1 | 100 | null It’s working. select WRITETIME(value) from test where id =1; == writetime(value) -- 1363184789539000 It’s working select WRITETIME(value2) from test where id =1; ==TSocket read 0 bytes I have an Exception. -- 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
