Step 1: Logging in to the Public Cloud

1. Open the cloud homepage.
2. On the login page, enter the Username and Password, and click Login.

Step 2: Uploading Data to OBS

DLI allows you to query data stored on OBS. Before querying the data, you need to upload the data file to OBS.

1. From the menu on top of the public cloud homepage, move your cursor on Products.
2. In the services displayed, click Object Storage Service in Storage.
3. On the OBS product page, click Console. The OBS console page is displayed.
4. Create a bucket. The bucket name is globally unique. In this example, assume that the bucket name is obs1.
   1. Click Create Bucket in the upper right corner.
   2. On the Create Bucket page that is displayed, specify Region and enter the Bucket Name.
      

      When creating an OBS bucket, you must select the same region as the DLI management console.

   3. Click Create Now.
5. Click obs1 to switch to the Summary page.
6. In the left navigation tree, click Objects. Click Upload Object. In the displayed dialog box, drag files or folders to upload or add file, for example, sampledata.csv to the file upload box. Then, click Upload.

   After the file is uploaded successfully, the file path to be analyzed is obs://obs1/sampledata.csv.

   For more information about OBS, see the Object Storage Service Console Operation Guide.

   You are advised to use an OBS tool, such as OBS Browser+ or obsutil, to upload large files because OBS Console has restrictions on the file size and quantity. OBS Browser+ is a graphical tool that provides complete functions for managing your buckets and objects in OBS. You are advised to use this tool to create buckets or upload objects. obsutil is a command line tool for accessing and managing OBS resources. If you are familiar with command line interface (CLI), obsutil is recommended as an ideal tool for batch processing and automated tasks. For details about how to upload files to OBS, see the OBS Tool Guide.

   You can upload files to buckets in different ways. Then, OBS stores the files in the buckets as objects.

   Table 1 Access modes of objects uploaded to OBS

   Access Mode	Upload Method
   Console	Uploading a File
   OBS Browser+	Uploading an Object Using OBS Browser+
   obsutil	Uploading an Object Using obsutil
   SDK	Uploading an Object Using SDK . For details, see the section about object upload in the Developer Guide of each language.
   API	Uploading Objects - PUT and Uploading Objects - POST

Step 3: Logging In to the DLI Management Console

1. From the menu on top of the public cloud homepage, move your cursor on Products.
2. In the service list displayed, click Data Lake Insight in Enterprise Intelligence.
3. On the DLI product page, click Access Console. The DLI management console page is displayed. If you log in to the DLI management console for the first time, you need to be authorized to access OBS.

Step 4: Creating a Queue

A queue is the basis for using DLI. Before executing an SQL job, you need to create a queue.

• An available queue default is preset in DLI. If the default queue is used, the system performs charging based on the amount of data scanned.
• You can also create queues as required. If the self-built queue is used, the billing is performed based on the used CUH or purchased yearly/monthly packages.
  1. On the DLI management console, click SQL Editor in the navigation pane on the left. The SQL Editor page is displayed.
  2. On the left pane of the displayed SQL Editor page, click to the right of Queues.

     For details about how to create a queue, see Creating a Queue.

     For details, see Data Lake Insight Price Details.

Step 5: Creating a Database

Before querying data, create a database, for example, db1.

The default database is a built-in database. You cannot create the database named default.

1. On the DLI management console, click SQL Editor in the navigation pane on the left. The SQL Editor page is displayed.
2. In the editing window on the right of the SQL Editor page, enter the following SQL statement and click Execute. Read and agree to the privacy agreement, and click OK.

   create database db1;

   After database db1 is successfully created, db1 will be displayed in the Database drop-down list box of Databases.

   

   When you execute a query on the DLI management console for the first time, you need to read the privacy agreement. You can perform operations only after you agree to the agreement. For later queries, you will not need to read the privacy agreement again.

Step 6: Creating a Table

After database db1 is created, create a table (for example, table1) based on the sample data file obs://obs1/sampledata.csv stored on OBS in db1.

1. In the upper right corner of the SQL Editor page, select the queue default and database db1.
2. Enter the following SQL statement in the job editor window and click Execute.

   create table table1 (id int, name string) using csv options (path 'obs://obs1/sampledata.csv');

   After the table is created, click the Databases tab and then select db1. The created table table1 is displayed in the lower part of the Table area.

Step 7: Querying Data

After performing the preceding steps, you can start querying data.

1. In the Table area on the SQL Editor page, double-click the created table table1. The SQL statement is automatically displayed in the SQL job editing window in the right pane. The following statement shows how to query 1,000 records in the table1 table:

   select * from db1.table1 limit 1000;

2. Click Execute. The system starts the query.

   After the SQL statement is executed successfully, you can view the query result in View Result under the SQL job editing window.