Hi,
I'm trying to migrate some hive scripts to Spark-SQL. However, I
found some statement is incompatible in Spark-sql.
Here is my SQL. And the same SQL works fine in HIVE environment.
SELECT
*if(ad_user_id1000, 1000, ad_user_id) as user_id*
FROM
5:22 PM
*To:* User
*Subject:* IF statement doesn't work in Spark-SQL?
Hi,
I'm trying to migrate some hive scripts to Spark-SQL. However, I
found some statement is incompatible in Spark-sql.
Here is my SQL. And the same SQL works fine in HIVE environment.
SELECT
at 5:59 PM, Wang, Daoyuan daoyuan.w...@intel.com
wrote:
Hi Xuelin,
What version of Spark are you using?
Thanks,
Daoyuan
*From:* Xuelin Cao [mailto:xuelincao2...@gmail.com]
*Sent:* Tuesday, January 20, 2015 5:22 PM
*To:* User
*Subject:* IF statement doesn't work in Spark-SQL
*Subject:* IF statement doesn't work in Spark-SQL?
Hi,
I'm trying to migrate some hive scripts to Spark-SQL. However, I
found some statement is incompatible in Spark-sql.
Here is my SQL. And the same SQL works fine in HIVE environment.
SELECT
*if(ad_user_id1000
Hi Xuelin,
What version of Spark are you using?
Thanks,
Daoyuan
From: Xuelin Cao [mailto:xuelincao2...@gmail.com]
Sent: Tuesday, January 20, 2015 5:22 PM
To: User
Subject: IF statement doesn't work in Spark-SQL?
Hi,
I'm trying to migrate some hive scripts to Spark-SQL. However, I found
:* IF statement doesn't work in Spark-SQL?
Hi,
I'm trying to migrate some hive scripts to Spark-SQL. However, I
found some statement is incompatible in Spark-sql.
Here is my SQL. And the same SQL works fine in HIVE environment.
SELECT
*if(ad_user_id1000, 1000
,
Daoyuan
*From:* Xuelin Cao [mailto:xuelincao2...@gmail.com]
*Sent:* Tuesday, January 20, 2015 5:22 PM
*To:* User
*Subject:* IF statement doesn't work in Spark-SQL?
Hi,
I'm trying to migrate some hive scripts to Spark-SQL. However, I
found some statement is incompatible in Spark
|IF| is implemented as a generic UDF in Hive (|GenericUDFIf|). It seems
that this function can’t be properly resolved. Could you provide a
minimum code snippet that reproduces this issue?
Cheng
On 1/20/15 1:22 AM, Xuelin Cao wrote:
Hi,
I'm trying to migrate some hive scripts to