-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/26403/
-----------------------------------------------------------
Review request for hive.
Bugs: HIVE-8374
https://issues.apache.org/jira/browse/HIVE-8374
Repository: hive-git
Description
-------
HIVE-8374: schematool fails on Postgres versions < 9.2
The upgrade script for HIVE-5700 creates an UDF with language 'plpgsql',
which is available by default only for Postgres 9.2+.
For older Postgres versions, the language must be explicitly created,
otherwise schematool fails.
This patch adds a command line option to schematool to specify
that the language should be created:
"-dbOpts postgres.filter.pre.9"
Diffs
-----
beeline/src/java/org/apache/hive/beeline/HiveSchemaHelper.java
a21fa652e9c1aa3fd763afa4136f6fcb7c7b7459
beeline/src/java/org/apache/hive/beeline/HiveSchemaTool.java
c376687cb47332323912e4c6dbe713b7b37ae834
itests/hive-unit/src/test/java/org/apache/hive/beeline/TestSchemaTool.java
749fb9e86b4f74f768da356cf82f621fdef399cd
metastore/scripts/upgrade/postgres/015-HIVE-5700.postgres.sql
aedb2b5dbf9b513cb7c124f59e05ea9831455a72
Diff: https://reviews.apache.org/r/26403/diff/
Testing
-------
Added unit test
Thanks,
Mohit Sabharwal
