hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (Jira)" <j...@apache.org>
Subject [jira] [Work logged] (HIVE-22777) Sorted dynamic partition optimization doesn't work if plan require implicit cast
Date Sat, 06 Jun 2020 00:26:01 GMT

     [ https://issues.apache.org/jira/browse/HIVE-22777?focusedWorklogId=442125&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-442125
]

ASF GitHub Bot logged work on HIVE-22777:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 06/Jun/20 00:25
            Start Date: 06/Jun/20 00:25
    Worklog Time Spent: 10m 
      Work Description: github-actions[bot] closed pull request #892:
URL: https://github.com/apache/hive/pull/892


   


----------------------------------------------------------------
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: 442125)
    Time Spent: 20m  (was: 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
>             Fix For: 4.0.0
>
>         Attachments: HIVE-22777.1.patch, HIVE-22777.2.patch, HIVE-22777.3.patch, HIVE-22777.4.patch,
HIVE-22777.5.patch
>
>          Time Spent: 20m
>  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)

Mime
View raw message