[JBoss JIRA] (TEIID-2874) HIVE2: can't get the table list if using other than default database
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIID-2874?page=com.atlassian.jira.plugin... ]
Ivan Chan commented on TEIID-2874:
----------------------------------
Got it. Thanks for looking into it. =)
> 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
10 years, 8 months
[JBoss JIRA] (TEIID-2874) HIVE2: can't get the table list if using other than default database
by Ramesh Reddy (JIRA)
[ 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
10 years, 8 months
[JBoss JIRA] (TEIID-2874) HIVE2: can't get the table list if using other than default database
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIID-2874?page=com.atlassian.jira.plugin... ]
Ivan Chan commented on TEIID-2874:
----------------------------------
Is it possible to make this fix more generic? Stick with the database name with url approach?
> 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
10 years, 8 months
[JBoss JIRA] (TEIID-2874) HIVE2: can't get the table list if using other than default database
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2874?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2874:
-------------------------------------
If Tomcat has similar functionality in their connection pool then it will work 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: 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
10 years, 8 months
[JBoss JIRA] (TEIID-2874) HIVE2: can't get the table list if using other than default database
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIID-2874?page=com.atlassian.jira.plugin... ]
Ivan Chan commented on TEIID-2874:
----------------------------------
Will this fix work with JNDI connection from other application server, too? (Like Tomcat) Because I am using the embedded version.
> 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
10 years, 8 months
[JBoss JIRA] (TEIID-2874) HIVE2: can't get the table list if using other than default database
by Ramesh Reddy (JIRA)
[ 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
10 years, 8 months