This is not currently possible. It's also ill-defined since 'result' is a relation, not a scalar. What you really want is to call an hbase lookup udf, to ensure you get a single record back, not to use the result of a table scan in another table scan.
The way to get this done 'properly' is to implement partition push down in hbase storage. This is nontrivial and valuable. If someone has cycles to do it, that would be a great patch. On Feb 17, 2012, at 12:19 AM, chethan <[email protected]> wrote: > Hi, > > I want to issue command inside command in PIG Script. > > command 1 : result = load 'hbase://sample_names' using > org.apache.pig.backend.hadoop.hbase.HBaseStorage('cf:fname','-loadKey true > -gt 1 -lt 3') as (id:chararray); > command 2 : user_links = load 'hbase://sample_names' using > org.apache.pig.backend.hadoop.hbase.HBaseStorage('cf:fname','-loadKey true > -gt result') as (name:chararray); > > user_links = load 'hbase://sample_names' using > org.apache.pig.backend.hadoop.hbase.HBaseStorage('cf:fname','-loadKey true > -gt command 1') as (name:chararray); > > Thanks & Regards > Chethan Prakash.
