Re: Load table sorted by key

2012-10-24 Thread Adam Kawa
Rows in HBase are sorted lexicographically, so that 1 precedes 10 and 100. You need to a) ORDER library BY id in Pig script or b) pad your HBase rowkey with zeros e.g. 001, 010, 100, 101 before loading it in Pig (but I will require re-write of the HBase table, since each row can not be simply upda

RE: Load table sorted by key

2012-10-24 Thread HAJIHASHEMI, ZAHRA (AG/1000)
Hi, I have a table in hbase that I want to load all records sorted by row key which is an integer number. Here is my code: library = LOAD 'discovery_rnaseq_library' USING org.apache.pig.backend.hadoop.hbase.HBaseStorage('A:COMMON_NAME A:SCIENTIFIC_NAME A:GENETIC_BACKGROUND A:TISSUE,'-loadKey tr