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

Stamatis Zampetakis commented on HIVE-25686:
--------------------------------------------

[~mbathori]  If I understand well this change will have an impact on Hive only 
after the upgrade of hadoop.version to 3.4.0. Currently we are using 3.1.0 so 
is it correct to assume that the problem does not appear at the current master?

> UDFSpace result length calculation is incorrect after HADOOP-17901 and 
> HADOOP-17905
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-25686
>                 URL: https://issues.apache.org/jira/browse/HIVE-25686
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>            Reporter: Mark Bathori
>            Assignee: Mark Bathori
>            Priority: Critical
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> The changes added in HADOOP-17901 and HADOOP-17905 introduced some issues in 
> Hive side. UDFSpace is generating false output because the result length is 
> not determined correctly. It is causing unexpected characters in the result.
> *Repro steps:*
> {code:java}
> create table t(i int);{code}
> {code:java}
> insert into t values (5),(6),(7),(8),(9),(10),(11),(12),(13),(14);{code}
> {code:java}
> select i, SPACE(i) from t;{code}
>  
> Faulty output:
> {code:java}
> +-----+-----------------+
> |  i  |       _c1       |
> +-----+-----------------+
> | 5   |                 |
> | 6   |                 |
> | 7   |                |
> | 8   |                 |
> | 9   |                |
> | 10  |               |
> | 11  |                 |
> | 12  |                |
> | 13  |               |
> | 14  |              |
> +-----+-----------------+
> {code}
>  
> Also by using {color:#ff0000}--outputformat=csv{color} the generated file 
> contains 0 ascii characters(“EOF”) instead of spaces.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to