Hi Arthur, please read hive documentation ( https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration). When creating external table in Hive you specify types for each column adn mapping to column family and column name so Hive will translate for you those bytearrays into proper types when doing query.
On Sat, 25 Apr 2015 at 14:08 Arthur Chan <[email protected]> wrote: > Thank you so much, it helps! I can get the correct timestamp value from > the HBase scan. > > I am trying to using the HBase table as the external table in Hive, can I > use ['f:ts:c(org.apache.hadoop.hbase.util.Bytes).toLong']} in HIVE "Create > external table ..." ? > > Thanks > > On Sat, Apr 25, 2015 at 4:28 PM, Radosław Stankiewicz <[email protected]> > wrote: > > > Hi, > > > > timestamp and those columns are long values, so you should try: > > scan ‘webpage′, {COLUMNS => > > ['f:ts:c(org.apache.hadoop.hbase.util.Bytes).toLong'] > > } > > > > On Sat, Apr 25, 2015 at 9:53 AM, Arthur Chan <[email protected]> > > wrote: > > > > > Thank you for your reply. > > > > > > I just tried the following: > > > scan 'webpage', {COLUMN=>"f:ts:toInt"} > > > > > > column=f:ts, timestamp=1428367903770, value=332 > > > > > > The value is 332 and seems that it should not be a timestamp. > > > > > > Will this be a Nutch/Gora/Hbase setup issue? > > > > > > > > > > > > > > > > > > > > > > > > On Sat, Apr 25, 2015 at 2:41 PM, Radosław Stankiewicz < > [email protected] > > > > > > wrote: > > > > > > > Hi > > > > > > > > Hbase stores everything in binary so if you want to scan a table > using > > > cli > > > > and get some different formatting you can specify that: > > > > > > > > get 'tablename','rowid' {column => [‘cf:qualifier1:toInt’] } > > > > W dniu Sat 25 Apr 2015 o 00:45 Arthur Chan <[email protected] > > > > > > napisał(a): > > > > > > > > > Hi all, > > > > > > > > > > Need help!! > > > > > > > > > > I have started playing around with Nutch2.3+Gora+HBase, but the > some > > > > field > > > > > output looks strange in HBase, is there any configuration or a > simple > > > > step > > > > > I might be missing? > > > > > > > > > > status: value=\x00\x00\x00\x01 > > > > > prevFetchTime: value=\x00\x00\x01L\x91]\xF5\x1C > > > > > fetchTime: value=\x00\x00\x01L\x93\x92\x0F\x5C > > > > > > > > > > Hope someone can help me out (: > > > > > > > > > > > > > > >
