daile created SPARK-31457:
-----------------------------
Summary: spark jdbc read hive created the wrong PreparedStatement
Key: SPARK-31457
URL: https://issues.apache.org/jira/browse/SPARK-31457
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 2.3.2, 3.1.0
Environment: spark 2.3.2
hive 2.1.1
Reporter: daile
{code:java}
val res = spark
.read
.format("jdbc")
.option("url", "jdbc:hive2://host:10000/default")
.option("dbtable", "user_info2")
.option("driver","org.apache.hive.jdbc.HiveDriver")
.option("user", "")
.option("password","")
.load()
res.show(){code}
get wrong result
+--------------+--------------+-------------------+
|user_info2.age|user_info2.sex|user_info2.birthday|
+--------------+--------------+-------------------+
|user_info2.age|user_info2.sex|user_info2.birthday|
|user_info2.age|user_info2.sex|user_info2.birthday|
|user_info2.age|user_info2.sex|user_info2.birthday|
|user_info2.age|user_info2.sex|user_info2.birthday|
|user_info2.age|user_info2.sex|user_info2.birthday|
|user_info2.age|user_info2.sex|user_info2.birthday|
|user_info2.age|user_info2.sex|user_info2.birthday|
|user_info2.age|user_info2.sex|user_info2.birthday|
|user_info2.age|user_info2.sex|user_info2.birthday|
|user_info2.age|user_info2.sex|user_info2.birthday|
+--------------+--------------+-------------------+
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]