[
https://issues.apache.org/jira/browse/AMBARI-2466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13690906#comment-13690906
]
Yusaku Sako commented on AMBARI-2466:
-------------------------------------
Tested the following scenarios with cluster installs, making sure smoke test
passes, and that service config pages work properly and reconfiguration works
properly:
Hive using New MySQL option
Hive using Existing MySQL option
Hive using Existing Oracle option
Oozie using Derby Option
Oozie using Existing MySQL Option
Oozie using Existing Oracle option
Also tested upgrade paths by installing a 1.2.3 cluster and upgrading to 1.2.4,
and making sure that service reconfig works properly:
Hive using New MySQL option
Oozie using Derby option
> Hive/Oozie database settings should accept custom JDBC URLs
> -----------------------------------------------------------
>
> Key: AMBARI-2466
> URL: https://issues.apache.org/jira/browse/AMBARI-2466
> Project: Ambari
> Issue Type: Bug
> Components: client
> Affects Versions: 1.2.4
> Reporter: Yusaku Sako
> Assignee: Yusaku Sako
> Priority: Critical
> Fix For: 1.2.4
>
> Attachments: AMBARI-2466_branch-1.2.4.patch, AMBARI-2466.patch
>
>
> Ran into issues setting up Hive and Oozie with an Oracle database.
> 1. We are hard-coding port 1521 for the JDBC URL.
> 2. There are two types of JDBC URLs for Oracle:
> * jdbc:oracle:thin:@[HOST][:PORT]:SID
> * jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE
> We are making the assumption that it is the latter, but this may not work
> depending on how Oracle is set up.
> 3. We prompt for the "Database Name". In Oracle context, this could be the
> SID or SERVICE NAME, but it's not clear what this is.
> As a solution to all of the above, we will construct the JDBC URL based on
> the database type, host, and name for Hive/Oozie and present it to the user
> as an editable text field during install.
> Post-install, the JDBC URL remains editable, but does not change
> automatically as changes other database-related parameters.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
