hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15269) Dynamic Min-Max runtime-filtering for Tez
Date Wed, 11 Jan 2017 00:40:58 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15816681#comment-15816681
] 

Hive QA commented on HIVE-15269:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12846647/HIVE-15269.10.patch

{color:red}ERROR:{color} -1 due to build exiting with an error

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/2868/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/2868/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-2868/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Tests exited with: NonZeroExitCodeException
Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit status 1 and
output '+ date '+%Y-%m-%d %T.%3N'
2017-01-11 00:40:28.486
+ [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]]
+ export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ export PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+ PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+ export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m '
+ ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m '
+ export 'MAVEN_OPTS=-Xmx1g '
+ MAVEN_OPTS='-Xmx1g '
+ cd /data/hiveptest/working/
+ tee /data/hiveptest/logs/PreCommit-HIVE-Build-2868/source-prep.txt
+ [[ false == \t\r\u\e ]]
+ mkdir -p maven ivy
+ [[ git = \s\v\n ]]
+ [[ git = \g\i\t ]]
+ [[ -z master ]]
+ [[ -d apache-github-source-source ]]
+ [[ ! -d apache-github-source-source/.git ]]
+ [[ ! -d apache-github-source-source ]]
+ date '+%Y-%m-%d %T.%3N'
2017-01-11 00:40:28.489
+ cd apache-github-source-source
+ git fetch origin
>From https://github.com/apache/hive
   b0ed824..9384825  master     -> origin/master
+ git reset --hard HEAD
HEAD is now at b0ed824 HIVE-15481 : Support multiple and nested subqueries (Vineet Garg via
Ashutosh Chauhan)
+ git clean -f -d
+ git checkout master
Already on 'master'
Your branch is behind 'origin/master' by 1 commit, and can be fast-forwarded.
  (use "git pull" to update your local branch)
+ git reset --hard origin/master
HEAD is now at 9384825 HIVE-15521: setRightValue() code generated using FilterColumnBetween.txt
is incorrect (Jason Dere, reviewed by Matt McCline)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2017-01-11 00:40:37.188
+ patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh
+ patchFilePath=/data/hiveptest/working/scratch/build.patch
+ [[ -f /data/hiveptest/working/scratch/build.patch ]]
+ chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh
+ /data/hiveptest/working/scratch/smart-apply-patch.sh /data/hiveptest/working/scratch/build.patch
error: a/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java: No such file or directory
error: a/itests/src/test/resources/testconfiguration.properties: No such file or directory
error: a/orc/src/test/org/apache/orc/impl/TestRecordReaderImpl.java: No such file or directory
error: a/pom.xml: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/AbstractMapJoinOperator.java: No such
file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/CommonJoinOperator.java: No such file
or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExprNodeColumnEvaluator.java: No such
file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExprNodeConstantDefaultEvaluator.java:
No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExprNodeConstantEvaluator.java: No such
file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExprNodeEvaluator.java: No such file or
directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExprNodeEvaluatorFactory.java: No such
file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExprNodeEvaluatorHead.java: No such file
or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExprNodeEvaluatorRef.java: No such file
or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExprNodeFieldEvaluator.java: No such file
or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ExprNodeGenericFuncEvaluator.java: No
such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/FilterOperator.java: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/GroupByOperator.java: No such file or
directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/HashTableSinkOperator.java: No such file
or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/JoinUtil.java: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ObjectCache.java: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ObjectCacheWrapper.java: No such file
or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/SelectOperator.java: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/mr/ObjectCache.java: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/tez/LlapObjectCache.java: No such file
or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/tez/MapRecordProcessor.java: No such file
or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/tez/ObjectCache.java: No such file or
directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/tez/ReduceRecordProcessor.java: No such
file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/vector/VectorMapJoinOperator.java: No
such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/vector/VectorSMBMapJoinOperator.java:
No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/vector/VectorizationContext.java: No such
file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/io/sarg/ConvertAstToSearchArg.java: No such
file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ConvertJoinMapJoin.java: No such
file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/DynamicPartitionPruningOptimization.java:
No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/FixedBucketPruningOptimizer.java:
No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/RedundantDynamicPruningConditionsRemoval.java:
No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java:
No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/GenTezUtils.java: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/ParseContext.java: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/TaskCompiler.java: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/TezCompiler.java: No such file or directory
error: a/ql/src/java/org/apache/hadoop/hive/ql/plan/BaseWork.java: No such file or directory
error: a/ql/src/test/org/apache/hadoop/hive/ql/io/sarg/TestConvertAstToSearchArg.java: No
such file or directory
error: a/ql/src/test/org/apache/hadoop/hive/ql/io/sarg/TestSearchArgumentImpl.java: No such
file or directory
error: a/ql/src/test/org/apache/hadoop/hive/ql/optimizer/physical/TestVectorizer.java: No
such file or directory
error: a/ql/src/test/results/clientpositive/llap/auto_join1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/auto_join21.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/auto_join29.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/llap/cluster.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/column_access_stats.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/llap/correlationoptimizer1.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/correlationoptimizer2.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/correlationoptimizer3.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/correlationoptimizer4.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/correlationoptimizer6.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/cross_join.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/cross_product_check_1.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/cross_product_check_2.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/cte_mat_3.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/cte_mat_4.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/cte_mat_5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning_2.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/llap/empty_join.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/explainuser_2.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/explainuser_4.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/filter_join_breaktask.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/identity_project_remove_skip.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/llap/join1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/join46.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/join_emit_interval.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/llap/join_nullsafe.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/llapdecider.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/mrr.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/ppd_union_view.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/ptf.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/reduce_deduplicate_extended.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/llap/skewjoin.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/smb_cache.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/smb_mapjoin_14.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/smb_mapjoin_15.q.out: No such file or directory
'
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12846647 - PreCommit-HIVE-Build

> Dynamic Min-Max runtime-filtering for Tez
> -----------------------------------------
>
>                 Key: HIVE-15269
>                 URL: https://issues.apache.org/jira/browse/HIVE-15269
>             Project: Hive
>          Issue Type: New Feature
>            Reporter: Jason Dere
>            Assignee: Deepak Jaiswal
>         Attachments: HIVE-15269.1.patch, HIVE-15269.10.patch, HIVE-15269.2.patch, HIVE-15269.3.patch,
HIVE-15269.4.patch, HIVE-15269.5.patch, HIVE-15269.6.patch, HIVE-15269.7.patch, HIVE-15269.8.patch,
HIVE-15269.9.patch
>
>
> If a dimension table and fact table are joined:
> {noformat}
> select *
> from store join store_sales on (store.id = store_sales.store_id)
> where store.s_store_name = 'My Store'
> {noformat}
> One optimization that can be done is to get the min/max store id values that come out
of the scan/filter of the store table, and send this min/max value (via Tez edge) to the task
which is scanning the store_sales table.
> We can add a BETWEEN(min, max) predicate to the store_sales TableScan, where this predicate
can be pushed down to the storage handler (for example for ORC formats). Pushing a min/max
predicate to the ORC reader would allow us to avoid having to entire whole row groups during
the table scan.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message