openGauss Connector
The openGauss connector allows querying and creating tables in an external openGauss database. This can be used to join data between different systems like openGauss and Hive, or between two different openGauss instances.
Configuration
To configure the openGauss connector, create a catalog properties file in etc/catalog
named, for example, opengauss.properties
, to mount the openGauss connector as the opengauss
catalog. Create the file with the following contents, replacing the connection properties as appropriate for your setup:
connector.name=openguass
connection-url=jdbc:postgresql://example.net:5432/database
connection-user=root
connection-password=secret
Multiple openGauss Databases or Servers
The openGauss connector can only access a single database within a openGauss server. Thus, if you have multiple openGauss databases, or want to connect to multiple openGauss servers, you must configure multiple instances of the openGauss connector.
To add another catalog, simply add another properties file to etc/catalog
with a different name (making sure it ends in .properties
). For example, if you name the property file sales.properties
, openLooKeng will create a catalog named sales
using the configured connector.
Querying openGauss
The openGauss connector provides a schema for every openGauss schema. You can see the available openGauss schemas by running SHOW SCHEMAS
:
SHOW SCHEMAS FROM opengauss;
If you have a openGauss schema named public
, you can view the tables in this schema by running SHOW TABLES
:
SHOW TABLES FROM opengauss.public;
You can see a list of the columns in the hetutb
table in the public
database using either of the following:
DESCRIBE opengauss.public.hetutb;
SHOW COLUMNS FROM opengauss.public.hetutb;
Finally, you can access the hetutb
table in the public
schema:
SELECT * FROM opengauss.public.hetutb;
If you used a different name for your catalog properties file, use that catalog name instead of opengauss
in the above examples.
Note:
- When the compatibility type of the openGuass database is O (DBCOMPATIBILITY = A), the
Date
data type is not supported.
- The openGuass driver does not support put the connection in read-only mode to enable database optimization at present.
- The unit of openGauss’s
Character
data type is byte (e.g.n
indicates to the byte length ofVARCHAR(n)
data type), the unit of openLooKeng’sCharacter
data type is character (e.g.n
indicates to the character length ofVARCHAR(n)
data type). openGauss connector does not support usecreate-table-as
method to create a table containingCharacter
data type directly, the byte length ofCharacter
data type needs to manually specified.
- The
use-connection-pool
configuration is not supported.
If the subsequent version of openGuass supports the above restriction, we will make corresponding adaptation.
openGauss Connector Limitations
The following SQL statements are not yet supported:
DELETE, GRANT, REVOKE, SHOW GRANTS, SHOW ROLES, SHOW ROLE GRANTS