You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Oren Lederman (JIRA)" <ji...@apache.org> on 2011/07/28 10:40:16 UTC

[jira] [Created] (HIVE-2320) Implement setCatalog()

Implement setCatalog()
----------------------

                 Key: HIVE-2320
                 URL: https://issues.apache.org/jira/browse/HIVE-2320
             Project: Hive
          Issue Type: Sub-task
          Components: JDBC
    Affects Versions: 0.7.1
            Reporter: Oren Lederman
            Priority: Minor


Currently, the JDBC driver always use "default" as the schema/database. We should allow setting the active schema to another schema.

1. implement the setCatalog() method
2. modify HiveConnection constructor to take the schema from the URL and call setCatalog
3. change configureConnection() and execute "use <schema>;" statement 

See https://issues.apache.org/jira/browse/HIVE-675

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

        

[jira] [Updated] (HIVE-2320) Implement setCatalog() and allow setting active database to a database other than "default"

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach updated HIVE-2320:
---------------------------------

    Status: Open  (was: Patch Available)

@Oren: Can you please submit the patch again and this time check the "Grant license to ASF for inclusion in ASF works" box at the bottom? We can't include the patch in Hive until you do this. Thanks!

> Implement setCatalog() and allow setting active database to a database other than "default"
> -------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2320
>                 URL: https://issues.apache.org/jira/browse/HIVE-2320
>             Project: Hive
>          Issue Type: Sub-task
>          Components: JDBC
>    Affects Versions: 0.7.1
>            Reporter: Oren Lederman
>            Priority: Minor
>              Labels: jdbc
>             Fix For: 0.8.0, 0.7.1
>
>         Attachments: HIVE-2320.Implement-setCatalog-and-allow-setting-active-database-to-a-database-other-than-default.1.patch
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Currently, the JDBC driver always use "default" as the schema/database. We should allow setting the active schema to another schema.
> 1. implement the setCatalog() method
> 2. modify HiveConnection constructor to take the schema from the URL and call setCatalog
> 3. change configureConnection() and execute "use <schema>;" statement 
> See https://issues.apache.org/jira/browse/HIVE-675

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

        

[jira] [Updated] (HIVE-2320) Implement setCatalog() and allow setting active database to a database other than "default"

Posted by "Oren Lederman (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Oren Lederman updated HIVE-2320:
--------------------------------

    Summary: Implement setCatalog() and allow setting active database to a database other than "default"  (was: Implement setCatalog())

> Implement setCatalog() and allow setting active database to a database other than "default"
> -------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2320
>                 URL: https://issues.apache.org/jira/browse/HIVE-2320
>             Project: Hive
>          Issue Type: Sub-task
>          Components: JDBC
>    Affects Versions: 0.7.1
>            Reporter: Oren Lederman
>            Priority: Minor
>              Labels: jdbc
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Currently, the JDBC driver always use "default" as the schema/database. We should allow setting the active schema to another schema.
> 1. implement the setCatalog() method
> 2. modify HiveConnection constructor to take the schema from the URL and call setCatalog
> 3. change configureConnection() and execute "use <schema>;" statement 
> See https://issues.apache.org/jira/browse/HIVE-675

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

        

[jira] [Updated] (HIVE-2320) Implement setCatalog() and allow setting active database to a database other than "default"

Posted by "Oren Lederman (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Oren Lederman updated HIVE-2320:
--------------------------------

    Attachment: HIVE-2320.Implement-setCatalog-and-allow-setting-active-database-to-a-database-other-than-default.1.patch

Patch for fixing the issue. This time with the grant license to ASF option

> Implement setCatalog() and allow setting active database to a database other than "default"
> -------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2320
>                 URL: https://issues.apache.org/jira/browse/HIVE-2320
>             Project: Hive
>          Issue Type: Sub-task
>          Components: JDBC
>    Affects Versions: 0.7.1
>            Reporter: Oren Lederman
>            Priority: Minor
>              Labels: jdbc
>         Attachments: HIVE-2320.Implement-setCatalog-and-allow-setting-active-database-to-a-database-other-than-default.1.patch, HIVE-2320.Implement-setCatalog-and-allow-setting-active-database-to-a-database-other-than-default.1.patch
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Currently, the JDBC driver always use "default" as the schema/database. We should allow setting the active schema to another schema.
> 1. implement the setCatalog() method
> 2. modify HiveConnection constructor to take the schema from the URL and call setCatalog
> 3. change configureConnection() and execute "use <schema>;" statement 
> See https://issues.apache.org/jira/browse/HIVE-675

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

        

[jira] [Commented] (HIVE-2320) Implement setCatalog() and allow setting active database to a database other than "default"

Posted by "Oren Lederman (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13076176#comment-13076176 ] 

Oren Lederman commented on HIVE-2320:
-------------------------------------

I considered two alternatives:
1. The one I used in the patch above - setting a local database variable in the constructor calling setCatalog() after calling configureConnection().
2. Setting a global database variable and calling setCatalog() from configureConnection()

> Implement setCatalog() and allow setting active database to a database other than "default"
> -------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2320
>                 URL: https://issues.apache.org/jira/browse/HIVE-2320
>             Project: Hive
>          Issue Type: Sub-task
>          Components: JDBC
>    Affects Versions: 0.7.1
>            Reporter: Oren Lederman
>            Priority: Minor
>              Labels: jdbc
>         Attachments: HIVE-2320.Implement-setCatalog-and-allow-setting-active-database-to-a-database-other-than-default.1.patch
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Currently, the JDBC driver always use "default" as the schema/database. We should allow setting the active schema to another schema.
> 1. implement the setCatalog() method
> 2. modify HiveConnection constructor to take the schema from the URL and call setCatalog
> 3. change configureConnection() and execute "use <schema>;" statement 
> See https://issues.apache.org/jira/browse/HIVE-675

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

        

[jira] [Updated] (HIVE-2320) Implement setCatalog() and allow setting active database to a database other than "default"

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach updated HIVE-2320:
---------------------------------

    Fix Version/s:     (was: 0.7.1)
                       (was: 0.8.0)

> Implement setCatalog() and allow setting active database to a database other than "default"
> -------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2320
>                 URL: https://issues.apache.org/jira/browse/HIVE-2320
>             Project: Hive
>          Issue Type: Sub-task
>          Components: JDBC
>    Affects Versions: 0.7.1
>            Reporter: Oren Lederman
>            Priority: Minor
>              Labels: jdbc
>         Attachments: HIVE-2320.Implement-setCatalog-and-allow-setting-active-database-to-a-database-other-than-default.1.patch
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Currently, the JDBC driver always use "default" as the schema/database. We should allow setting the active schema to another schema.
> 1. implement the setCatalog() method
> 2. modify HiveConnection constructor to take the schema from the URL and call setCatalog
> 3. change configureConnection() and execute "use <schema>;" statement 
> See https://issues.apache.org/jira/browse/HIVE-675

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

        

[jira] [Updated] (HIVE-2320) Implement setCatalog() and allow setting active database to a database other than "default"

Posted by "Oren Lederman (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Oren Lederman updated HIVE-2320:
--------------------------------

    Attachment: HIVE-2320.Implement-setCatalog-and-allow-setting-active-database-to-a-database-other-than-default.1.patch

> Implement setCatalog() and allow setting active database to a database other than "default"
> -------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2320
>                 URL: https://issues.apache.org/jira/browse/HIVE-2320
>             Project: Hive
>          Issue Type: Sub-task
>          Components: JDBC
>    Affects Versions: 0.7.1
>            Reporter: Oren Lederman
>            Priority: Minor
>              Labels: jdbc
>         Attachments: HIVE-2320.Implement-setCatalog-and-allow-setting-active-database-to-a-database-other-than-default.1.patch
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Currently, the JDBC driver always use "default" as the schema/database. We should allow setting the active schema to another schema.
> 1. implement the setCatalog() method
> 2. modify HiveConnection constructor to take the schema from the URL and call setCatalog
> 3. change configureConnection() and execute "use <schema>;" statement 
> See https://issues.apache.org/jira/browse/HIVE-675

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

        

[jira] [Updated] (HIVE-2320) Implement setCatalog() and allow setting active database to a database other than "default"

Posted by "Oren Lederman (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Oren Lederman updated HIVE-2320:
--------------------------------

    Fix Version/s: 0.7.1
                   0.8.0
           Status: Patch Available  (was: Open)

> Implement setCatalog() and allow setting active database to a database other than "default"
> -------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2320
>                 URL: https://issues.apache.org/jira/browse/HIVE-2320
>             Project: Hive
>          Issue Type: Sub-task
>          Components: JDBC
>    Affects Versions: 0.7.1
>            Reporter: Oren Lederman
>            Priority: Minor
>              Labels: jdbc
>             Fix For: 0.8.0, 0.7.1
>
>         Attachments: HIVE-2320.Implement-setCatalog-and-allow-setting-active-database-to-a-database-other-than-default.1.patch
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Currently, the JDBC driver always use "default" as the schema/database. We should allow setting the active schema to another schema.
> 1. implement the setCatalog() method
> 2. modify HiveConnection constructor to take the schema from the URL and call setCatalog
> 3. change configureConnection() and execute "use <schema>;" statement 
> See https://issues.apache.org/jira/browse/HIVE-675

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