Try adding -caster=HBaseBinaryConverter along with loadKey '-caster=HBaseBinaryConverter -loadKey=true'
-bp On Tue, Sep 6, 2011 at 7:59 AM, shazz Ng <[email protected]> wrote: > Hello Norbert, > > Unfortunately, same result : > (Measurement_1,) > (Measurement_2,) > (Measurement_3,) > (proc.loadavg.1m,) > (proc.loadavg.5m,) > > the row key is well extracted (Measurement_1 for example) but the value, > the > id I need for timestamp data querying, the bytearray, is not :( > > shazz > > On Tue, Sep 6, 2011 at 3:37 PM, Norbert Burger <[email protected] > >wrote: > > > On Tue, Sep 6, 2011 at 7:58 AM, shazz Ng <[email protected]> wrote: > > > So from Pig when I want to retrieve only the metrics and their value (= > > id > > > for the data table) I do : > > > tsd_metrics = LOAD 'hbase://tsdb-uid' using > > > org.apache.pig.backend.hadoop.hbase.HBaseStorage('id:metrics', > '-loadKey > > > true') AS (metrics:bytearray); > > > dump tsd_metrics; > > > > Shazz -- if you use the "-loadKey" option to HbaseStorage, then your > > LOAD schema includes an extra column containing the row key, and you > > should add equivalent to your schema column mapping (the AS clause). > > Try the following: > > > > tsd_metrics = LOAD 'hbase://tsdb-uid' using > > org.apache.pig.backend.hadoop.hbase.HBaseStorage('id:metrics', > > '-loadKey true') AS (key:bytearray, metrics:bytearray); > > > > Norbert > > >
