Get a row from hbase shell

To retrieve a row from HBase by its row key using the HBase shell, you can use the get command. Here’s the syntax and an example to help you do this:

Syntax

get 'table_name', 'row_key'

Example

Suppose you have an HBase table named my_table and you want to retrieve a row with the row key row1. Here’s how you can do it:

hbase(main):001:0> get 'my_table', 'row1'

This command fetches the row with the specified row key (row1) from my_table.

Additional Options

The get command also supports additional options for specifying column families and versions. Here are some useful options:

  1. Specify a Column Family and Column:

    get 'table_name', 'row_key', 'column_family:column'
    

    For example, to retrieve only the name column in the info column family:

    get 'my_table', 'row1', 'info:name'
    
  2. Retrieve Multiple Versions:

    get 'table_name', 'row_key', {COLUMN => 'column_family:column', VERSIONS => 3}
    

    This command retrieves the latest 3 versions of the specified column.

  3. Display Result in JSON Format:

    get 'table_name', 'row_key', {FORMAT => 'json'}
    

Complete Example with Options

To get multiple versions of a specific column in JSON format:

get 'my_table', 'row1', {COLUMN => 'info:name', VERSIONS => 3, FORMAT => 'json'}

This command will output the latest 3 versions of the name column in the info family in JSON format.

댓글

이 블로그의 인기 게시물

Install and run an FTP server using Docker

Using the MinIO API via curl

PYTHONPATH, Python 모듈 환경설정

Elasticsearch Ingest API

오늘의 문장2

How to checkout branch of remote git, 깃 리모트 브랜치 체크아웃

Fundamentals of English Grammar #1

To switch to a specific tag in a Git repository

You can use Sublime Text from the command line by utilizing the subl command

티베트-버마어파 와 한어파(중국어파)의 어순 비교