(Hbase配置文件路径)
REGISTER /usr/hdp/3.1.4.0-315/hbase/lib/*.jar;
(字段1,字段2,字段3为所需导出字段,col1,col2,col3为虚拟表文件字段,其他无需修改)
rows = load 'hbase://namespace:tablename' USING org.apache.pig.backend.hadoop.hbase.HBaseStorage('INFO:字段1 INFO:字段2 INFO:字段3','-loadKey true ') AS (col1:chararray,col2:chararray,col3:chararray);
STORE rows INTO 'hdfs://nameservice/zqd/namespace:tablename' USING PigStorage('\u0001');
(防止表过大导出时间过长,建议后台执行)
nohup pig -x mapreduce /mnt/data_1/zqd/hbase/1234.pig >> /mnt/data_1/zqd/hbase/log/admym.log 2>&1 &