All Products
Search
Document Center

Run SQL statements

Last Updated: May 13, 2019

After you create tables in DLA, you can execute standard SQL statements to manage data in these tables. The DLA console provides an SQL runtime environment. This topic describes how to execute SQL statements in the DLA console.

Procedure

  1. Log on to the Data Lake Analytics console.

  2. In the left-side navigation pane, click Execute. On the Execute page that appears, write an SQL statement, and then click Sync Execute(F8) or Async Execute(F9).

    1

More information

You can log on to the Data Lake Analytics console, and click Log on in DMS to execute SQL statements for managing data in tables.

Alternatively, you can use code, MySQL CLI tools, or MySQL clients to connect to DLA, and then execute SQL statements to manage data in tables. For more information about how to connect to DLA, see Connect to DLA.