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

Xiaobing Zhou commented on HIVE-8115:
-------------------------------------

wedcsProperties column starts with [SOH][ETX][STX], where SOH is start of 
heading with value '\001' in terms of OCT, ETX is end of text with end of text 
with value '\003' , and STX is start of text with value '\002'. [STX][ETX] is 
the format good for map's key/value pair representation. 

In the data file, [STX][ETX] means empty map pair, this will make query hanging 
forever by complaining nothing.

Of course '[' and ']' don't exist, only for notation purpose in the comment. Be 
sure to use Notepad++ to view these special chars.

> Hive select query hang when fields contain map
> ----------------------------------------------
>
>                 Key: HIVE-8115
>                 URL: https://issues.apache.org/jira/browse/HIVE-8115
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.13.0
>            Reporter: Xiaobing Zhou
>            Assignee: Xiaobing Zhou
>             Fix For: 0.14.0
>
>         Attachments: createTable.hql, data
>
>
> Attached the repro of the issue. When creating an table loading the data 
> attached, all hive query with hangs even just select * from the table.
> repro steps:
> 1. run createTable.hql
> 2. hadoop fs ls -put data /data
> 3. LOAD DATA INPATH '/data' OVERWRITE INTO TABLE testtable;
> 4. SELECT * FROM testtable;



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

Reply via email to