MaxCompute:Import and export table data

Prerequisites

Before you begin, ensure that you have:

• MaxCompute Tunnel configured for your project in MaxCompute Studio. For more information, see Install and configure the MaxCompute client

• Permissions to manage tables in your MaxCompute project

Import data

1. In the Project Explorer tool window, expand Tables & Views under your MaxCompute project. Right-click the target table and select Import data into table.

2. In the Importing data to table_name dialog box, configure the following parameters:

   Parameter	Description	Valid values	Default
   Input File	Path of the local file to import.	-	-
   File charset	Encoding format of the input file.	UTF-8, UTF-16, UTF-16BE, UTF-16LE, ISO-8859-1, US-ASCII, GBK	UTF-8
   Partition	Partition to import data into. Applies only to partitioned tables. Skip this parameter for non-partitioned tables.	-	-
   Column Separator	Column delimiter for the input file.	Comma(','), Space(' '), Tab('\t')	Comma(',')
   Record Limit	Maximum number of rows to import.	-	-
   Size(MB) Limit	Maximum size of data to import, in MB.	-	-
   Error Record Limit	Maximum number of error rows allowed during import.	-	-
   Include Column Header	Whether to include the column header row during import.	-	-

3. Click OK. A Success message confirms that the data has been imported. Open the table to verify the imported data.

Export data

1. In the Project Explorer tool window, expand Tables & Views under your MaxCompute project. Right-click the target table and select Export data from table.

2. In the Exporting data from table_name dialog box, configure the following parameters:

   Parameter	Description	Valid values	Default
   Output File	Path of the local file to store the exported data.	-	-
   File charset	Encoding format of the output file.	UTF-8, UTF-16, UTF-16BE, UTF-16LE, ISO-8859-1, US-ASCII, GBK	UTF-8
   Column Separator	Column delimiter for the output file.	Comma(','), Space(' '), Tab('\t')	Comma(',')
   Record Limit	Maximum number of rows to export.	-	-
   Size(MB) Limit	Maximum size of data to export, in MB.	-	-
   Error Record Limit	Maximum number of error rows allowed during export.	-	-
   Include Column Header	Whether to include the column header row in the output file.	-	-

3. Click OK. A Success message confirms that the data has been exported. Open the output file to verify the exported data.