Document Center
Data Lake Analytics
Product Introduction
What is Data Lake Analytics?
Highlights
Limits
Versions
Scenarios
Pricing
Pricing overview
Pricing and billing questions
Quick Start
Start with Alibaba Cloud DLA
Activate DLA
Initialize the password of the DLA primary database account
Wizard for creating OSS tables
Create OSS schemas
Create 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
DLA message acknowledgment
Background
Use MNS for message acknowledgment
Use MQ for message acknowledgment
Alibaba Cloud Service Access
OSS
File formats
Overview
CSV
JSON
TSV
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
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
One-click metadata synchronization to ApsaraDB for RDS
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
SQL Reference
Common SQL statements
CREATE SCHEMA
CREATE TABLE
DROP SCHEMA
DROP TABLE
INSERT
Syntax
Insert data into OSS
Insert data into ApsaraDB for RDS
Insert data into Table Store
SELECT
ALTER TABLE
MSCK REPAIR TABLE
SHOW
GRANT
REVOKE
Function Syntax
Aggregation functions
IP address resolution functions
Binary functions and operators
Bitwise functions
Conversion functions
Date and time functions and operators
JSON functions and operators
Mathematical functions and operators
String functions and operators
Conditional expressions
Window functions
Best Practices
Create OSS partition tables in DLA
Execute INSERT OVERWRITE to insert data into an OSS partition table
Analyze a large number of historical logs inexpensively
Perform joint query on multiple MySQL instances in DLA
Use DataWorks to shcedule tasks in DLA
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
Expand JSON data into row-column relation form
Analyze data with temporary tables
DLA data types and syntax
FAQ
General Q&A
API Reference
API
Common parameters
Request structure
Sign signatures
List of operations by function
Account management
AddAccount
DeleteAccount
QueryAccountList
UpdateAccountPassword
Service management
GetRegionStatus
InitializeRegion
ResetMainPassword
UnSubscribeRegion
Endpoint management
AddEndPoint
RemoveEndPoint
GetAllowIP
GetEndPoint
QueryEndPointList
SetAllowIP
Other management
DescribeRegionList
QueryDataSourceDef
Appendix
DLA regions
Error codes
all-products-head
This Product
This Product
All Products
Data Lake Analytics
Data Lake Analytics
All Products
Product Introduction
What is Data Lake Analytics?
Highlights
Limits
Versions
Scenarios
Show more
Show less
Pricing
Pricing overview
Pricing and billing questions
Show more
Show less
Quick Start
Start with Alibaba Cloud DLA
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
DLA message acknowledgment
Show more
Show less
Alibaba Cloud Service Access
OSS
Table Store
RDS
User-created databases
Redis
MongoDB
Show more
Show less
SQL Reference
Common SQL statements
CREATE SCHEMA
CREATE TABLE
DROP SCHEMA
DROP TABLE
INSERT
SELECT
ALTER TABLE
MSCK REPAIR TABLE
SHOW
GRANT
REVOKE
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
JSON functions and operators
Mathematical functions and operators
String functions and operators
Conditional expressions
Window functions
Show more
Show less
Best Practices
Create OSS partition tables in DLA
Execute INSERT OVERWRITE to insert data into an OSS partition table
Analyze a large number of historical logs inexpensively
Perform joint query on multiple MySQL instances in DLA
Use DataWorks to shcedule tasks in DLA
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
Analyze data with temporary tables
DLA data types and syntax
Show more
Show less
FAQ
General Q&A
Show more
Show less
API Reference
API
List of operations by function
Account management
Service management
Endpoint management
Other management
Appendix
Show more
Show less
Free Trial
Free Trial