11.4. Starburst Hive Connector#
The Starburst Hive Connector is an extended version of the Hive Connector with configuration and usage identical.
The following improvements are included:
Before running any
CREATE TABLE or
CREATE TABLE ... AS statements for
Hive tables in Presto, you need to check that the operating system user running
the Presto server has access to the Hive warehouse directory on HDFS.
The Hive warehouse directory is specified by the configuration variable
hive-site.xml, and the default value is
/user/hive/warehouse. If that is not the case, either add the following to
jvm.config on all of the nodes:
is an operating system user that has proper permissions for the Hive warehouse
directory, or start the Presto server as a user with similar permissions. The
hive user generally works as
USER, since Hive is often started with the
hive user. If you run into HDFS permissions problems on
CREATE TABLE ...
/tmp/presto-* on HDFS, fix the user as described above, then
restart all of the Presto servers.
When connecting to Hive metastore version 3, the Hive connector supports reading from the following types of transactional tables:
insert-only and ACID,
partitioned and not partitioned,
bucketed and not bucketed.
The Hive connector supports reading from Hive materialized views. In Presto, these views are presented as regular, read-only tables.
Statistics collection is supported for Hive Metastore and Amazon Glue.
Configuring and using Presto with AWS Glue is described in the AWS Glue Support documentation section.