For details, please click:

Ali cloud analysis database use tutorial

AnalyticDB is a cloud computing service independently developed by Alibaba, which enables you to conduct real-time multi-dimensional analysis perspective and business exploration for hundreds of billions of data in milliseconds. The free calculation and fast response ability of analytical database to massive data enables users to conduct flexible data exploration in a moment, quickly discover the value of data, and can be directly embedded into the business system to provide analysis services for end customers.

Development history /Release Note

Release Note

V2.3.4 (2017-09-12)

Changing the type of a Cache Table configuration item cacheTableRowlimit; Changes in the MasterConfig mqNetworkPartTimeoutRatioAutoTuning defaults; Change the subPartition value of the real-time secondary partition table BUILD. Fixed Dump to ODPS only display query results in MPP mode. Fix the problem that CTAS Connection cannot be obtained. V2.0.2 (2017-03-21)

Added BI tool compatibility mode, greatly increasing the compatibility of Tableau and other BI tools, including syntax, functions, special usage, etc. Enabling this mode will reduce query performance to a certain extent, so you need to submit a work order to apply for enabling this mode. (Thanks to Liu Guangtao and Jin Dongxu of Lingyun Technology (Tianjin) Co., LTD for their requirements and cooperation.) Optimize query performance in small Full MPP Mode. Optimizer fixed some Full MPP Mode and LM computing engine syntax inconsistencies. The V2.0.1 (2016-12-20)

Fixed timestamp/date comparison with string in Full MPP Mode engine where condition: 8 hours difference; Fixed LM engine if there are two ON conditions in left join will result in incorrect calculation results; Intersect two subqueries in Full MPP Mode engine SQL parsing exception; Insert into… Select the from… ; Optimize LM and Full MPP Mode engine query performance, and slightly improve Full MPP Mode engine concurrent query capability. V2.0.0 (2016-11-29, original V0.9.45)

New Added the Dump to OSS function. New Added the UUID function, providing the tool function to generate a unique value, added instr, group_concat functions; INSERT into table SELECT… The from… SELECT clause supports small table broadcast; New Full MPP Mode is changed from internal test to public test for all users (but this Mode is still not perfect, we do not promise performance, availability and functional integrity); Optimize multiple query performance and write optimizations; Fixes fixed several bugs in query and write, as well as in Full MPP Mode. V0.9.15 (2016-06-21)

New Added large capacity instance, large storage instance single GB storage cost reduced by more than 10 times (currently invited test function, open to purchase later) New added new Full MPP Mode computing engine, SQL function integrity greatly improved, complete support for cross-partition computing (currently invited test function, V0.9.10 (2016-05-06)

New Added large capacity instances, large storage instances single GB storage cost reduced by more than 10 times (only available in dual 10 GIGABit network models, query performance is lower than high performance Mode instances) New added Full MPP Mode computing engine, SQL function integrity greatly improved. Full support for cross-partition computing (disabled by default) New support for CREATE TABLE [AS] SELECT, INSERT into… Select and other functions that generate temporary tables from existing data are added to support secondary partitioning for real-time write mode tables. Optimize Table query, Optimize Table, etc.

Added support for access control (RAM) sub-accounts to access analytical databases and access control of sub-accounts at the instance level of analytical databases Fixed issue where instance performance information may not be updated under heavy traffic V0.8.38 (2016-04-25)

New Support for dynamic modification of the maximum number of secondary partitions in an existing table New support for setting the DB level IP access whitelist (temporarily required to request work order) Fix the console display of inaccurate disk usage (low) Optimize the write stability of real-time write tables V0.8.35 (2016-03-20)

Added small table broadcast mode Join support V0.8.30 (2016-03-09)

V0.8.18 (2015-12-22) New Monthly package discount mode New users can query SQL performance through query_profile. Fix the problem that FRONTNODE is easy to run out of memory under large query volume.

Optimize the memory footprint and query performance of real-time write tables, and reject new INSERT/DELETE when system resources cannot afford it. Customers with C1 specifications can also apply for enabling real-time write after upgrade. (note: The real-time write function is still in internal test, please submit work order to apply for opening.) Add and enhance the functions of “show variables like”, “show collation like” and “show session like”. Closer to the MySQL standard. Fix a bug where 1000 entries with a total size of more than 8MB May delay writing for one day. (Note: Real-time writing is still an internal test function, customers who need it please submit work order to apply for opening). Improved compatibility with some BI tools, such as QlikSense under mysql Connector OBDC 5.1.7. Fixed some permissions management related and other bugs. Added user manual Optimize command for real-time tables. V0.8.13 (2015-10-27)

Newly added BI tools such as Tableau Desktop and Qlikview to support the connection of analytical database to optimize the performance and stability of real-time writing. Select * from table… select * from table… Column_name (compatible with MySQL return format) Changed from dbname.table_name. Column_name to column_name only (compatible with MySQL return format) If the amount of data read exceeds the limit, an anomaly is reported (error code 20042) and the official name of the product is changed from ADS of Ali Cloud analysis database service to V0.8.3 (2015-09-22).

The contents of type_name column in information_schema.tables are inconsistent with the MySQL standard. The column type is changed from string type to numeric type. If your business depends on this ID, modify it accordingly. The new ADS will push metering information to Ali Cloud metering system (but will not generate actual costs), fix a large number of bugfixes and performance optimization, as well as a number of other functional improvements. Please refer to the ADS user manual V0.8.2 (2015-08-27) after the release.

New You can manage the resource usage of your database based on the ECU (Elastic computing unit), and flexibly expand or shrink the capacity. See the user manual to be issued at that time. The changes deprecate the previous version of the business type (APP/BI/ ad-hoc) resource allocation model, and your existing DB has helped you migrate to the new ECU-based resource model. After the upgrade is successful, you can review our migration results and adjust ECU parameters by yourself. Any component added to ADS will support multi-tenant isolation, and the behavior of other users will no longer affect you. (except data import at present) Added real-time write function (internal test, need to apply for whitelist open) released the second phase, support delete any where condition column (but does not support function as a condition), support real-time write table after the establishment of the increase of columns, a certain degree of optimization of insert/ DELETE statement performance. The new ADS console (DMS for ADS) provides more accurate statistics on the disk space of the database and supports operations such as viewing the current ECU resource quantity and capacity expansion and reduction using DMS. In addition, the disk usage information of users’ DB will be pushed to ali Cloud monitoring, which supports users to establish alarm rules for disk usage in cloud monitoring. Added a series of date-related functions minute, Second, hour, datediff, to_days to fix a number of bugfixes and performance optimizations, as well as several other feature improvements. Please refer to the ADS user manual docs.aliyun.com/? V0.7.20 (2015-07-14)

New connection protocol compatible with MySQL ODBC driver, The compatibility of some BI tools and MySQL management tools to connect ADS through MySQL protocol is enhanced. New INSERT into support to omit column list when all columns are inserted. New SHOW CREATE TABLE DDL function is fixed Several bug fixes and performance optimizations; Fixed the count distinct feature for non-partitioned columns giving an error when the amount of data is too large to calculate instead of returning incomplete results

Minus syntax added udF_SYS_count_DISTINCt_column added support for constant columns, MySQL > select 1 as a from TBL select 1 as a from TBL

Added real-time INSERT/DELETE function (this function has been opened in the domestic demand whitelist in the last month, customers in need please submit work order application); Add MySQL connection protocol compatible with MySQL 5.5/5.6, and C#.net connection support; Fixed several other performance optimizations and Bug fixes. V0.6.20 (2015-03-05)

New Subquery Join subquery New Where in (subquery with dimension table) New Dump data into ODPS function New YEARMONTH function change group by/Union The result of all returns null data as in the case of raw data

Official website of Ali Yun University (Official website of Ali Yun University, Innovative Talent Workshop under cloud Ecology)