amarnath reddy pappu created HIVE-17151:
-------------------------------------------
Summary: Uploaded image for project: 'Bug DB' Bug
DBBUG-84676 Hive tables are being created in public schema with (Postgres DB)
Key: HIVE-17151
URL: https://issues.apache.org/jira/browse/HIVE-17151
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 1.2.0
Reporter: amarnath reddy pappu
Priority: Critical
1. Installing Hive with "Existing PostgreSQL Database " option creates tables
in public schema even schema name is specified during the installation
configurations.
2. lets say if customer creates Postgres user with search_path only pointing to
that specific schema and don't have any visibility to public schema then
installation would fail during the insert queries stage as created tables are
not part of selected schema. It fails with insert query errors.
3. In
/var/lib/ambari-server/common-services/HIVE/0.12.0.2.0/package/etc/hive-schema-0.12.0.postgres.sql
file we are hard coding the search_path as below which is causing the issue.
SET search_path = public, pg_catalog;
Options
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
