This topic describes how to create a Hive data source.
Prerequisites
Ensure network connectivity:
If you connect Quick BI to your Hive database over the public network, add Quick BI's IP addresses to your database whitelist. For more information, see Use security groups.
If you connect Quick BI to your Hive database over an internal network, set up a jump server and use an SSH tunnel to log on and access the database.
You have created a Hive database.
You have obtained the username and password for the Hive database.
Limits
Apache Hive versions 2.0.1 through 2.3.3 are supported.
Procedure
Log on to the Quick BI console.
Add a data source as follows.
Go to the data source creation interface from the Create data source entry.
On the Self-managed data sources tab, select Hive.
In the Configure connection dialog box, complete the following settings.
Name
Description
Display name
The display name shown in the data source list.
Enter a valid name without special characters. Do not include leading or trailing spaces.
Database address
The address where the Hive database is deployed, such as an IP address or domain name.
Port
The port number of the database.
Database
The name of the database to connect to.
Username
The username for the database.
Password
The password for the database.
SSH
Based on your scenario, choose whether to use SSH to connect to the data source. If you select SSH, configure the following parameters:
SSH Host: The hostname or IP address.
SSH username: The SSH username for the database.
SSH Password: the username and password for the corresponding database.
SSH port: The SSH port. The default is 22.
Initialization SQL
When enabled, you can specify SQL statements to run after the data source connection is initialized.
Only SET statements are allowed. Separate multiple statements with semicolons.
VPC data source
Select this option only if your database is deployed on an Alibaba Cloud ECS instance in an Alibaba Cloud VPC. If selected, enter the internal IP address and internal port for the database address and port.
Owner AccessKey ID and Owner AccessKey secret: The AccessKey ID and AccessKey secret of the account that purchased the instance. Ensure this account has read permissions on the destination instance. If it also has write permissions, the system automatically adds the required whitelist entries. Otherwise, you must add them manually. For more information, see Create a custom policy.
For more information, see Create an AccessKey.
Instance ID: The ECS instance ID. Log on to the ECS console and find the instance ID on the Instances tab.
For more information, see View instance information.
Region: The region where the ECS instance is located. Log on to the ECS console and check the region in the upper-left corner of the page.
For more information, see View instance information.
Click Test connection to verify connectivity to the data source.
If the test succeeds, click OK to complete adding the data source.
What to do next
After creating the data source, you can create datasets and analyze data.
Add tables from your Hive database or custom SQL statements to Quick BI. For more information, see Create a dataset.
Add visual charts and analyze data. For more information, see Create a dashboard, , and Overview of visual charts.
Drill down for deeper data analysis. For more information, see Step 3: Configure and display drilling.