ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yusaku Sako (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-2466) Hive/Oozie database settings should accept custom JDBC URLs
Date Fri, 21 Jun 2013 23:47:20 GMT

    [ 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

Mime
View raw message