[ 
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)

Reply via email to