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 (: > > > > > > > > > >
