[jira] [Created] (HIVE-13372) Hive Macro overwritten when multiple macros are used in one column

["Lin Liu (JIRA)" <ji...@apache.org>]

Lin Liu created HIVE-13372:
------------------------------

             Summary: Hive Macro overwritten when multiple macros are used in one column
                 Key: HIVE-13372
                 URL: https://issues.apache.org/jira/browse/HIVE-13372
             Project: Hive
          Issue Type: Bug
          Components: Hive
    Affects Versions: 1.2.1
            Reporter: Lin Liu
            Priority: Critical


When multiple macros are used in one column, results of the later ones are over written by that of the first.

For example:
Suppose we have created a table called macro_test with single column x in STRING type, and with data as:
"a"
"bb"
"ccc"

We also create three macros:
CREATE TEMPORARY MACRO STRING_LEN(x string) length(x);
CREATE TEMPORARY MACRO STRING_LEN_PLUS_ONE(x string) length(x)+1;
CREATE TEMPORARY MACRO STRING_LEN_PLUS_TWO(x string) length(x)+2;

When we ran the following query, 
SELECT
    CONCAT(STRING_LEN(x), ":", STRING_LEN_PLUS_ONE(x), ":", STRING_LEN_PLUS_TWO(x)) a
FROM macro_test
SORT BY a DESC;

We get result:
3:3:3
2:2:2
1:1:1

instead of expected:
3:4:5
2:3:4
1:2:3



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