Document Center
Data Lake Analytics
Versions
Versions
Product Introduction
What is Data Lake Analytics?
Scenarios
Highlights
Pricing
Pricing overview
Quick Start
Limits
Activate DLA
Initialize the password of the DLA primary database account
Wizard for creating OSS tables
Run SQL statements
Deep Dive
Manage endpoint
Create endpoints
Delete an endpoint
Connent to DLA
Connect to DLA
Connect to DLA through MySQL CLI tools
Connect to DLA through service systems
Connect to DLA through a Druid database connection pool
Connect to DLA through JDBC program connection
Call PreparedStatement to connect to DLA
Connect to DLA through clients
DBeaver
Navicat for MySQL
SQL WorkBench/J
Account management
Accounts and permissions
Reset passwords
Delete sub-accounts
Schema management
Query schema details
One Click Data Warehouse
Introduction
What is One Click Data Warehouse
Create OSS schemas by using the wizard
Instantly synchronize data
View data synchronization tasks
Authorize DLA to delete OSS files
Advanced options
Message acknowledgment
Background
Use MNS for message acknowledgment
Use MQ for message acknowledgment
Alibaba Cloud Service Access
OSS
Create OSS partition tables
Execute INSERT OVERWRITE to insert data into an OSS partition table
OSS file format conversion
File format conversion methods and considerations
ORC
Parquet
File formats
Storage formats and SerDe
CSV
JSON
TSV
ORC
PARQUET
Read OSS logs
Background and preparations
Create OSS schemas
Create tables based on OSS logs and read data from the logs
Table Store
Read data from Table Store
Background and preparations
Create a Table Store schema
Create a Table Store table and read data from the table
RDS
One-click metadata synchronization to ApsaraDB for RDS
Read and write ApsaraDB RDS for MySQL data
Background and preparations
Create a MySQL schema
Create a MySQL table and read and write data from and to the table
ApsaraDB RDS for PostgreSQL
Create a PostgreSQL schema
Create a PostgreSQL table
ApsaraDB RDS for SQL Server
Create an SQL Server schema
Create an SQL Server table
User-created databases
Read and write data from and to user-created ECS-based MySQL databases
Background and preparations
Create a MySQL schema
Create a MySQL table and read data from the table
Redis
Read Redis data
Background and preparations
Create a Redis schema
Create a Redis table and read data from the table
MongoDB
Read and write MogoDB data
Background and preparations
Create a MongoDB schema
Create a MongoDB table and read and write data from and to the table
DataWorks
Use DataWorks to shcedule tasks in DLA
Use DataWorks to schedule DLA task cyclically
Background and preparations
SQL Reference
DLA data types and syntax
Common SQL statements
DDL
CREATE SCHEMA
CREATE TABLE
CREATE TABLE LIKE MAPPING
Overview
Automatically create tables based on MongoDB collections
Automatically create tables based on OSS files
Automatically create tables based on RDS tables
ALTER TABLE
DROP TABLE
DROP SCHEMA
DML
INSERT
Syntax
Insert data into OSS
Insert data into ApsaraDB for RDS
Insert data into Table Store
SELECT
MSCK REPAIR TABLE
SHOW
ACL
GRANT
REVOKE
Function Syntax
Aggregation functions
IP address resolution functions
Binary functions and operators
Bitwise functions
Conversion functions
Date and time functions and operators
Geospatial analysis functions
JSON functions and operators
Math functions
String functions and operators
Conditional expressions
Window functions
Best Practices
Analyze a large number of logs inexpensively
Perform joint query on multiple MySQL instances in DLA
Analyze data with temporary tables
Use DLA and DataV to set a dashboard
Background and preparations
Procedure
Use DLA and Quick BI for graphical query and analysis of data in OSS
Background and preparations
Procedure
Convert rows or columns and expand JSON data into row-column relation form
Background and preparations
Convert between rows and columns
Expand JSON data into row-column relation form
all-products-head
This Product
This Product
All Products
Data Lake Analytics
Data Lake Analytics
All Products
Versions
Versions
Show more
Show less
Product Introduction
What is Data Lake Analytics?
Scenarios
Highlights
Show more
Show less
Pricing
Pricing overview
Show more
Show less
Quick Start
Limits
Activate DLA
Initialize the password of the DLA primary database account
Wizard for creating OSS tables
Run SQL statements
Show more
Show less
Deep Dive
Manage endpoint
Connent to DLA
Account management
Schema management
One Click Data Warehouse
Message acknowledgment
Show more
Show less
Alibaba Cloud Service Access
OSS
Table Store
RDS
User-created databases
Redis
MongoDB
DataWorks
Show more
Show less
SQL Reference
DLA data types and syntax
Common SQL statements
DDL
DML
ACL
Show more
Show less
Function Syntax
Aggregation functions
IP address resolution functions
Binary functions and operators
Bitwise functions
Conversion functions
Date and time functions and operators
Geospatial analysis functions
JSON functions and operators
Math functions
String functions and operators
Conditional expressions
Window functions
Show more
Show less
Best Practices
Analyze a large number of logs inexpensively
Perform joint query on multiple MySQL instances in DLA
Analyze data with temporary tables
Use DLA and DataV to set a dashboard
Use DLA and Quick BI for graphical query and analysis of data in OSS
Convert rows or columns and expand JSON data into row-column relation form
Show more
Show less
Free Trial
Free Trial