[jira] [Created] (HIVE-17746) Regenerate spark_explainuser_1.q.out

["Peter Vary (JIRA)" <ji...@apache.org>]

Peter Vary created HIVE-17746:
---------------------------------

             Summary: Regenerate spark_explainuser_1.q.out
                 Key: HIVE-17746
                 URL: https://issues.apache.org/jira/browse/HIVE-17746
             Project: Hive
          Issue Type: Bug
          Components: Test
    Affects Versions: 3.0.0
            Reporter: Peter Vary
            Assignee: Peter Vary


There is 2 changes in  spark_explainuser_1.q.out:
1., After HIVE-17465, the row numbers are different in the explain plans. [~vgarg], [~ashutoshc]: Could you please check, wether it is an intended change?
2., After HIVE-17535, CBO optimization turned on and the output of the following query changed:
{code:title=Query}
explain select explode(array('a', 'b'));
{code}
{code:title=Original}
 POSTHOOK: query: explain select explode(array('a', 'b'))
 POSTHOOK: type: QUERY
 Plan not optimized by CBO.
 
 Stage-0
   Fetch Operator
     limit:-1
    UDTF Operator [UDTF_2]
      function name:explode
      Select Operator [SEL_1]
        Output:["_col0"]
        TableScan [TS_0]
{code}
{code:title=New}
 POSTHOOK: query: explain select explode(array('a', 'b'))
 POSTHOOK: type: QUERY
 Plan optimized by CBO.
 
 Stage-0
   Fetch Operator
     limit:-1
    Select Operator [SEL_3]
      Output:["_col0"]
      UDTF Operator [UDTF_2]
        function name:explode
        Select Operator [SEL_1]
          Output:["_col0"]
          TableScan [TS_0]
{code}

This 2nd change does not look like a successful optimization for me. Is it planned :)
If you think these are planned changes, then I think it would be good to update the golden file.

Thanks,
Peter



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)