Use Lindorm Distributed Processing System (LDPS) to access data stored in an ApsaraDB for HBase Performance-enhanced Edition cluster.
Prerequisites
Before you begin, ensure that you have:
LDPS activated for your Lindorm instance. For more information, see Activate LDPS and modify the configurations
Read the precautions for accessing data through LDPS. For more information, see Precautions
Completed the job-specific setup for your job type:
JDBC jobs: Use JDBC in application development
JAR jobs: Create a job in Java
Python jobs: Create a job in Python
Access HBase data through LDPS
Connect to LindormTable using Lindorm-cli. For more information, see Use Lindorm-cli to connect to and use LindormTable.
Use Lindorm SQL to map the qualifiers in your HBase table to fields in a Lindorm wide table. For more information, see Use SQL statements to access an HBase table.
Access the HBase table through LDPS the same way you access a Lindorm wide table. For more information, see Access data in wide tables.
Convert BINARY row key data
When the primary key field ROW in an HBase table is mapped to a BINARY field in a Lindorm wide table, use the following built-in functions to convert the BINARY byte array to a specific data type.
For information about the data types supported by ApsaraDB for HBase Performance-enhanced Edition, see Use SQL statements to access an HBase table.
| Function | Return type | Parameters |
|---|---|---|
to_hstring(bin, offset, length) | STRING | bin: the byte array to convert. offset: the starting byte position; integer >= 0. length: the number of bytes to convert; integer > 0. |
to_hboolean(bin, offset) | BOOLEAN | bin: the byte array to convert. offset: the starting byte position; integer > 0. |
to_hshort(bin, offset) | SHORT | bin: the byte array to convert. offset: the starting byte position. |
to_hinteger(bin, offset) | INTEGER | bin: the byte array to convert. offset: the starting byte position. |
to_hlong(bin, offset) | LONG | bin: the byte array to convert. offset: the starting byte position. |
to_hfloat(bin, offset) | FLOAT | bin: the byte array to convert. offset: the starting byte position. |
to_hdouble(bin, offset) | DOUBLE | bin: the byte array to convert. offset: the starting byte position. |