This topic provides answers to some frequently asked questions about how to get started with MaxCompute.

What do I do if a newly created MaxCompute project does not support implicit data type conversions?

If you set odps.sql.type.system.odps2 to true, the MaxCompute V2.0 data type edition is enabled. In this case, implicit data type conversions may be disabled. To avoid this issue, you can set odps.sql.type.system.odps2 to false to disable the MaxCompute V2.0 data type edition.

How do I create a table in MaxCompute?

MaxCompute allows you to create a table by using one of the following methods:

How do I execute SQL statements in MaxCompute?

You can execute SQL statements in the DataWorks console, on the MaxCompute client, or by using an SDK or a Java Database Connectivity (JDBC) driver.

How do I import data to MaxCompute?

You can import data to MaxCompute on the MaxCompute client. You can also import data to MaxCompute by using tools, such as MaxCompute Studio, Tunnel SDK, Data Integration of DataWorks, Apache Sqoop, Flume, Fluentd, and Logstash. For more information, see Data migration tools.

How do I restore table data if I delete the data by mistake?

MaxCompute provides the backup and restoration feature. This feature allows MaxCompute to automatically back up and retain the original data for a specific period of time. Original data refers to the data on which no operations are performed, including deletion and modification operations. This way, you can restore data within the retention period to prevent data loss. For more information about the backup and restoration feature, see Backup and restoration.

Can I reference tables across projects?

Yes, you can reference tables across projects after you are granted the required permissions. MaxCompute provides multiple authorization methods, such as access control list (ACL)-based authorization, policy-based authorization, and resource access across projects. For more information, see Permission overview.