[
https://issues.apache.org/jira/browse/HIVE-8374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14228204#comment-14228204
]
Lefty Leverenz commented on HIVE-8374:
--------------------------------------
bq. Kept the dbOpts option as that is useful when we add any db specific
options.
Does dbOpts need to be documented, or is it for future use? Any other
documentation, or is this just a bug fix?
* [Hive Schema Tool |
https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool#HiveSchemaTool-TheHiveSchemaTool]
> schematool fails on Postgres versions < 9.2
> -------------------------------------------
>
> Key: HIVE-8374
> URL: https://issues.apache.org/jira/browse/HIVE-8374
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema
> Reporter: Mohit Sabharwal
> Assignee: Mohit Sabharwal
> Fix For: 0.15.0
>
> Attachments: HIVE-8374.1.patch, HIVE-8374.2.patch, HIVE-8374.3.patch,
> HIVE-8374.patch
>
>
> 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 with the error:
> {code}
> Error: ERROR: language "plpgsql" does not exist
> Hint: Use CREATE LANGUAGE to load the language into the database.
> (state=42704,code=0)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
