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

Reply via email to