how to convert hbase binary foramtted data and load it into Pig?
<p>I have a table in Hbase which is having more than 2000 rows, and it consists binary formatted data.Trying to load it into pig and do some data processing on it using PIG</p>

<p><strong>Sample hbase table data:-</strong></p>

<pre><code>ROW                              COLUMN+CELL

\x00\x00\x00\x00\x00\x00\x06\xA6 column=cd:cct, timestamp=1475738991531, value=Atlanta

\x00\x00\x00\x00\x00\x00\x06\xA6 column=cd:cnt, timestamp=1475740226346, value=Network ICE Corp.

\x00\x00\x00\x00\x00\x00\x06\xA6 column=cd:ct, timestamp=1475740596684, value=ISYI srl
</code></pre>

<p>I have tried as mentioned in this 
<a href="https://pig.apache.org/docs/r0.9.1/api/org/apache/pig/backend/hadoop/hbase/HBaseStorage.html" rel="nofollow noreferrer">HBaseStorage using Pig</a> link </p>

<p><strong>Command:-</strong></p>

<pre><code>C = load ‘hbase://companydetail’
   using org.apache.pig.backend.hadoop.hbase.HBaseStorage('cd', '-loadKey true')
   as (rowkey:bytearray, cd:map[]);
</code></pre>

<p>But as it is having lot of binary data in it, given lot of weird symbols which can not be readable and understandable.</p>

<p><strong>sample output:-</strong></p>

<pre><code>(�$f,[parent_ccnt#United States,parent_cid#
                                            /�,p
</code></pre>

<p>I have tried an another way using binaryconverter</p>

<pre><code>a = load 'hbase://tablename' using org.apache.pig.backend.hadoop.hbase.HBaseStorage('cd','-loadKey -caster HBaseBinaryConverter') as (rowKey:bytearray,cd:map[]);
</code></pre>

<p>but still getting the same as above sample output.
In my table it consists more than 42 columns with cd column family.
In those 42 columns lot of binary formatted data is there.</p>

<p>Please suggest me how can i read binaryforamtted data into pig.</p>

<p>Any help is appreciable.</p>

<p>Thank you,</p>

<p>Mohan.V</p>