You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Alok Singh <al...@cloudability.com> on 2016/11/20 19:20:20 UTC

Array functions with CASE statement

----TEST CASE----

Environment:Phoenix 4.7/HBase 1.1.2

CREATE TABLE TEST_TABLE (
       NAME VARCHAR(100) NOT NULL PRIMARY KEY,
       C1 VARCHAR(32),
       C2 VARCHAR(32)
    );

SELECT NAME, (CASE WHEN ALL(ARRAY[C1,C2]) = 'A' THEN 1 ELSE 2 END) AS VAL
FROM TEST_TABLE;

SELECT NAME, (CASE WHEN ANY(ARRAY[C1,C2]) = 'A' THEN 1 ELSE 2 END) AS VAL
FROM TEST_TABLE;
------

Both select statements fail with a parse error <<[Error Code: 602, SQL
State: 42P00]  ERROR 602 (42P00): Syntax error. Missing "LPAREN">>

Are ANY/ALL functions not supported within a CASE statement?

Alok