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 >
