Mark Bathori created HIVE-25686:
-----------------------------------

             Summary: UDFSpace functionality issue 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
             Fix For: 4.0.0


The changes added in HADOOP-17901 and HADOOP-17905 ** introduced some issues in 
Hive side. UDFSpace is generating false output because the text length is not 
determined correctly. It causing unexpected character 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 --outputformat=csv 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