You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Chesnay Schepler (JIRA)" <ji...@apache.org> on 2016/02/23 12:34:18 UTC

[jira] [Commented] (FLINK-3471) JDBCInputFormat cannot handle null fields of certain types

    [ https://issues.apache.org/jira/browse/FLINK-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15158750#comment-15158750 ] 

Chesnay Schepler commented on FLINK-3471:
-----------------------------------------

This is expected behaviour. The JDBCInputForTat uses Tuples, which don't allow null values to occur.

The Table API may allow you to do this, among other things (like labeling columns i believe).

> JDBCInputFormat cannot handle null fields of certain types
> ----------------------------------------------------------
>
>                 Key: FLINK-3471
>                 URL: https://issues.apache.org/jira/browse/FLINK-3471
>             Project: Flink
>          Issue Type: Bug
>    Affects Versions: 0.10.2
>            Reporter: Ken Geis
>
> JDBCInputFormat.addValue(..) is not safe against NULL values for types DECIMAL, NUMERIC, DATE, TIME, TIMESTAMP, and SQLXML. This makes it so that I cannot input data using any queries that will result in NULL values for any of these types.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)