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.

댓글

이 블로그의 인기 게시물

JAXB @XmlTransient 예제

Screenshot of a web page using Puppeteer with a specific browser width, 웹페이지 스크린샷

how to make inactive kafka topic, 카프카 토픽 비활성화

ssh-copy-id in ansible

What are 5 creative things I could do with my kids' art, 아이와 함께하는 창의적 놀이

How to catch exceptions on Future in Java, 자바 Future 에러 잡기

To change the ESE index in Fluent Bit

Consume a topic from kafka by Python

패션 하의, Pants, Skirts, Shorts, Skorts

ftplib.error_perm: 550 Permission denied