[
https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
De Li updated HIVE-23452:
-
Description: Exception occur when a SQL query across data stored in two
relational DB by JDBCStorageHandler with
[
https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17105973#comment-17105973
]
De Li commented on HIVE-23452:
--
{code:java}
// code placeholder
2020-05-13 11:17:40,522 [ERROR]
[
https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17105975#comment-17105975
]
De Li edited comment on HIVE-23452 at 5/13/20, 7:02 AM:
{code:java}
// mysql
[
https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106026#comment-17106026
]
De Li commented on HIVE-23452:
--
Yes, table 'test_mysql.test_gp' doesn't exist because it is a wrong
[
https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17105975#comment-17105975
]
De Li commented on HIVE-23452:
--
{code:java}
// code placeholder
CREATE EXTERNAL TABLE IF NOT EXISTS
[
https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106028#comment-17106028
]
De Li commented on HIVE-23452:
--
Both the table 'pg.test_gp' and 'test_mysql.test_mysqltable' are exist.
>
[
https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17105975#comment-17105975
]
De Li edited comment on HIVE-23452 at 5/13/20, 6:50 AM:
{code:java}
// code
[
https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17105975#comment-17105975
]
De Li edited comment on HIVE-23452 at 5/13/20, 6:58 AM:
{code:java}
// mysql
[
https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17138970#comment-17138970
]
De Li commented on HIVE-23452:
--
It seems resolved by Hive-20652 but still need to further test.
> Exception