• Post author:
  • Post category:HBase
  • Post last modified:March 27, 2024
  • Reading time:4 mins read

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

Naveen Nelamali

Naveen Nelamali (NNK) is a Data Engineer with 20+ years of experience in transforming data into actionable insights. Over the years, He has honed his expertise in designing, implementing, and maintaining data pipelines with frameworks like Apache Spark, PySpark, Pandas, R, Hive and Machine Learning. Naveen journey in the field of data engineering has been a continuous learning, innovation, and a strong commitment to data integrity. In this blog, he shares his experiences with the data as he come across. Follow Naveen @ LinkedIn and Medium