On this page
Help Center/ MapReduce Service/ Component Operation Guide (Normal)/ Using Presto/ Presto FAQ/ How Do I Configure Multiple Hive Connections for Presto?

How Do I Configure Multiple Hive Connections for Presto?

Updated on 2022-12-09 GMT+08:00

Question

How do I configure multiple Hive connections for Presto?

Procedure

  1. Copy and distribute the core-site.xml and hdfs-site.xml files of the target Hive cluster to the Presto cluster and place them in a path (for example, /home/omm) on which user omm has the read permission. Change the file owner to omm:wheel and file permission to 750.
  2. Go to the Presto configuration page.

    • For MRS 1.8.10 or earlier: Log in to MRS Manager by referring to Accessing MRS Manager. Choose Services > Presto > Service Configuration, and select All from the Basic drop-down list.
    • For versions later than MRS 1.8.10 and version MRS 2.x: Click the cluster name on the MRS console, choose Components > Presto > Service Configuration, and select All from the Basic drop-down list.
      NOTE:

      If the Components tab is unavailable, complete IAM user synchronization first. (On the Dashboard page, click Synchronize on the right side of IAM User Sync to synchronize IAM users.)

    • For MRS 3.x or later: Log in to FusionInsight Manager and choose Cluster > Name of the desired cluster > Services > Presto. Click Configurations then All Configurations.

  3. Search for connector-customize in the search box.
  4. Add a connector named myhive.

    Add the following configuration to connector-customize:

    myhive.connector.name=hive-hadoop2

    myhive.hive.metastore.uri=thrift://{Metastore server IP address of the target Hive cluster}:{Metastore server port of the target Hive cluster} (Use commas (,) to separate multiple Metastore server addresses, for example, thrift://192.0.2.1:9083,thrift://192.0.2.2:9083.)

    myhive.hive.config.resources=/etc/hadoop/conf/core-site.xml,/etc/hadoop/conf/hdfs-site.xml (absolute path of the configuration files in 1)

    For details about other configurations, see https://trino.io/docs/333/connector/hive.html#hive-configuration-properties.

    When you add a configuration, add the connector name as the prefix to the configuration name. In this example, the connector name is myhive.

  5. Save the configuration and restart the Presto service.

    NOTE:

    Use the Presto client, JDBC, or UI tool to connect to the Presto service. Run the show schemas from myhive; command. If the database in the target cluster is displayed, the configuration is successful.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback