[teiid-issues] [JBoss JIRA] (TEIID-2874) HIVE2: can't get the table list if using other than default database

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12949126#comment-12949126 ] 

Ramesh Reddy commented on TEIID-2874:
-------------------------------------

Looks like Hive driver ignores the setting of database at the end of the URL, and always connects to the "default"

After connection, I tried
{code}
use testing;
show tables
{code}

that worked! I will try to scrape the database name from URL and do the same.
                
> HIVE2:  can't get the table list if using other than default database
> ---------------------------------------------------------------------
>
>                 Key: TEIID-2874
>                 URL: https://issues.jboss.org/browse/TEIID-2874
>             Project: Teiid
>          Issue Type: Bug
>          Components: Connector API
>    Affects Versions: 8.7
>         Environment: Teiid with Hive2
>            Reporter: Ivan Chan
>            Assignee: Ramesh Reddy
>              Labels: teiid
>
> I am not able to retrieve the table list other than default database.
> I have create a database other than default.  And I named it as "Testing".
> And I put the database name in the URL:
> jdbc:hive2://machine_name:port/testing
> And it always returns a list of tables from default database.  Nothing from "Testing" database

--
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