Document Center
Data Lake Analytics
Product Introduction
What is Data Lake Analytics?
Highlights
Limits
Versions
Scenarios
Pricing
Pricing overview
Billing problems
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
Schema management
Query schema details
DLA message acknowledgment
Background
Use MNS for message acknowledgment
Use MQ for message acknowledgment
OSS file format conversion
File format conversion methods and considerations
ORC
Parquet
One Click Data Warehouse
What is One Click Data Warehouse
Create schemas by using the wizard
Instantly synchronize data
View data synchronization tasks
Authorize DLA to delete OSS files
Alibaba Cloud Service Access
OSS
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
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
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
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
Geospatial analysis functions
JSON functions and operators
Math functions
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
Background and preparations
Convert between rows and columns
Expand JSON data into row-column relation form
Analyze data with temporary tables
DLA data types and syntax
Use DataWorks to schedule DLA task cyclically
Background and preparations
FAQ
General Q&A
API Reference
API
Common parameters
Request structure
Sign signatures
List of operations by function
Service management
GetRegionStatus
Endpoint management
GetAllowIP
QueryEndPointList
SetAllowIP
Other management
DescribeRegionList
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
Billing problems
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
Schema management
DLA message acknowledgment
OSS file format conversion
One Click Data Warehouse
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
CREATE TABLE LIKE MAPPING
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
Geospatial analysis functions
JSON functions and operators
Math functions
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
Use DataWorks to schedule DLA task cyclically
Show more
Show less
FAQ
General Q&A
Show more
Show less
API Reference
API
List of operations by function
Service management
Endpoint management
Other management
Appendix
Show more
Show less
Free Trial
Free Trial