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