I tried with 1.2.10 and don't meet the issue anymore. Regards -- Cyril SCETBON
On Sep 19, 2013, at 10:28 PM, Cyril Scetbon <cyril.scet...@free.fr> wrote: > Hi, > > Did you try to build 1.2.10 and to use it for your tests ? I've got the same > issue and will give it a try as soon as it's released (expected at the end of > the week). > > Regards > -- > Cyril SCETBON > > On Sep 2, 2013, at 3:09 PM, Miguel Angel Martin junquera > <mianmarjun.mailingl...@gmail.com> wrote: > >> hi all: >> >> More info : >> >> https://issues.apache.org/jira/browse/CASSANDRA-5941 >> >> >> >> I tried this (and gen. cassandra 1.2.9) but do not work for me, >> >> git clone http://git-wip-us.apache.org/repos/asf/cassandra.git >> cd cassandra >> git checkout cassandra-1.2 >> patch -p1 < 5867-bug-fix-filter-push-down-1.2-branch.txt >> ant >> >> >> >> Miguel Angel Martín Junquera >> Analyst Engineer. >> miguelangel.mar...@brainsins.com >> >> >> >> 2013/9/2 Miguel Angel Martin junquera <mianmarjun.mailingl...@gmail.com> >> hi: >> >> I test this in cassandra 1.2.9 new version and the issue still persists . >> >> :-( >> >> >> >> >> >> >> Miguel Angel Martín Junquera >> Analyst Engineer. >> miguelangel.mar...@brainsins.com >> >> >> >> 2013/8/30 Miguel Angel Martin junquera <mianmarjun.mailingl...@gmail.com> >> I try this: >> >> rows = LOAD >> 'cql://keyspace1/test?page_size=1&split_size=4&where_clause=age%3D30' USING >> CqlStorage(); >> dump rows; >> ILLUSTRATE rows; >> describe rows; >> >> values2= FOREACH rows GENERATE TOTUPLE (id) as (mycolumn:tuple(name,value)); >> dump values2; >> describe values2; >> >> But I get this results: >> >> >> >> ------------------------------------------------------------- >> | rows | id:chararray | age:int | title:chararray | >> ------------------------------------------------------------- >> | | (id, 6) | (age, 30) | (title, QA) | >> ------------------------------------------------------------- >> >> rows: {id: chararray,age: int,title: chararray} >> 2013-08-30 09:54:37,831 [main] ERROR org.apache.pig.tools.grunt.Grunt - >> ERROR 1031: Incompatable field schema: left is >> "tuple_0:tuple(mycolumn:tuple(name:bytearray,value:bytearray))", right is >> "org.apache.pig.builtin.totuple_id_1:tuple(id:chararray)" >> >> >> >> >> >> or >> >> >> >> .... >> >> values2= FOREACH rows GENERATE TOTUPLE (id) ; >> dump values2; >> describe values2; >> >> >> >> and the results are: >> >> >> ... >> (((id,6))) >> (((id,5))) >> values2: {org.apache.pig.builtin.totuple_id_8: (id: chararray)} >> >> >> >> Aggg!!!!! >> >> >> >> >> >> >> >> >> >> Miguel Angel Martín Junquera >> Analyst Engineer. >> miguelangel.mar...@brainsins.com >> >> >> >> 2013/8/28 Miguel Angel Martin junquera <mianmarjun.mailingl...@gmail.com> >> hi: >> >> I can not understand why the schema is define like >> "id:chararray,age:int,title:chararray" and it does not define like tuples >> or bag tuples, if we have pair key-values columns >> >> >> I try other time to change schema but it does not work. >> >> any ideas ... >> >> perhaps, is the issue in the definition cql3 tables ? >> >> regards >> >> >> 2013/8/28 Miguel Angel Martin junquera <mianmarjun.mailingl...@gmail.com> >> hi all: >> >> >> Regards >> >> Still i can resolve this issue. ..... >> >> does anybody have this issue or try to test this simple example? >> >> >> i am stumped I can not find a solution working. >> >> I appreciate any comment or help >> >> >> 2013/8/22 Miguel Angel Martin junquera <mianmarjun.mailingl...@gmail.com> >> hi all: >> >> >> >> >> I,m testing the new CqlStorage() with cassandra 1.28 and pig 0.11.1 >> >> >> I am using this sample data test: >> >> >> http://frommyworkshop.blogspot.com.es/2013/07/hadoop-map-reduce-with-cassandra.html >> >> And I load and dump data Righ with this script: >> >> rows = LOAD >> 'cql://keyspace1/test?page_size=1&split_size=4&where_clause=age%3D30' USING >> CqlStorage(); >> >> dump rows; >> describe rows; >> >> resutls: >> >> ((id,6),(age,30),(title,QA)) >> ((id,5),(age,30),(title,QA)) >> rows: {id: chararray,age: int,title: chararray} >> >> >> But i can not get the column values >> >> I try to define another schemas in Load like I used with cassandraStorage() >> >> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-and-Pig-how-to-get-column-values-td5641158.html >> >> >> example: >> >> rows = LOAD >> 'cql://keyspace1/test?page_size=1&split_size=4&where_clause=age%3D30' USING >> CqlStorage() AS (columns: bag {T: tuple(name, value)}); >> >> >> and I get this error: >> >> 2013-08-22 12:24:45,426 [main] ERROR org.apache.pig.tools.grunt.Grunt - >> ERROR 1031: Incompatable schema: left is >> "columns:bag{T:tuple(name:bytearray,value:bytearray)}", right is >> "id:chararray,age:int,title:chararray" >> >> >> >> I try to use, FLATTEN, SUBSTRING, SPLIT UDF`s but i have not get good result: >> >> Example: >> >> when I flatten , I get a set of tuples like >> (title,QA) >> (title,QA) >> 2013-08-22 12:42:20,673 [main] INFO >> org.apache.pig.backend.hadoop.executionengine.util.MapRedUtil - Total input >> paths to process : 1 >> A: {title: chararray} >> >> >> but i can get value QA >> >> Sustring only works with title >> >> >> >> example: >> >> B = FOREACH A GENERATE SUBSTRING(title,2,5); >> >> dump B; >> describe B; >> >> >> results: >> >> (tle) >> (tle) >> B: {chararray} >> >> >> >> i try, this like ERIC LEE inthe other mail and have the same results: >> >> >> Anyways, what I really what is the column value, not the name. Is there a >> way to do that? I listed all of the failed attempts I made below. >> colnames = FOREACH cols GENERATE $1 and was told $1 was out of bounds. >> casted = FOREACH cols GENERATE (tuple(chararray, chararray))$0; but all I >> got back were empty tuples >> values = FOREACH cols GENERATE $0.$1; but I got an error telling me data >> byte array can't be casted to tuple >> >> Please, I will appreciate any help >> >> >> Regards >> >> >> >> >> >> >> >> >> >> -- >> >> >> >> >> >> >> Miguel Angel Martín Junquera >> Analyst Engineer. >> miguelangel.mar...@brainsins.com >> Tel. / Fax: (+34) 91 485 56 66 >> http://www.brainsins.com >> Smart eCommerce >> Madrid: http://goo.gl/4B5kv >> London: http://goo.gl/uIXdv >> Barcelona: http://goo.gl/NZslW >> >> Antes de imprimir este e-mail, piense si es necesario. >> La legislación española ampara el secreto de las comunicaciones. Este correo >> electrónico es estrictamente confidencial y va dirigido exclusivamente a su >> destinatario/a. Si no es Ud., le rogamos que no difunda ni copie la >> transmisión y nos lo notifique cuanto antes. >> >> >> >> -- >> >> >> >> >> >> Miguel Angel Martín Junquera >> Analyst Engineer. >> miguelangel.mar...@brainsins.com >> >> >> >> >
