This topic describes how to use SQL to access data in LindormTable from LDPS.
Preparations
Before you use SQL to access data in LindormTable, you must understand the precautions described in Precautions.
Make sure that required resources are initialized based on the type of your jobs. For more information, see the following documentation:
Access data in a wide table
You can access data in a Lindorm wide table in the "lindorm_table"
catalog. You can perform only DML operations on Lindorm wide tables when you use LDPS to access the tables. DDL operations and partitioning are not supported. The following examples show how to access data in a wide table:
Use the
"lindorm_table"
catalog.USE lindorm_table;
Query the schema of a table named test.
SHOW CREATE TABLE test;
The following result is returned:
+----------------------------------------------------+ | CREATE TABLE default.test ( | | `id` INT, | | `name` STRING) | | | +----------------------------------------------------+
Insert data to a Lindorm wide table.
INSERT INTO test VALUES (0, 'Jay');
Query data in a Lindorm wide table.
SELECT * FROM test;
For more information about the supported SQL syntax, see DML Statements.