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:

    1. ams:
    2.     terminal:
    3.       backend: kyuubi
    4.       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;

    terminal