Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Datasource Connections/ Creating a Datasource Connection with a CSS Table/ Querying the CSS Table
Updated on 2024-08-19 GMT+08:00
View PDF

Querying the CSS Table

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

Syntax

1
 
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

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

1
 
SELECT * FROM dli_to_css limit 100;