All Products
Search
Document Center

Background and preparations

Last Updated: Apr 05, 2020

MaxCompute (formerly known as ODPS) is a fast and fully-hosted TB or PB-level data warehouse solution.

You can create a MaxCompute schema (mapping database) and a MaxCompute mapping table in Data Lake Analytics (DLA). Then, you can use the MySQL client or MySQL command-line interface (CLI) to connect to the MaxCompute schema in DLA and execute standard SQL statements to read data from MaxCompute.

Prerequisites

Make the following preparations in DLA:

  1. Activate DLA

  2. Initialize the password of the DLA primary database account

Make the following preparations in MaxCompute:

  1. Activate MaxCompute

  2. Create a project

  3. Use DataWorks to create a test table and prepare test data.

    This example uses DDL statements to create the bank_data table. For more information, see Create a table called bank_data in Create a table and upload data.

    1. CREATE TABLE IF NOT EXISTS bank_data
    2. (
    3. age BIGINT COMMENT 'age',
    4. job STRING COMMENT 'job type',
    5. marital STRING COMMENT 'marital status',
    6. education STRING COMMENT 'education level',
    7. default STRING COMMENT 'credit card ownership',
    8. housing STRING COMMENT 'mortgage',
    9. loan STRING COMMENT 'loan',
    10. contact STRING COMMENT 'contact information',
    11. month STRING COMMENT 'month',
    12. day_of_week STRING COMMENT 'day of the week',
    13. duration STRING COMMENT 'duration',
    14. campaign BIGINT COMMENT 'contact times during the campaign',
    15. pdays DOUBLE COMMENT 'interval from the last contact',
    16. previous DOUBLE COMMENT 'previous contact times with the customer',
    17. poutcome STRING COMMENT 'result of the previous marketing campaign',
    18. emp_var_rate DOUBLE COMMENT 'employment change rate',
    19. cons_price_idx DOUBLE COMMENT 'consumer price index',
    20. cons_conf_idx DOUBLE COMMENT 'consumer confidence index',
    21. euribor3m DOUBLE COMMENT 'euro deposit rate',
    22. nr_employed DOUBLE COMMENT 'number of employees',
    23. y BIGINT COMMENT 'whether time deposit is available'
    24. );

    Import banking data to the bank_data table. For more information, see Upload local data to bank_data in Create a table and upload data.