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.

댓글

이 블로그의 인기 게시물

Using the MinIO API via curl

vsftpd default directory

[Ubuntu] *.deb 파일 설치 방법

Offset out of range error in Kafka, 카프카 트러블슈팅

리눅스 (cron - 주기적 작업실행 데몬)

리눅스 (하드링크&소프트링크)

CDPEvents in puppeteer

Using venv in Python