IF statement doesn't work in Spark-SQL?

[Xuelin Cao]

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_id>1000, 1000, ad_user_id) as user_id*
    FROM
      ad_search_keywords

     What I found is, the parser reports error on the "*if*" statement:

No function to evaluate expression. type: AttributeReference, tree:
ad_user_id#4


     Anyone have any idea about this?