[jira] [Comment Edited] (HIVE-8848) data loading from text files or text file processing doesn't handle nulls correctly

["Edward Capriolo (JIRA)" <ji...@apache.org>]

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

Edward Capriolo edited comment on HIVE-8848 at 11/20/14 2:27 AM:
-----------------------------------------------------------------

You can re-submit and merge if I am wrong but in TextInputFormats null is '\N' I think this is defined in LazySimpleSerde


was (Author: appodictic):
You can re-open if I am wrong but in TextInputFormats null is '\N' I think this is defined in LazySimpleSerde

> data loading from text files or text file processing doesn't handle nulls correctly
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-8848
>                 URL: https://issues.apache.org/jira/browse/HIVE-8848
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Sergey Shelukhin
>            Assignee: Sergey Shelukhin
>         Attachments: HIVE-8848.patch
>
>
> I am not sure how nulls are supposed to be stored in text tables, but after loading some data with "null" or "NULL" strings, or x00 characters, we get bunch of annoying logging from LazyPrimitive that data is not in INT format and was converted to null, with data being "null" (string saying "null", I assume from the code).
> Either load should load them as nulls, or there should be some defined way to load nulls.



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