hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <>
Subject [jira] [Work logged] (HIVE-21867) Sort semijoin conditions to accelerate query processing
Date Tue, 25 Jun 2019 21:29:00 GMT


ASF GitHub Bot logged work on HIVE-21867:

                Author: ASF GitHub Bot
            Created on: 25/Jun/19 21:28
            Start Date: 25/Jun/19 21:28
    Worklog Time Spent: 10m 
      Work Description: vineetgarg02 commented on pull request #687: HIVE-21867

 File path: ql/src/test/results/clientpositive/llap/mergejoin.q.out
 @@ -41,8 +41,8 @@ STAGE PLANS:
                     Filter Vectorization:
                         className: VectorFilterOperator
                         native: true
-                        predicateExpression: FilterExprAndExpr(children: SelectColumnIsNotNull(col
0:string), FilterExprAndExpr(children: FilterStringColumnBetweenDynamicValue(col 0:string,
left NULL, right NULL), VectorInBloomFilterColDynamicValue))
-                    predicate: (key is not null and (key BETWEEN DynamicValue(RS_7_b_key_min)
AND DynamicValue(RS_7_b_key_max) and in_bloom_filter(key, DynamicValue(RS_7_b_key_bloom_filter))))
(type: boolean)
 Review comment:
   Positive change :thumbsup:
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:

Issue Time Tracking

    Worklog Id:     (was: 267051)
    Time Spent: 0.5h  (was: 20m)

> Sort semijoin conditions to accelerate query processing
> -------------------------------------------------------
>                 Key: HIVE-21867
>                 URL:
>             Project: Hive
>          Issue Type: New Feature
>          Components: Physical Optimizer
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>              Labels: pull-request-available
>         Attachments: HIVE-21867.02.patch, HIVE-21867.03.patch, HIVE-21867.patch
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
> The problem was tackled for CBO in HIVE-21857. Semijoin filters are introduced later
in the planning phase. Follow similar approach to sort them, trying to accelerate filter evaluation.

This message was sent by Atlassian JIRA

View raw message