Hi all I keep banging my head against the wall and kind of out of ideas at this point so I hope someone can give me little helping hand. It safe to say that I am using almost 4.3 (build just before it released)
Here is what I having problem with CREATE TABLE IF NOT EXISTS dev.t1 ( f_int UNSIGNED_INT NOT NULL, f_long UNSIGNED_LONG NOT NULL, f_array UNSIGNED_LONG ARRAY[] NOT NULL, CONSTRAINT pk PRIMARY KEY (f_int, f_long, f_array) ); upsert into dev.t1 (f_int,f_long,f_array) values(1,1,ARRAY[1,2]); and getting Error: ERROR 203 (22005): Type mismatch. INTEGER ARRAY and UNSIGNED_LONG ARRAY for expression: org.apache.phoenix.schema.types.PhoenixArray$PrimitiveIntPhoenixArray@d32d5 in column F_ARRAY (state=22005,code=203) I tried ARRAY[2] and having same problem !describe dev.t1; +-------------------+--------------------+--------------------+---------------------+---------+ | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | | +-------------------+--------------------+--------------------+---------------------+---------+ | null | DEV | T1 | F_INT | 4 | | null | DEV | T1 | F_LONG | -5 | | null | DEV | T1 | F_ARRAY | 2003 | +-------------------+--------------------+--------------------+---------------------+---------+ Any idea what I am doing wrong ? Thank you S