[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:all-tabpanel ]

Ramesh Reddy resolved TEIID-2874.
---------------------------------

           Labels: Beta2 teiid  (was: teiid)
    Fix Version/s: 8.7
       Resolution: Done


Actually even simpler thing is set this on the data source definition
{code}
        <datasource jndi-name="java:/hive-ds" pool-name="hive-ds">
            <connection-url>jdbc:hive2://{host-name}:10000/{database-name}</connection-url>
            <driver>hive</driver>
            <pool>
                <prefill>false</prefill>
                <use-strict-min>false</use-strict-min>
                <flush-strategy>FailingConnectionOnly</flush-strategy>
            </pool>
            <security>
                <user-name>{user}</user-name>
                <password>{password}</password>
            </security>
            <new-connection-sql>use {database-name}</new-connection-sql>
        </datasource>  
{code}
see 
{code}
 <new-connection-sql>use {database-name}</new-connection-sql>
{code}

then we are sure this set on each and every connection supplied to the Hive translator.

I will also make a note in the documentation.
                
> 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, Beta2
>             Fix For: 8.7
>
>
> 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