[
https://issues.apache.org/jira/browse/HIVE-23882?focusedWorklogId=554376&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-554376
]
ASF GitHub Bot logged work on HIVE-23882:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 18/Feb/21 18:12
Start Date: 18/Feb/21 18:12
Worklog Time Spent: 10m
Work Description: pgaref commented on a change in pull request #1286:
URL: https://github.com/apache/hive/pull/1286#discussion_r578641665
##########
File path: ql/src/test/results/clientpositive/llap/auto_join10.q.out
##########
@@ -57,6 +57,7 @@ STAGE PLANS:
TableScan
alias: src
filterExpr: key is not null (type: boolean)
+ probeDecodeDetails: cacheKey:HASH_MAP_MAPJOIN_30_container,
bigKeyColName:key, smallTablePos:0, keyRatio:1.582
Review comment:
In general thats the case, this particular query though is a self join
where tsKeyCardinality is 500 while mjKeyCardinality is 791 thus the ratio is
above 1.
----------------------------------------------------------------
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:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 554376)
Time Spent: 3h 10m (was: 3h)
> Compiler should skip MJ keyExpr for probe optimization
> ------------------------------------------------------
>
> Key: HIVE-23882
> URL: https://issues.apache.org/jira/browse/HIVE-23882
> Project: Hive
> Issue Type: Sub-task
> Reporter: Panagiotis Garefalakis
> Assignee: Panagiotis Garefalakis
> Priority: Major
> Labels: pull-request-available
> Time Spent: 3h 10m
> Remaining Estimate: 0h
>
> In probe we cannot currently support Key expressions (on the big table Side)
> as ORC CVs Probe directly the smalltable HT (there is no expr evaluation at
> that level).
> TezCompiler should take this into account when picking MJs to push probe
> details
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
