Hi Vertica Experts,
Is the following a bug? Is there a workaround for it?
STEP1
create file called a.csv in tmp folder with the following 3 lines:
c1,c2
2.8121163E8,1
200,2
STEP2
CREATE TABLE t1(c1 NUMERIC(18,2), c2 INT);
STEP 3
COPY t1 FROM '/tmp/a.csv' parser FDELIMITEDPARSER() DELIMITER ',' ABORT ON ERROR;
STEP 4
select * from t1;
vertica=> select * from t1;
c1 | c2
--------+----
| 1
200.00 | 2
(2 rows)
The above works if I use float instead of NUMERIC(18,2)