spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ajay (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SPARK-4869) The variable names in IF statement of Spark SQL doesn't resolve to its value.
Date Wed, 17 Dec 2014 03:28:13 GMT

     [ https://issues.apache.org/jira/browse/SPARK-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ajay updated SPARK-4869:
------------------------
    Summary: The variable names in IF statement of Spark SQL doesn't resolve to its value.
  (was: The variable names in IF statement of SQL doesn't resolve to its value. )

> The variable names in IF statement of Spark SQL doesn't resolve to its value. 
> ------------------------------------------------------------------------------
>
>                 Key: SPARK-4869
>                 URL: https://issues.apache.org/jira/browse/SPARK-4869
>             Project: Spark
>          Issue Type: Bug
>          Components: Spark Core
>    Affects Versions: 1.1.1
>            Reporter: Ajay
>            Priority: Blocker
>
> We got stuck with “IF-THEN” statement in Spark SQL. As per our usecase, we have to
have nested “if” statements. But, spark sql is not able to resolve the variable names
in final evaluation but the literal values are working. Please fix this bug. 
> This works:
> sqlSC.sql("SELECT DISTINCT UNIT, PAST_DUE ,IF( PAST_DUE = 'CURRENT_MONTH', 0,1) as ROLL_BACKWARD
FROM OUTER_RDD")
> This doesn’t :
> sqlSC.sql("SELECT DISTINCT UNIT, PAST_DUE ,IF( PAST_DUE = 'CURRENT_MONTH', 0,DAYS_30)
as ROLL_BACKWARD FROM OUTER_RDD")



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message