Retrieving timestamp from hbase row

java hbase flume
Abhijeet Pathak picture Abhijeet Pathak · Nov 30, 2011 · Viewed 14.1k times · Source

Using Hbase API (Get/Put) or HBQL API, is it possible to retrieve timestamp of a particular column?

Answer

codingFoo picture codingFoo · Nov 30, 2011

Assuming your client is configured and you have a table setup. Doing a get returns a Result

Get get = new Get(Bytes.toBytes("row_key"));
Result result_foo = table.get(get);

A Result is backed by a KeyValue. KeyValues contain the timestamps. You can get either a list of KeyValues with list() or get an array with raw(). A KeyValue has a get timestamp method.

result_foo.raw()[0].getTimestamp()

Related questions

Hbase client ConnectionLoss for /hbase error

I'm going completely crazy: Installed Hadoop/Hbase, all is running; /opt/jdk1.6.0_24/bin/jps 23261 ThriftServer 22582 QuorumPeerMain 21969 NameNode 23500 Jps 23021 HRegionServer 22211 TaskTracker 22891 HMaster 22117 SecondaryNameNode 21779 DataNode 22370 Main 22704 JobTracker Pseudo distributed environment. hbase shell is working and coming up with correct results running 'list' …

Read More
java.sql.SQLException: org.apache.thrift.transport.TTransportException in hive?

I'm trying to create table in hive with java. I found java.sql.SQLException: org.apache.thrift.transport.TTransportException while executing my code. Here is my code public void createTable(String tableName) { try{ Statement stat = con.createStatement(); String QueryString = "CREATE …

Read More
Hbase client can't connect to remote Hbase server

i have written a following hbase client class for remote server: System.out.println("Hbase Demo Application "); // CONFIGURATION // ENSURE RUNNING try { HBaseConfiguration config = new HBaseConfiguration(); config.clear(); config.set("hbase.zookeeper.quorum", "192.168.15.20"); config.set("hbase.zookeeper.property.clientPort","2181"); config.set("…

Read More