Create and view a table

Prerequisites

Create a table

1. Log on to the MaxCompute client.
   Run ./bin/odpscmd in a Linux operating system or ./bin/odpscmd.bat in a Windows operating system. Check whether the name of the project that you access is correct. In this example, the project name is MaxCompute_DOC. If the name of the project that you access is not MaxCompute_DOC, run the following command to switch to this project:

   use MaxCompute_DOC;

   If the information shown in the following figure is returned, the project is switched.
2. Execute the following statement to create a table. For more information, see Table operations.

   CREATE TABLE [IF NOT EXISTS] table_name 
   [(col_name data_type [COMMENT col_comment], ...)] 
   [COMMENT table_comment] 
   [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)] 
   [LIFECYCLE days] 
   [AS select_statement]

   In this topic, the bank_data and result_table tables need to be created. The bank_data table stores business data, and the result_table table stores the results of data analytics.

   • Statement for creating the bank_data table:

     CREATE TABLE IF NOT EXISTS bank_data
     (
      age             BIGINT COMMENT 'Age',
      job             STRING COMMENT 'Job type',
      marital         STRING COMMENT 'Marital status',
      education       STRING COMMENT 'Education level',
      default         STRING COMMENT 'Credit card',
      housing         STRING COMMENT 'Mortgage',
      loan            STRING COMMENT 'Loan',
      contact         STRING COMMENT 'Contact',
      month           STRING COMMENT 'Month',
      day_of_week     STRING COMMENT 'Day of the week',
      duration        STRING COMMENT 'Duration',
      campaign        BIGINT COMMENT 'Number of contacts during the campaign',
      pdays           DOUBLE COMMENT 'Interval from the last contact',
      previous        DOUBLE COMMENT 'Number of contacts with the customer',
      poutcome        STRING COMMENT 'Result of the previous marketing campaign',
      emp_var_rate    DOUBLE COMMENT 'Employment variance rate',
      cons_price_idx  DOUBLE COMMENT 'Consumer price index',
      cons_conf_idx   DOUBLE COMMENT 'Consumer confidence index',
      euribor3m       DOUBLE COMMENT 'Euro deposit rate',
      nr_employed     DOUBLE COMMENT 'Number of employees',
      y               BIGINT COMMENT 'Time deposit available or not'
     );

     You can execute the preceding table creation statement. After you create the table, OK is displayed.
     Note If an error is reported on the MaxCompute client, we recommend that you manually enter the SQL statement to execute it, or use the ad hoc query feature of DataWorks to execute the SQL statement. For more information, see Use the ad-hoc query feature to execute SQL statements (optional).
   • Statement for creating the result_table table:

     CREATE TABLE IF NOT EXISTS result_table
     (  
      education   STRING COMMENT 'Education level',
      num         BIGINT COMMENT 'Number of persons'
     );

View a table

After a table is created, you can execute the following statement to view the table information:

desc <table_name>;

table_name indicates the name of the table that you want to view. For example, you can run the DESC bank_data; command to view the information of the bank_data table in the preceding example. The following figure shows the table information.

For more information about how to view the table information, see Table operations.

Other table operations

What to do next

After you create a table, you can import data to MaxCompute for further data processing. For more information about data import, see Import data.