----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