Hi,
Im trying to upsert some records to my phoenix table but i'm getting the
following error:
Error: ERROR 203 (22005): Type mismatch. FLOAT and BIGINT for -1
It seems that only the value "-1.00" as float is causing this problem.
Please check the example sql below:
CREATE TABLE test (
id VARCHAR not null primary key,
name VARCHAR,
lat FLOAT
);
UPSERT INTO test(id,name,lat) VALUES ('testid', 'testname', -1.00);
adding rows with values -2.00 or 3.00 is working without problems. Does
anybody knows why? Is the sign bit causing this error, and therefore I
found a bug?
Phoenix version: 4.3.0
Hbase version: 0.98.10.1
Thanks in advice,
Ron