Help Center> Data Lake Insight> Spark SQL Syntax Reference> Datasource Connections> Creating a Datasource Connection with an RDS Table> Querying the RDS Table
Updated on 2023-11-03 GMT+08:00
View PDF

Querying the RDS Table

This statement is used to query data in an RDS 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 table to be queried must exist. Otherwise, an error is reported.

Example

Query data in the test_ct table.

1
 
SELECT * FROM dli_to_rds limit 100;