/sqltools-hive-vscode-extension

This is a SQLTools plugin to integrate with Hive. Providing for running Hive SQL and getting results, SQL formatting, generating SQL statements and SQL completion.

Primary LanguageJavaScriptMIT LicenseMIT

SQLTools Hive Driver

This is a SQLTools plugin to integrate with Hive. Providing for running Hive SQL and getting results, SQL formatting, generating SQL statements and SQL completion.

Premises and Recommends

This plugin is only for connection testing and local resources management, please use below products for development and production.

Quick Start

  • Prepare an EMR instance, we use Alibaba Cloud EMR as an example, goto EMR Console and apply an instance and setup instance password.

Apply an Hive Instance1

Apply an Hive Instance2

Apply an Hive Instance3

Setting Instance Password

  • After instance application, goto EMR on ECS and open new applied instance detail page and click master node link (need to wait for instances running).

Open Master Node

  • Setup a public network card for EMR Master ECS. After the network card setup will get a public IP address.

Binding a Public Network Card

  • Switch navigated tabs to security groups and allow port 10000 access from used IP address to EMR Master ECS.

ECS Security Group

ECS Security Group Network Ports"

Hive SQLTools Demo1

  • Input EMR Master ECS public IP address, port 10000, instance username and password.

Hive SQLTools Demo2"

  • If you use Alibaba Cloud EMR Hive, it already prepared some sample data, click show table records icon and see results.

Hive SQLTools Demo3"

  • Run SQLs and see results.

Hive SQLTools Demo4"

  • Support auto database, schema, table and column names SQL completion.

Hive SQLTools Demo5"

Hive SQLTools Demo6"

  • Support generate SQL insert statements.

Hive SQLTools Demo7"

  • Support SQL format.

Hive SQLTools Demo8"