Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Creating a Datasource Connection with a DWS table> Querying the DWS Table
View PDF

Querying the DWS Table

This statement is used to query data in a DWS 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

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

Example

To query data in the dli_to_dws table, enter the following statement:

1
 
SELECT * FROM dli_to_dws limit 100;