hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mohammad Kamrul Islam (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5221) Issue in colun type with data type as BINARY
Date Mon, 23 Sep 2013 06:24:02 GMT

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

Mohammad Kamrul Islam commented on HIVE-5221:
---------------------------------------------

ok. I will update the patch.
                
> Issue in colun type with data type as BINARY
> --------------------------------------------
>
>                 Key: HIVE-5221
>                 URL: https://issues.apache.org/jira/browse/HIVE-5221
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Arun Vasu
>            Assignee: Mohammad Kamrul Islam
>            Priority: Critical
>         Attachments: HIVE-5221.1.patch
>
>
> Hi,
> I am using Hive 10. When I create an external table with column type as Binary, the query
result on the table is showing some junk values for the column with binary datatype.
> Please find below the query I have used to create the table:
> CREATE EXTERNAL TABLE BOOL1(NB BOOLEAN,email STRING, bitfld BINARY)
>  ROW FORMAT DELIMITED
>    FIELDS TERMINATED BY '^'
>    LINES TERMINATED BY '\n'
> STORED AS TEXTFILE
> LOCATION '/user/hivetables/testbinary';
> The query I have used is : select * from bool1
> The sample data in the hdfs file is:
> 0^arun@abc.com^001
> 1^arun@abc.com^010
>  ^arun@abc.com^011
>  ^arun@abc.com^100
> t^arun@abc.com^101
> f^arun@abc.com^110
> true^arun@abc.com^111
> false^arun@abc.com^001
> 123^    ^01100010
> 12344^    ^01100001
> Please share your inputs if it is possible.
> Thanks,
> Arun

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message