Using Kyuubi By Terminal

Prerequisites:

• There must be a running Kyuubi. To deploy and run Kyuubi, please refer to Kyuubi doc

Terminal supports interfacing with Kyuubi to submit SQL to Kyuubi for execution. All you need to do is add the Kyuubi configuration as instructed below:

ams:
    terminal:
      backend: kyuubi
      kyuubi.jdbc.url: jdbc:hive2://127.0.0.1:10009/ # kyuubi Connection Address

Without configuring Kyuubi, Terminal executes in memory in AMS.

To execute SQL in Terminal, you can refer to the following steps:：

• Please switch Catalog first
• Before writing SQL, you can use the provided SQL Shortcuts function to help you build SQL quickly.
• Writing SQL
• Click the Execute button to run the SQL;