[ https://issues.apache.org/jira/browse/HIVE-23452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17105975#comment-17105975 ]
De Li edited comment on HIVE-23452 at 5/13/20, 7:02 AM: -------------------------------------------------------- {code:java} // mysql table CREATE EXTERNAL TABLE IF NOT EXISTS test_mysqltable_ex ( id int, name String ) STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES ( "hive.sql.database.type" = "MYSQL", "hive.sql.jdbc.driver" = "com.mysql.jdbc.Driver", "hive.sql.jdbc.url" = "jdbc:mysql://xxx/test_mysql", "hive.sql.dbcp.username" = "xxx", "hive.sql.dbcp.password" = "xxxx", "hive.sql.table" = "test_mysqltable" ); {code} {code:java} // postgresql CREATE EXTERNAL TABLE IF NOT EXISTS gp_test ( id int ) STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES ( "hive.sql.database.type" = "POSTGRES", "hive.sql.jdbc.driver" = "org.postgresql.Driver", "hive.sql.jdbc.url" = "jdbc:postgresql://xxxx:5432/pg", "hive.sql.dbcp.username" = "xxxx", "hive.sql.dbcp.password" = "xxxx", "hive.sql.table" = "test_gp" ); {code} {code:java} // code placeholder SELECT aa.id,bb.name FROM default.gp_test aa left join default.test_mysqltable_ex bb on aa.id=bb.id where bb.id >1; {code} was (Author: lide): {code:java} // mysql table CREATE EXTERNAL TABLE IF NOT EXISTS test_mysqltable_ex ( id int, name String ) STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES ( "hive.sql.database.type" = "MYSQL", "hive.sql.jdbc.driver" = "com.mysql.jdbc.Driver", "hive.sql.jdbc.url" = "jdbc:mysql://xxx/test_mysql", "hive.sql.dbcp.username" = "xxx", "hive.sql.dbcp.password" = "xxxx", "hive.sql.table" = "test_mysqltable" ); {code} {code:java} // postgresql CREATE EXTERNAL TABLE IF NOT EXISTS gp_test ( id int ) STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES ( "hive.sql.database.type" = "POSTGRES", "hive.sql.jdbc.driver" = "org.postgresql.Driver", "hive.sql.jdbc.url" = "jdbc:postgresql://xxxx:5432/cdn", "hive.sql.dbcp.username" = "xxxx", "hive.sql.dbcp.password" = "xxxx", "hive.sql.table" = "test_gp" ); {code} {code:java} // code placeholder SELECT aa.id,bb.name FROM default.gp_test aa left join default.test_mysqltable_ex bb on aa.id=bb.id where bb.id >1; {code} > Exception occur when a SQL query across data stored in two relational DB by > JDBCStorageHandler with Tez > ------------------------------------------------------------------------------------------------------- > > Key: HIVE-23452 > URL: https://issues.apache.org/jira/browse/HIVE-23452 > Project: Hive > Issue Type: Bug > Components: Tez > Affects Versions: 3.1.0 > Reporter: De Li > Priority: Major > > Exception occur when a SQL query across data stored in two relational DB by > JDBCStorageHandler with Tez. It seems there is an incorrect JDBC driver by > Tez and it works when query with MR. -- This message was sent by Atlassian Jira (v8.3.4#803005)