Apache Zeppelin is a web-based notebook that enables interactive data analytics. Apache Zeppelin is integrated with abundant language backends or interpreters, such as Scala, Python, Spark SQL, and Hive. This helps you create interactive, collaborative documents. Hologres is compatible with PostgreSQL. It allows you to directly connect to Apache Zeppelin for data analytics. This topic describes how to connect Apache Zeppelin to Hologres and analyze data in a visualized manner.
Limits
In the latest version of Apache Zeppelin, the PostgreSQL interpreter is deprecated and its features are merged into the JDBC interpreter. In this case, you can use the JDBC interpreter that provides the same features to connect Apache Zeppelin to Hologres.
Connect Apache Zeppelin to Hologres
Install Apache Zeppelin.
For more information about how to install Apache Zeppelin, see Apache Zeppelin official documentation.
Configure an interpreter.
Log on to Apache Zeppelin, click the username in the upper-right corner, and then select Interpreter from the drop-down list.
Click Create in the upper-right corner and configure the required parameters to create an interpreter.
Enter a name in the Interpreter Name field.
Select JDBC from the Interpreter group drop-down list.
After you select JDBC from the Interpreter group drop-down list, configure the parameters described in the following table.
Parameter
Description
default.url
The Java Database Connectivity (JDBC) URL that is used to connect to Hologres. Specify the value in the format of
jdbc:postgresql://{host}:{port}/{database}. The JDBC URL contains the following variables:host: the endpoint of the Hologres instance. You can obtain the endpoint of the Hologres instance from the Network Information section of the instance details page in the Hologres console.
port: the port number of the Hologres instance. You can obtain the port number of the Hologres instance from the Network Information section of the instance details page in the Hologres console.
database: the name of the Hologres database.
default.user
The AccessKey ID of the Alibaba Cloud account used to connect to the Hologres database. For more information about how to obtain the AccessKey ID, see Create an Alibaba Cloud account.
default.password
The AccessKey secret of the Alibaba Cloud account used to connect to the Hologres database. For more information about how to obtain the AccessKey secret, see Create an Alibaba Cloud account.
You can also set other parameters on the Properties page based on your business needs. For more information about the parameters, see Apache Zeppelin official documentation.
Click Save in the lower part of the page to save the configuration.
Create a notebook for data analytics.
You must add the name of the interpreter, such as
%hologres, before the SQL statement that you are writing in the notebook. This way, Apache Zeppelin can use the specified interpreter to generate and send a query request. You can specify the way to display data on the page. The query result is displayed in the lower part of the page.