hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiaobing Zhou (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-8115) Hive select query hang when fields contain map
Date Tue, 16 Sep 2014 01:24:34 GMT

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

Mime
View raw message