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:
Specify a Column Family and Column:
get 'table_name', 'row_key', 'column_family:column'For example, to retrieve only the
namecolumn in theinfocolumn family:get 'my_table', 'row1', 'info:name'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.
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.
댓글
댓글 쓰기