[HIVE-8374] schematool fails on Postgres versions < 9.2

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Database/Schema
• Labels: TODOC1.0
• Assignee: Mohit Sabharwal
• Reporter: Mohit Sabharwal
• Created: 07/Oct/14 02:45
• Updated: 19/May/17 06:43
• Resolved: 14/Oct/14 21:37

Description

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:

Error: ERROR: language "plpgsql" does not exist
  Hint: Use CREATE LANGUAGE to load the language into the database. (state=42704,code=0)

Issue Links

• links to: review board