HBase – Scan or Select the table

  • Post author:
  • Post category:HBase
  • Post last modified:November 22, 2022

This tutorial describes how to read rows from the table using the HBase shell and will practice with some examples.

Reading (Scan) the Rows from HBase table using Shell

Use scan command to get the data from the HBase table. By default, it fetches all data from the table.

Examples:

We can limit the results by passing scanner specification LIMIT, below example limits to one row.

Below command limits the results to 2 rows ‘1’ and ‘2’

Using COLUMN specification, we can list the rows that have columns specified

This returns 2 rows with columns ‘name’ and ‘age’.

We could also specify STARTROW from where the results should return

STOPROW specification will specify where to stop.

To list all deleted columns, use RAW option

Other scan command examples to explore.

Net: will learn how to filter the rows

NNK

SparkByExamples.com is a Big Data and Spark examples community page, all examples are simple and easy to understand and well tested in our development environment Read more ..

Leave a Reply