Command like SQL LIMIT in HBase

nosql hbase
Mohammad picture Mohammad · Dec 22, 2012 · Viewed 59.2k times · Source

Does HBase have any command that works like SQL LIMIT query?

I can do it by setStart and setEnd, but I do not want to iterate all rows.

Answer

th30z picture th30z · Dec 22, 2012

From the HBase shell you can use LIMIT:

hbase> scan 'test-table', {'LIMIT' => 5}

From the Java API you can use Scan.setMaxResultSize(N) or scan.setMaxResultsPerColumnFamily(N).

Related questions

Scan HTable rows for specific column value using HBase shell

I want to scan rows in a HTable from hbase shell where a column family (i.e., Tweet) has a particular value (i.e., user_id). Now I want to find all rows where tweet:user_id has value test1 …

Read More
Scan with filter using HBase shell

Does anybody know how to scan records based on some scan filter i.e.: column:something = "somevalue" Something like this, but from HBase shell?

Read More
Difference between HBase and Hadoop/HDFS

This is kind of naive question but I am new to NoSQL paradigm and don't know much about it. So if somebody can help me clearly understand difference between the HBase and Hadoop or if give some pointers which might …

Read More