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
