RE: UUID coming as int while using SPARK SQL

2016-05-25 Thread Rajesh Radhakrishnan
chael.la...@nytimes.com] Sent: 24 May 2016 12:23 To: user@cassandra.apache.org Subject: Re: UUID coming as int while using SPARK SQL Yes - a UUID is just a 128 bit value. You can view it using any base or format. If you are looking at the same row, you should see the same 128 bit value, otherw

Re: UUID coming as int while using SPARK SQL

2016-05-24 Thread Laing, Michael
nt:* 24 May 2016 11:40 > *To:* user@cassandra.apache.org > *Subject:* Re: UUID coming as int while using SPARK SQL > > Try converting that int from decimal to hex and inserting dashes in the > appropriate spots - or go the other way. > > Also, you are looking at different row

RE: UUID coming as int while using SPARK SQL

2016-05-24 Thread Rajesh Radhakrishnan
'; And in Spark with Python: SELECT distinct id, dept, workflow FROM samd WHERE dept='blah'; Best, Rajesh R From: Laing, Michael [michael.la...@nytimes.com] Sent: 24 May 2016 11:40 To: user@cassandra.apache.org Subject: Re: UUID coming as int while using SPARK SQL Try

Re: UUID coming as int while using SPARK SQL

2016-05-24 Thread Laing, Michael
Try converting that int from decimal to hex and inserting dashes in the appropriate spots - or go the other way. Also, you are looking at different rows, based upon your selection criteria... ml On Tue, May 24, 2016 at 6:23 AM, Rajesh Radhakrishnan < rajesh.radhakrish...@phe.gov.uk> wrote: >

UUID coming as int while using SPARK SQL

2016-05-24 Thread Rajesh Radhakrishnan
Hi, I got a Cassandra keyspace, but while reading the data(especially UUID) via Spark SQL using Python is not returning the correct value. Cassandra: -- My table 'SAM'' is described below: CREATE table ks.sam (id uuid, dept text, workflow text, type double primary key (id,