Adding a Catalog
In Presto, connectors allow you to access different data sources – e.g., Hive, PostgreSQL, or MySQL.
To add a catalog for the Hive connector:
Create a file
hive.properties
in~/.prestoadmin/catalog
with the following content:connector.name=hive-hadoop2 hive.metastore.uri=thrift://<metastore-host-or-ip>:<metastore-port>
Distribute the configuration file to all of the nodes in the cluster:
./presto-admin catalog add hive
Restart Presto:
./presto-admin server restart
You may need to add additional properties for the Hive connector to work properly, such as if your Hadoop cluster is set up for high availability. For these and other properties, see the Hive Connector.
For detailed documentation on catalog add
, see catalog add.
For more on which catalogs Presto supports, see the Teradata Supported Connectors.