All Products
Search
Document Center

Background and preparations

Last Updated: Apr 24, 2019

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.

    1

  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