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]

Reply via email to