On this page

Show all

Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Datasource Connections/ Creating a Datasource Connection with an HBase Table/ Querying an HBase Table

Querying an HBase Table

Updated on 2024-09-29 GMT+08:00

View PDF

This statement is used to query data in an HBase table.

Syntax

    
       SELECT * FROM table_name LIMIT number;

Keywords

LIMIT is used to limit the query results. Only INT type is supported by the number parameter.

Precautions

The table to be queried must exist. Otherwise, an error is reported.

Example

Query data in the table.

    
       SELECT * FROM test_hbase limit 100;

Query Pushdown

Query pushdown implements data filtering using HBase. Specifically, the HBase Client sends filtering conditions to the HBase server, and the HBase server returns only the required data, speeding up your Spark SQL queries. For the filter criteria that HBase does not support, for example, query with the composite row key, Spark SQL performs data filtering.

Scenarios where query pushdown is supported

Query pushdown can be performed on data of the following types:
- Int
- boolean
- short
- long
- double
- string
NOTE:

Data of the float type does not support query pushdown.

Query pushdown is not supported for the following filter criteria:

>, <, >=, <=, =, !=, and, or

The following is an example:

          
             select * from tableName where (column1 >= value1 and column2<= value2) or column3 != value3

The filtering conditions are like and not like. The prefix, suffix, and inclusion match are supported.

The following is an example:

          
             select * from tableName where column1 like "%value" or column2 like "value%" or column3 like "%value%"

IsNotNull()

The following is an example:

          
             select * from tableName where IsNotNull(column)

in and not in

The following is an example:

          
             select * from tableName where column1 in (value1,value2,value3)  and column2 not in (value4,value5,value6)

between _ and _

The following is an example:

          
             select * from tableName where column1 between value1 and value2

Filtering of the row sub-keys in the composite row key

For example, to perform row sub-key query on the composite row key column1+column2+column3, run the following statement:

          
             select * from tableName where column1= value1

Scenarios where query pushdown is not supported

Query pushdown can be performed on data of the following types:
Except for the preceding data types where query pushdown is supported, data of other types does not support query pushdown.

Query pushdown is not supported for the following filter criteria:

Length, count, max, min, join, groupby, orderby, limit, and avg

Column comparison

The following is an example:

          
             select * from tableName where column1 > (column2+column3)

Parent topic: Creating a Datasource Connection with an HBase Table

Previous topic: Inserting Data to an HBase Table

Next topic: Creating a Datasource Connection with an OpenTSDB Table

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot