You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@oozie.apache.org by "Hadoop QA (JIRA)" <ji...@apache.org> on 2011/09/08 06:25:10 UTC

[jira] [Created] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like .
GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
--------------------------------------------------------------------------------------------------------

                 Key: OOZIE-80
                 URL: https://issues.apache.org/jira/browse/OOZIE-80
             Project: Oozie
          Issue Type: Bug
            Reporter: Hadoop QA


Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like . Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OOZIE-80?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13101746#comment-13101746 ] 

Hadoop QA commented on OOZIE-80:
--------------------------------

tucu00 remarked:
OK, no prob with that. Just wondering, what does it buys? (asking because all operations are within the DB we are connected to)

> GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
> --------------------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-80
>                 URL: https://issues.apache.org/jira/browse/OOZIE-80
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Hadoop QA
>
> Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like . Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OOZIE-80?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13101748#comment-13101748 ] 

Hadoop QA commented on OOZIE-80:
--------------------------------

jeromyc remarked:
Tucu, any further concerns with this? Seems like a low-risk, low-cost change that encourages good multi-tenant database practices.

> GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
> --------------------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-80
>                 URL: https://issues.apache.org/jira/browse/OOZIE-80
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Hadoop QA
>
> Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like . Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OOZIE-80?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13101747#comment-13101747 ] 

Hadoop QA commented on OOZIE-80:
--------------------------------

bansalmayank remarked:
We faced one big issue in our production with oracle bug which is returning ORA 00942 error in case of multiple schemas having same object names within same database server. We found out that its Oracle bug and in process to release a ORACLE patch, however its good practice if we use schema names with data base objects. DBA's are recommending this practice for the future.

> GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
> --------------------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-80
>                 URL: https://issues.apache.org/jira/browse/OOZIE-80
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Hadoop QA
>
> Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Resolved] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like . Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OOZIE-80?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hadoop QA resolved OOZIE-80.
----------------------------

    Resolution: Fixed

> GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
> --------------------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-80
>                 URL: https://issues.apache.org/jira/browse/OOZIE-80
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Hadoop QA
>
> Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like . Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OOZIE-80?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13101749#comment-13101749 ] 

Hadoop QA commented on OOZIE-80:
--------------------------------

tucu00 remarked:
+1, sorry I thought I was clear with my OK.

> GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
> --------------------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-80
>                 URL: https://issues.apache.org/jira/browse/OOZIE-80
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Hadoop QA
>
> Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like . Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OOZIE-80?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13101744#comment-13101744 ] 

Hadoop QA commented on OOZIE-80:
--------------------------------

tucu00 remarked:
where this should be? a bit of more context please

> GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
> --------------------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-80
>                 URL: https://issues.apache.org/jira/browse/OOZIE-80
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Hadoop QA
>
> Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like . Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OOZIE-80?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13101745#comment-13101745 ] 

Hadoop QA commented on OOZIE-80:
--------------------------------

bansalmayank remarked:
We should be adding the schema name infront of the table names. in all our data base queries.
We are using OPEN JPA which can take schema name from the configuration and append infront of the table names.

> GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
> --------------------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-80
>                 URL: https://issues.apache.org/jira/browse/OOZIE-80
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Hadoop QA
>
> Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like . Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OOZIE-80?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13099779#comment-13099779 ] 

Hadoop QA commented on OOZIE-80:
--------------------------------

bansalmayank remarked:
 <schema name>.<object name>

> GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
> --------------------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-80
>                 URL: https://issues.apache.org/jira/browse/OOZIE-80
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Hadoop QA
>
> Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Reopened] (OOZIE-80) GH-39: Oozie should use fully qualified names for the data base objects like . Posted by "Roman Shaposhnik (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OOZIE-80?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Roman Shaposhnik reopened OOZIE-80:
-----------------------------------


> GH-39: Oozie should use fully qualified names for the data base objects like <schema name>.<object name>
> --------------------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-80
>                 URL: https://issues.apache.org/jira/browse/OOZIE-80
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Hadoop QA
>
> Oozie should use fully qualified names for the data base objects like <schema name>.<object name>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira