edit-icon download-icon

Table creation

Last Updated: Apr 04, 2018

You can use any of the three methods to create a new table namely new table creation, visualized table creation, and table creation using ODPS_SQL script.

New table creation

  1. Go to the Data Development page, and select New > Create Table.

    CreateTable

  2. Enter the statement of table creation in the dialog box, and click OK to create a new table.

    Once the table is created, you can query a newly created table by finding it in Table Query module on the left side. For more information, see Table query.

Note:

  • You can only edit and run one statement of table creation when creating the table. Only the first statement, the one before the first “;”, can be run if you edit more than one statement.
  • The MaxCompute SQL syntax is required in the statement of table creation. This syntax is slightly different from the standard SQL. For more statements of table creation, see DDL SQL.

Visualized table creation

You can use any of the following two methods to enter the visualized table creation page:

  • Create a visualized table with the link on the Create a Table page
  1. Go to the Data Development > New > Create Table page, and click Visualized Table Creation in the dialog box.

    Visualize

  2. Follow the instructions on the visualized table creation page to create a table.

  • Create a visualized table on the Data Management page
  1. Go to the Data Management > Table Management page, and click Create Table in the upper right corner.

  2. To create a table, follow the instructions on the Visualized Table creation page.

Table creation by using an ODPS_SQL script

If you get used to edit SQL statements, want to run multiple statements of table creation at a time, or must modify the table structure, you can develop a script by using ODPS_SQL script. For more information, see Script development.

Create an ODPS_SQL script file. Enter an ODPS_SQL statement (including DDL statements for creating or modifying tables) in the editing area, and click Run. For statements of table creation, see DDL SQL.

View a table

The following are the two methods to view a table.

  • Table query

    After a table is created, click Table Query in the left-side navigation pane on the Data Development page, to query a newly created table. For more information, see Table query.

  • Query data

    After a table is created, click Query Data in the left-side navigation pane on the Data Development page to search for a newly created table based on the table name and then query the table.

Thank you! We've received your feedback.