Hi,

I tried the following examples regarding to array data type


create table artest(a integer , b integer[], constraint pk primary key(a));


upsert into artest values(1, array[1,2]);


The following statement failed :


select a, ARRAY_APPEND(b, 4) as b from artest; 


Error: ERROR 605 (42P00): Syntax error. Unknown function: "ARRAY_APPEND".
SQLState:  42P00
ErrorCode: 605





upsert into artest( b) values ( array_append(b, 1) ) where a = 1;


Error: ERROR 605 (42P00): Syntax error. Unknown function: "ARRAY_APPEND".
SQLState:  42P00
ErrorCode: 605







My phoniex version is 4.4.0 for Hbase 0.98.

Reply via email to