You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2020/01/31 20:42:00 UTC
[jira] [Work logged] (HIVE-22777) Sorted dynamic partition
optimization doesn't work if plan require implicit cast
[ https://issues.apache.org/jira/browse/HIVE-22777?focusedWorklogId=380200&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-380200 ]
ASF GitHub Bot logged work on HIVE-22777:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 31/Jan/20 20:41
Start Date: 31/Jan/20 20:41
Worklog Time Spent: 10m
Work Description: vineetgarg02 commented on pull request #892: HIVE-22777: Sorted dynamic partition optimization doesn't work if pla…
URL: https://github.com/apache/hive/pull/892
…n require implicit cast
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 380200)
Remaining Estimate: 0h
Time Spent: 10m
> Sorted dynamic partition optimization doesn't work if plan require implicit cast
> --------------------------------------------------------------------------------
>
> Key: HIVE-22777
> URL: https://issues.apache.org/jira/browse/HIVE-22777
> Project: Hive
> Issue Type: Bug
> Components: Query Planning
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
> Labels: pull-request-available
> Attachments: HIVE-22777.1.patch, HIVE-22777.2.patch, HIVE-22777.3.patch, HIVE-22777.4.patch, HIVE-22777.5.patch
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> *Repro*
> set hive.stats.autogather=false;
> set hive.optimize.sort.dynamic.partition.threshold=1;
> set hive.optimize.bucketingsorting = true;
> {code:sql}
> drop table if exists t1_staging;
> create table t1_staging(
> a string,
> b int,
> c int,
> d string)
> partitioned by (e decimal(18,0))
> clustered by(a)
> into 256 buckets STORED AS TEXTFILE;
> load data local inpath '../../data/files/sortdp/000000_0' overwrite into table t1_staging partition (e=100);
> drop table t1_n147;
> create table t1_n147(
> a string,
> b decimal(6,0),
> c int,
> d string)
> partitioned by (e decimal(3,0))
> clustered by(a,b)
> into 10 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true');
> set hive.stats.autogather=false;
> set hive.optimize.bucketingsorting = true;
> explain insert overwrite table t1_n147 partition(e) select a,b,c,d,e from t1_staging;
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)