Details
-
Improvement
-
Status: Resolved
-
Normal
-
Resolution: Invalid
-
None
-
OSX 10.10.2
Description
Running a select command using CQLSH 2.1.5, 2.1.7 throws exception. This works nicely in 2.0.14 version.
Environment:
============
JAVA - 1.8
Python - 2.7.6
Cassandra Server - 2.1.7
CQLSH - 5.0.1
Logs:
======
CQLSH - cassandra 2.0.14 - working with no issues
-------------------------------------
NCHAN-M-D0LZ:apache nchan$ cd apache-cassandra-2.0.14/ NCHAN-M-D0LZ:apache-cassandra-2.0.14 nchan$ bin/cqlsh Connected to CCC Multi-Region Cassandra Cluster at <myip>:9160. [cqlsh 4.1.1 | Cassandra 2.1.7 | CQL spec 3.1.1 | Thrift protocol 19.39.0] Use HELP for help. cqlsh> use ccc; cqlsh:ccc> select count(*) from task_result where submissionid='40f89a3d1f4711e5ac2b005056bb0e8b'; count ------- 25 (1 rows) cqlsh:ccc> select * from task_result where submissionid='40f89a3d1f4711e5ac2b005056bb0e8b'; < i get all the 25 values>
CQLSH - cassandra 2.1.5 - python exception
-------------------------------------
NCHAN-M-D0LZ:apache-cassandra-2.1.5 nchan$ bin/cqlsh Connected to CCC Multi-Region Cassandra Cluster at <ip-address>:9042. [cqlsh 5.0.1 | Cassandra 2.1.7 | CQL spec 3.2.0 | Native protocol v3] Use HELP for help. cqlsh> use ccc; cqlsh:ccc> select count(*) from task_result where submissionid='40f89a3d1f4711e5ac2b005056bb0e8b'; count ------- 25 (1 rows) cqlsh:ccc> select * from task_result where submissionid='40f89a3d1f4711e5ac2b005056bb0e8b'; Traceback (most recent call last): File "bin/cqlsh", line 1001, in perform_simple_statement rows = self.session.execute(statement, trace=self.tracing_enabled) File "/Users/nchan/Programs/apache/apache-cassandra-2.1.5/bin/../lib/cassandra-driver-internal-only-2.5.0.zip/cassandra-driver-2.5.0/cassandra/cluster.py", line 1404, in execute result = future.result(timeout) File "/Users/nchan/Programs/apache/apache-cassandra-2.1.5/bin/../lib/cassandra-driver-internal-only-2.5.0.zip/cassandra-driver-2.5.0/cassandra/cluster.py", line 2974, in result raise self._final_exception OverflowError: normalized days too large to fit in a C int cqlsh:ccc>
CQLSH - cassandra 2.1.7 - python exception
-------------------------------------
NCHAN-M-D0LZ:apache-cassandra-2.1.7 nchan$ bin/cqlsh Connected to CCC Multi-Region Cassandra Cluster at 171.71.189.11:9042. [cqlsh 5.0.1 | Cassandra 2.1.7 | CQL spec 3.2.0 | Native protocol v3] Use HELP for help. cqlsh> use ccc; cqlsh:ccc> select count(*) from task_result where submissionid='40f89a3d1f4711e5ac2b005056bb0e8b'; count ------- 25 (1 rows) cqlsh:ccc> select * from task_result where submissionid='40f89a3d1f4711e5ac2b005056bb0e8b'; Traceback (most recent call last): File "bin/cqlsh", line 1041, in perform_simple_statement rows = self.session.execute(statement, trace=self.tracing_enabled) File "/Users/nchan/Programs/apache/apache-cassandra-2.1.7/bin/../lib/cassandra-driver-internal-only-2.5.1.zip/cassandra-driver-2.5.1/cassandra/cluster.py", line 1405, in execute result = future.result(timeout) File "/Users/nchan/Programs/apache/apache-cassandra-2.1.7/bin/../lib/cassandra-driver-internal-only-2.5.1.zip/cassandra-driver-2.5.1/cassandra/cluster.py", line 2976, in result raise self._final_exception OverflowError: normalized days too large to fit in a C int cqlsh:ccc>