[teiid-issues] [JBoss JIRA] (TEIID-2874) HIVE2: can't get the table list if using other than default database
[
https://issues.jboss.org/browse/TEIID-2874?page=com.atlassian.jira.plugin...
]
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