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