Stefania This is the output of my --debug, I never touched CQLSH_NO_BUNDLED and did not know about it. As you can see I have used homebrew to install Cassandra and looks like its the embedded version as it sits under the Cassandra folder ?
cqlsh --debug Using CQL driver: <module 'cassandra' from '/usr/local/Cellar/cassandra/3.10_1/libexec/vendor/lib/python2.7/site-packages/cassandra/__init__.pyc'> Using connect timeout: 5 seconds Using 'utf-8' encoding Using ssl: False Connected to Test Cluster at 127.0.0.1:9042. [cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4] Use HELP for help. > On Apr 5, 2017, at 12:07 PM, Stefania Alborghetti > <stefania.alborghe...@datastax.com> wrote: > > You are welcome. > > I traced the problem to a commit of the Python driver that shipped in version > 3.8 of the driver. It is fixed in 3.8.1. More details on CASSANDRA-13408. I > don't think it's related to the OS. > > Since Cassandra 3.10 ships with an older version of the driver embedded in a > zip file in the lib folder, and this version is not affected, I'm guessing > that either the embedded version does not work on OS X, or you are manually > using a different version of the driver by setting CQLSH_NO_BUNDLED (which is > why I could reproduce it on my laptop). > > You can run cqlsh with --debug to see the version of the driver that cqlsh is > using, for example: > > cqlsh --debug > Using CQL driver: <module 'cassandra' from > '/usr/local/lib/python2.7/dist-packages/cassandra_driver-3.8.1-py2.7-linux-x86_64.egg/cassandra/__init__.pyc'> > > Can you confirm if you were overriding the Python driver by setting > CQLSH_NO_BUNDLED and the version of the driver? > > > > On Tue, Apr 4, 2017 at 6:12 PM, Boris Babic <bo...@icloud.com> wrote: > Thanks Stefania, going from memory don't think I noticed this on windows but > haven't got a machine handy to test it on at the moment. > > On Apr 4, 2017, at 19:44, Stefania Alborghetti > <stefania.alborghe...@datastax.com> wrote: > >> I've reproduced the same problem on Linux, and I've opened CASSANDRA-13408. >> As a workaround, disable prepared statements and it will work (WITH HEADER = >> TRUE AND PREPAREDSTATEMENTS = False). >> >> On Tue, Apr 4, 2017 at 5:02 PM, Boris Babic <bo...@icloud.com> wrote: >> >> On Apr 4, 2017, at 7:00 PM, Boris Babic <bo...@icloud.com> wrote: >> >> Hi >> >> I’m testing the write of various datatypes on OS X for fun running cassandra >> 3.10 on a single laptop instance, and from what i can see varint should map >> to java.math.BigInteger and have no problems with Long.MIN_VALE , >> -9223372036854775808, but i can’t see what I’m doing wrong. >> >> cqlsh: 5.0.1 >> cassandra 3.10 >> osx el capitan. >> >> data.csv: >> >> id,varint >> -2147483648,-9223372036854775808 >> 2147483647,9223372036854775807 >> >> COPY mykeyspace.data (id,varint) FROM 'data.csv' WITH HEADER=true; >> >> Failed to make batch statement: Received an argument of invalid type >> for column "varint". Expected: <class 'cassandra.cqltypes.IntegerType'>, >> Got: <type 'int'>; (descriptor 'bit_length' requires a 'int' object but >> received a 'long’) >> >> If I directly type a similar insert in cqlsh no such problem occurs, in fact >> I can make the value many orders of magnitude less and all is fine. >> >> cqlsh> insert into mykeyspace.data (id,varint) >> values(1,-9223372036854775808898989898) ; >> >> Had not observed this before on other OS, is this something todo with the >> way the copy from parser is interpreting varint for values <= -2^63 ? >> >> Thanks for any input >> Boris >> >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> STEFANIA ALBORGHETTI >> Software engineer | +852 6114 9265 | stefania.alborghe...@datastax.com >> >> >> >> > > > > -- > > STEFANIA ALBORGHETTI > Software engineer | +852 6114 9265 | stefania.alborghe...@datastax.com > > > >