[
https://issues.apache.org/jira/browse/AMBARI-5734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmytro Sen resolved AMBARI-5734.
--------------------------------
Resolution: Fixed
Committed to trunk
> Ambari installation should run the hive schema script for Oracle and Postgres
> as Metastore DB
> ---------------------------------------------------------------------------------------------
>
> Key: AMBARI-5734
> URL: https://issues.apache.org/jira/browse/AMBARI-5734
> Project: Ambari
> Issue Type: Bug
> Components: client, controller
> Affects Versions: 1.6.0
> Reporter: Dmytro Sen
> Assignee: Dmytro Sen
> Fix For: 1.6.1
>
>
> Hive-metastore package.jdo will create hive metastore schema if the schema
> does not exist. However, the package does not detect the database flavor.
> Different database has different synatx. In the case of Oracle, it causes
> problem such as ORA-01754: a table may contain only one column of type LONG.
> The recommended way should be populate hive metastore in advance with scripts
> provided in /usr/lib/hive/scripts/.... by schematool
> instead of using autoCreate.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
