Member since
10-22-2018
1
Post
1
Kudos Received
0
Solutions
10-22-2018
08:58 PM
1 Kudo
I want to get subquery from impala table as one dataset. Code like this: String subQuery = "(select to_timestamp(unix_timestamp(now())) as ts from my_table) t"
Dataset<Row> ds = spark.read().jdbc(myImpalaUrl, subQuery, prop); But result is error: Caused by: java.sql.SQLDataException: [Cloudera][JDBC](10140) Error converting value to Timestamp. to_timestmap() function failed ,but unix_timestmap() , now() work fine. ps. I found another problem, when I use hive udf in the "jdbc" api still failed. Can anyone help me?
... View more
Labels:
- Labels:
-
Apache Impala
-
Apache Spark