flink-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Flavio Pompermaier <pomperma...@okkam.it>
Subject JDBC error on numeric conversion (because of DecimalType MIN_PRECISION)
Date Fri, 24 Apr 2020 14:28:43 GMT
Hi to all,
I was doing a test against Postgres and I get an error because the jdbc
connect tries to create a DecimalType with precision 0 (min = 1).
Should this DecimalType.MIN_PRECISION lowered to 0 or should NUMERIC type
of jdbc tables mapped in some other way?

The Table was created with the following statement (the test fails on
creating ord_qty filed):

CREATE TABLE orders(
    ord_no integer PRIMARY KEY,
    ord_date date,
    item_name character(35),
    item_grade character(1),
    ord_qty numeric,
    ord_amount numeric,
    CONSTRAINT unq_ordno_itname UNIQUE(ord_qty,ord_amount)
);

Best,
Flavio
-- 
Flavio Pompermaier
Development Department

OKKAM S.r.l.
Tel. +(39) 0461 041809

Mime
View raw message