[
https://issues.apache.org/jira/browse/HIVE-23849?focusedWorklogId=462025&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-462025
]
ASF GitHub Bot logged work on HIVE-23849:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 22/Jul/20 12:18
Start Date: 22/Jul/20 12:18
Worklog Time Spent: 10m
Work Description: bmaidics commented on a change in pull request #1263:
URL: https://github.com/apache/hive/pull/1263#discussion_r458748457
##########
File path: ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
##########
@@ -12566,38 +12565,44 @@ void analyzeInternal(ASTNode ast,
Supplier<PlannerContext> pcf) throws SemanticE
createVwDesc.setTablesUsed(getTablesUsed(pCtx));
}
- // 6. Generate table access stats if required
- if (HiveConf.getBoolVar(this.conf,
HiveConf.ConfVars.HIVE_STATS_COLLECT_TABLEKEYS)) {
- TableAccessAnalyzer tableAccessAnalyzer = new TableAccessAnalyzer(pCtx);
- setTableAccessInfo(tableAccessAnalyzer.analyzeTableAccess());
- }
+ //If we're creating views and ColumnAccessInfo is already created, we
should not run these.
+ if(!forViewCreation || getColumnAccessInfo() == null) {
+ // 6. Generate table access stats if required
+ if (HiveConf.getBoolVar(this.conf,
HiveConf.ConfVars.HIVE_STATS_COLLECT_TABLEKEYS)) {
+ TableAccessAnalyzer tableAccessAnalyzer = new
TableAccessAnalyzer(pCtx);
+ setTableAccessInfo(tableAccessAnalyzer.analyzeTableAccess());
+ }
+ AuxOpTreeSignature.linkAuxSignatures(pCtx);
+ // 7. Perform Logical optimization
+ if (LOG.isDebugEnabled()) {
+ LOG.debug("Before logical optimization\n" +
Operator.toString(pCtx.getTopOps().values()));
+ }
+ Optimizer optm = new Optimizer();
+ optm.setPctx(pCtx);
+ optm.initialize(conf);
+ pCtx = optm.optimize();
+ if (pCtx.getColumnAccessInfo() != null) {
+ // set ColumnAccessInfo for view column authorization
+ setColumnAccessInfo(pCtx.getColumnAccessInfo());
+ }
+ if (LOG.isDebugEnabled()) {
+ LOG.debug("After logical optimization\n" +
Operator.toString(pCtx.getTopOps().values()));
+ }
- AuxOpTreeSignature.linkAuxSignatures(pCtx);
- // 7. Perform Logical optimization
- if (LOG.isDebugEnabled()) {
- LOG.debug("Before logical optimization\n" +
Operator.toString(pCtx.getTopOps().values()));
- }
- Optimizer optm = new Optimizer();
- optm.setPctx(pCtx);
- optm.initialize(conf);
- pCtx = optm.optimize();
- if (pCtx.getColumnAccessInfo() != null) {
- // set ColumnAccessInfo for view column authorization
- setColumnAccessInfo(pCtx.getColumnAccessInfo());
+ // 8. Generate column access stats if required - wait until column
pruning
Review comment:
Thanks, @jcamachor . Added a more specific comment.
----------------------------------------------------------------
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:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 462025)
Time Spent: 2h 10m (was: 2h)
> Hive skips the creation of ColumnAccessInfo when creating a view
> ----------------------------------------------------------------
>
> Key: HIVE-23849
> URL: https://issues.apache.org/jira/browse/HIVE-23849
> Project: Hive
> Issue Type: Bug
> Reporter: Barnabas Maidics
> Assignee: Barnabas Maidics
> Priority: Major
> Labels: pull-request-available
> Time Spent: 2h 10m
> Remaining Estimate: 0h
>
> When creating a view, Hive skips the creation of ColumnAccessInfo that should
> be created at [step 8|#L12601]. This causes Authorization error.
> Currently, this issue is "hidden" when CBO is enabled. By introducing
> HIVE-14496, CalcitePlanner creates this ColumnAccessInfo at [step
> 2|https://github.com/apache/hive/blob/11e069b277fd1a18899b8ca1d2926fcbe73f17f2/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java#L12459].
> But after turning off CBO, the issue is still there.
> I think the return statement in [step
> 5|https://github.com/apache/hive/blob/11e069b277fd1a18899b8ca1d2926fcbe73f17f2/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java#L12574]
> is not necessary.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
