Use Tunnel to upload log data to MaxCompute - MaxCompute

This topic describes how to use Tunnel to upload log data to MaxCompute.

Prerequisites

The odpscmd client is installed. For more information, see Install and configure the MaxCompute client.
Log data is stored in a local directory.loghub.csv is used as an example in this topic.

Background information

Tunnel is a tool that can be used to upload large volumes of data to MaxCompute at a time. It is suitable for offline computing. For more information, see Usage notes.

Procedure

On the odpscmd client, run the following commands to create a table named loghub that is used to store the uploaded data:

Enable the new data types supported by MaxCompute V2.0. Commit the following command with the SQL statement that is used to create the table:
set odps.sql.type.system.odps2=true;
-- Create a table named loghub.
CREATE TABLE loghub
(
client_ip   STRING ,
receive_time STRING ,
topic STRING,
id STRING,
name VARCHAR(32),
salenum STRING
);

Run the following command to upload log data to MaxCompute:
```
Tunnel u D:\loghub.csv loghub;
```
where,
- D:\loghub.csv: specifies the path where the log data file is stored.
- loghub: specifies the name of the MaxCompute table that is used to store log data.
Note Wildcards or regular expressions are not supported for Tunnel-based data uploads.
Execute the following statement to check whether the data is uploaded to the table:
```
SELECT * FROM loghub;
```
If the result shown in the following figure is displayed, the data is uploaded.