Stefania

Downloading and simply running from folder without homebrew interference it now 
looks like the driver matches what you say in the last email.
I will try writing variants again to confirm it works.

cqlsh --debug
Using CQL driver: <module 'cassandra' from 
'/Users/bbabic/Applications/apache-cassandra-3.10/bin/../lib/cassandra-driver-internal-only-3.7.0.post0-2481531.zip/cassandra-driver-3.7.0.post0-2481531/cassandra/__init__.py'>
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 6, 2017, at 11:58 AM, Stefania Alborghetti 
> <stefania.alborghe...@datastax.com> wrote:
> 
> It doesn't look like the embedded driver, it should come from a zip file 
> labeled with version 3.7.0.post0-2481531 for cassandra 3.10:
> 
> Using CQL driver: <module 'cassandra' from 
> '/home/stefi/git/cstar/cassandra/bin/../lib/cassandra-driver-internal-only-3.7.0.post0-2481531.zip/cassandra-driver-3.7.0.post0-2481531/cassandra/__init__.py'>
> 
> Sorry, I should have posted this example in my previous email, rather than an 
> example based on the non-embedded driver.
> 
> I don't know who to contact regarding homebrew installation, but you could 
> download the Cassandra package, unzip it, and run cqlsh and Cassandra from 
> that directory?
> 
> 
> On Thu, Apr 6, 2017 at 4:59 AM, Boris Babic <bo...@icloud.com> wrote:
> 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
>> 
>> 
>> 
>> 
> 
> 
> 
> 
> -- 
> 
> STEFANIA ALBORGHETTI
> Software engineer | +852 6114 9265 | stefania.alborghe...@datastax.com
> 
> 
> 
> 

Reply via email to