Help Center/ Data Lake Insight/ SQL Syntax Reference (Paris Region)/ Spark SQL Syntax Reference/ Creating a Datasource Connection with a DDS Table/ Querying the DDS Table
Updated on 2022-12-07 GMT+08:00
View PDF
Share

Querying the DDS Table

This statement is used to query data in a DDS table.

Syntax

1
 
SELECT * FROM table_name LIMIT number;

Keyword

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

Precautions

If schema information is not specified during table creation, the query result contains the _id field for storing _id in the DOC file. For example:

Example

Query data in the test_mongo table.

1
 
SELECT * FROM test_mongo limit 100;