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-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats
Date Thu, 21 Sep 2017 19:21:00 GMT

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

Hive QA commented on HIVE-17536:
--------------------------------



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

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

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

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-09-21 19:20:34.754
+ [[ -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-6925/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-09-21 19:20:34.758
+ cd apache-github-source-source
+ git fetch origin
>From https://github.com/apache/hive
   3e8ae68..afd0d9f  master     -> origin/master
   dec4efd..53dc1ff  branch-2   -> origin/branch-2
   7b51c96..d95cb29  branch-2.2 -> origin/branch-2.2
+ git reset --hard HEAD
HEAD is now at 3e8ae68 HIVE-17556: The test udf_mask_hash.q is failing (Marta Kuczora via
Zoltan Haindrich)
+ git clean -f -d
Removing standalone-metastore/src/gen/org/
+ 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 afd0d9f HIVE-17472: Drop-partition for multi-level partition fails, if data
does not exist. (Chris Drome, reviewed by Mithun Radhakrishnan)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2017-09-21 19:20:38.565
+ 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/ql/src/java/org/apache/hadoop/hive/ql/stats/StatsUtils.java: No such file or directory
error: a/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/bucketcontext_5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/bucketcontext_6.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/bucketmapjoin5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/cbo_rp_join1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/cbo_rp_udaf_percentile_approx_23.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/compute_stats_date.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/correlationoptimizer5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/decimal_precision.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/decimal_udf.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/decimal_udf2.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/distinct_windowing.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/distinct_windowing_no_cbo.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/drop_table_with_index.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out:
No such file or directory
error: a/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/gen_udf_example_add10.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/groupby10.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/groupby_grouping_id3.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/groupby_grouping_sets_grouping.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/index_serde.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/input22.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/input3_limit.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/input4.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/join_star.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.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/bucketmapjoin1.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/column_table_stats.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/count.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out: No such
file or directory
error: a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.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/join_is_not_distinct_from.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/mapjoin_hint.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/orc_merge5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/orc_merge6.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/orc_merge7.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/orc_merge_incompat1.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/llap/orc_merge_incompat2.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/smb_mapjoin_4.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/smb_mapjoin_5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/stats11.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/subquery_multi.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/llap/vector_windowing_navfn.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/nullscript.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/orc_merge5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/orc_merge6.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/parallel_orderby.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/ptf_matchpath.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/smb_mapjoin_2.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/smb_mapjoin_3.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/auto_sortmerge_join_5.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/bucketmapjoin4.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/bucketmapjoin5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative2.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative3.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/spark/count.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/gen_udf_example_add10.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/spark/groupby10.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/join_nullsafe.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/join_star.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/orc_merge5.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/orc_merge6.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/orc_merge7.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/orc_merge_incompat1.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/spark/orc_merge_incompat2.q.out: No such file
or directory
error: a/ql/src/test/results/clientpositive/spark/parallel_orderby.q.out: No such file or
directory
error: a/ql/src/test/results/clientpositive/spark/ptf_matchpath.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/smb_mapjoin_1.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/smb_mapjoin_25.q.out: No such file or directory
error: a/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out: No such file or directory
'
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12888132 - PreCommit-HIVE-Build

> StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero
stats
> -------------------------------------------------------------------------------------------
>
>                 Key: HIVE-17536
>                 URL: https://issues.apache.org/jira/browse/HIVE-17536
>             Project: Hive
>          Issue Type: Improvement
>          Components: Statistics
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>         Attachments: HIVE-17536.1.patch, HIVE-17536.2.patch, HIVE-17536.3.patch, HIVE-17536.4.patch,
HIVE-17536.5.patch
>
>
> This method returns zero for both of the following cases:
> * Statistics are missing in metastore
> * Actual stats e.g. number of rows are zero
> It'll be good for this method to return e.g. -1 in absence of statistics instead of assuming
it to be zero.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message