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
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
Connect to DLA through DBeaver
Connect to DLA through MySQL Workbench
Account management
Accounts and permissions
Reset passwords
Delete sub-accounts
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
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
SELECT
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
Use DLA to create an OSS partition table
Analyze a large number of historical logs inexpensively
Use DLA to perform joint queries in multiple MySQL instances
DLA task scheduling in DataWorks
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
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
SELECT
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
Use DLA to create an OSS partition table
Analyze a large number of historical logs inexpensively
Use DLA to perform joint queries in multiple MySQL instances
DLA task scheduling in DataWorks
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