[jira] [Created] (HIVE-17151) Uploaded image for project: 'Bug DB' Bug DBBUG-84676 Hive tables are being created in public schema with (Postgres DB)

["amarnath reddy pappu (JIRA)" <ji...@apache.org>]

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)