[ https://issues.apache.org/jira/browse/HIVE-22706?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17012727#comment-17012727 ]
Zoltan Haindrich commented on HIVE-22706: ----------------------------------------- well; after some digging my hypothesis have confirmed; that datanucleus is pulling these Y/N into play...the translation is done at several places including [this|https://github.com/datanucleus/datanucleus-rdbms/blob/6f01a33e7d514f90775ddd7d3d7bfe77303e787b/src/main/java/org/datanucleus/store/rdbms/mapping/datastore/CharRDBMSMapping.java#L332]. I played with the idea to try to reuse the parts which are doing this kind of conversions ; but they are kinda deeply tied to a plugin system inside datanucleus and it would look strange.... So I think the best course of action ; to have our sysdb show rational values is to interpret the char 'N' as false... > Jdbc storage handler incorrectly interprets boolean column value in derby > ------------------------------------------------------------------------- > > Key: HIVE-22706 > URL: https://issues.apache.org/jira/browse/HIVE-22706 > Project: Hive > Issue Type: Bug > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Priority: Major > > in case the column value is false ; the storage handler interprets it as true -- This message was sent by Atlassian Jira (v8.3.4#803005)