liyunzhang_intel created HIVE-17412:
---------------------------------------

             Summary: Add "-- SORT_QUERY_RESULTS" for 
spark_vectorized_dynamic_partition_pruning.q
                 Key: HIVE-17412
                 URL: https://issues.apache.org/jira/browse/HIVE-17412
             Project: Hive
          Issue Type: Bug
            Reporter: liyunzhang_intel
            Assignee: liyunzhang_intel


for query
{code}
 set hive.optimize.ppd=true;
set hive.ppd.remove.duplicatefilters=true;
set hive.spark.dynamic.partition.pruning=true;
set hive.optimize.metadataonly=false;
set hive.optimize.index.filter=true;
set hive.vectorized.execution.enabled=true;
set hive.strict.checks.cartesian.product=false;
select distinct ds from srcpart;
{code}

the result is 
{code}
2008-04-09
2008-04-08
{code}
the result of groupby in spark is not in order. Sometimes it returns 
{code}
2008-04-08
2008-04-09
{code}
Sometimes it returns
{code}
2008-04-09
2008-04-08
{code}




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

Reply via email to