[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 commented on TEIID-2874:
-------------------------------------
The issue is not specific to metadata retrieval, it is also affects all the queries issued
on it. That means, Teiid would need to execute "use database" statement before
each and every statement execution as it does not know if it is getting a new connection
vs a pooled connection. This can add to query performance. This is just a workaround. The
real bug need to be logged through Hive to fix this error.
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: Beta2, teiid
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