Data Lake Analytics (DLA) is a serverless, interactive cloud query and analysis service. It can connect to Table Store through standard JDBC and allows you to query and analyze data in Table Store without ETL operations.
This topic describes how to connect Table Store through DLA and read data from Table Store.
Database and table mapping
Table Store DLA Instance Schema or database Table table Primary key column (pk) column, isPrimaryKey=true, isNullable=false Non-primary key column (column) column, isPrimaryKey=false, isNullable=<you can define this parameter through DDL>
Table Store DLA INTEGER(8bytes) bigint(8bytes) STRING varchar BINARY varbinary DOUBLE double BOOLEAN boolean
Before reading data from Table Store and analyzing data in DLA, you must have prepared the test data in Table Store by performing the following steps:
In the following example, create a table named nation in Table Store and insert 25 records to the nation table.
On the DMS for Data Lake Analytics page, compile SQL statements to create a Table Store schema, a Table Store table, and read data from the Table Store table. Alternatively, connect to DLA through the MySQL client or MySQL CLI tool, and then compile SQL statements to create a Table Store schema, a Table Store table, and read data from the Table Store table.