Background and preparations

Background

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.

Data type comparison between Table Store and DLA

• 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>

• Field mapping

  Table Store	DLA
  INTEGER(8bytes)	bigint(8bytes)
  STRING	varchar
  BINARY	varbinary
  DOUBLE	double
  BOOLEAN	boolean

Prerequisites

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:

1. Activate Table Store

2. Create a Table Store instance

3. Create a table

4. Bind the Table Store instance to a VPC

5. Write data to the table

   In the following example, create a table named nation in Table Store and insert 25 records to the nation table.

   

6. Authorize the Table Store data source to DLA.

Procedure

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.

1. Create a Table Store schema

2. Create a Table Store table and read data from the table