[ https://issues.apache.org/jira/browse/SPARK-19472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-19472: ------------------------------------ Assignee: (was: Apache Spark) > [SQL]SQLParser fails to resolve nested CASE WHEN statement with parentheses > --------------------------------------------------------------------------- > > Key: SPARK-19472 > URL: https://issues.apache.org/jira/browse/SPARK-19472 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.1.0 > Reporter: StanZhai > > SQLParser fails to resolve nested CASE WHEN statement like this: > select case when > (1) + > case when 1>0 then 1 else 0 end = 2 > then 1 else 0 end > from tb > ==================== Exception ==================== > Exception in thread "main" > org.apache.spark.sql.catalyst.parser.ParseException: > mismatched input 'then' expecting {'.', '[', 'OR', 'AND', 'IN', NOT, > 'BETWEEN', 'LIKE', RLIKE, 'IS', 'WHEN', EQ, '<=>', '<>', '!=', '<', LTE, '>', > GTE, '+', '-', '*', '/', '%', 'DIV', '&', '|', '^'}(line 5, pos 0) > == SQL == > select case when > (1) + > case when 1>0 then 1 else 0 end = 2 > then 1 else 0 end > ^^^ > from tb > But,remove parentheses will be fine: > select case when > 1 + > case when 1>0 then 1 else 0 end = 2 > then 1 else 0 end > from tb -- This message was sent by Atlassian JIRA (v6.3.15#6346) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org