CqlStorage creates wrong schema for Pig

2013-08-23 Thread Chad Johnston
(I'm using Cassandra 1.2.8 and Pig 0.11.1) I'm loading some simple data from Cassandra into Pig using CqlStorage. The CqlStorage loader defines a Pig schema based on the Cassandra schema, but it seems to be wrong. If I do: data = LOAD 'cql://bookdata/books' USING CqlStorage(); DESCRIBE data; I

Re: CqlStorage creates wrong schema for Pig

2013-08-30 Thread Chad Johnston
gt; >> I hope someOne reply one comment, idea or solution about this issue >> or bug. >> >> >> I have reviewed the CqlStorage class in code cassandra 1.2.8 but i do >> not have configure the environmetn to debug and trace this issue. >> >> Only

Re: CqlStorage creates wrong schema for Pig

2013-09-03 Thread Chad Johnston
> 8-| > > Regards > > ... > > > Miguel Angel MartĂ­n Junquera > Analyst Engineer. > miguelangel.mar...@brainsins.com > > > > 2013/9/2 Miguel Angel Martin junquera > >> hi all: >> >> More info : >> >> https://issues.apache.org/jira/browse/CASSANDRA-5941 >>

JIRA 5867 Fix causes Pig troubles

2013-09-20 Thread Chad Johnston
I've checked out and built the 1.2.10-tentative branch, and I've noticed that all of my CQL prepared statements are now broken. Looking into the code, it looks like the "#" -> "=" and "@" -> "?" translations were removed. I tried to replace these in one of my scripts with "=" and "?", but there's

FYI - Pig CQL queries in Cassandra 1.2.10

2013-09-23 Thread Chad Johnston
I don't see this formally documented anywhere, so I thought I'd give a heads-up to folks using Pig with Cassandra. In pre-1.2.10 versions, storing data into Cassandra required a query like this: STORE data INTO 'cql://keyspace/table?output_query=update table set some_value @ #' USING CqlStorage();

Re: Mystery PIG issue with 1.2.10

2013-09-25 Thread Chad Johnston
As an FYI, creating the table without the "WITH COMPACT STORAGE" and using CqlStorage works just fine in 1.2.10. I know that CqlStorage and AbstractCassandraStorage got changed for 1.2.10 - maybe there's a regression with the existing CassandraStorage? Chad On Wed, Sep 25, 2013 at 1:51 AM, Jann

Re: Mystery PIG issue with 1.2.10

2013-09-26 Thread Chad Johnston
The OP was using a Thrift table and CassandraStorage. I verified that the problem does not exist with a CQL3 table and CqlStorage. Chad On Thu, Sep 26, 2013 at 7:05 PM, Aaron Morton wrote: > > Unfortunately no, as I have a dozen legacy columnfamilies… Since no clear >> answers appeared, I'm goi