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-22777) Sorted dynamic partition optimization doesn't work if plan require implicit cast
Date Tue, 28 Jan 2020 04:57:00 GMT

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

Hive QA commented on HIVE-22777:
--------------------------------



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

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

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

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'
2020-01-28 04:52:10.159
+ [[ -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-20373/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'
2020-01-28 04:52:10.162
+ cd apache-github-source-source
+ git fetch origin
+ git reset --hard HEAD
HEAD is now at 6a5c0cd HIVE-22753: Fix gradual mem leak: Operationlog related appenders should
be cleared up on errors (Rajesh Balamohan, reviewed by Ashutosh Chauhan)
+ git clean -f -d
Removing standalone-metastore/metastore-server/src/gen/
+ git checkout master
Already on 'master'
Your branch is up-to-date with 'origin/master'.
+ git reset --hard origin/master
HEAD is now at 6a5c0cd HIVE-22753: Fix gradual mem leak: Operationlog related appenders should
be cleared up on errors (Rajesh Balamohan, reviewed by Ashutosh Chauhan)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2020-01-28 04:52:11.235
+ rm -rf ../yetus_PreCommit-HIVE-Build-20373
+ mkdir ../yetus_PreCommit-HIVE-Build-20373
+ git gc
+ cp -R . ../yetus_PreCommit-HIVE-Build-20373
+ mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-20373/yetus
+ 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
Trying to apply the patch with -p0
error: a/itests/src/test/resources/testconfiguration.properties: does not exist in index
error: a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedDynPartitionOptimizer.java:
does not exist in index
error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java: does not exist
in index
error: a/ql/src/test/queries/clientpositive/dynpart_sort_opt_bucketing.q: does not exist in
index
error: a/ql/src/test/results/clientpositive/bucket1.q.out: does not exist in index
error: a/ql/src/test/results/clientpositive/bucket2.q.out: does not exist in index
error: a/ql/src/test/results/clientpositive/bucket3.q.out: does not exist in index
error: a/ql/src/test/results/clientpositive/bucketsortoptimize_insert_3.q.out: does not exist
in index
error: a/ql/src/test/results/clientpositive/dynpart_sort_opt_bucketing.q.out: does not exist
in index
error: a/ql/src/test/results/clientpositive/llap/bucket2.q.out: does not exist in index
error: a/ql/src/test/results/clientpositive/llap/bucket3.q.out: does not exist in index
error: a/ql/src/test/results/clientpositive/llap/bucket4.q.out: does not exist in index
error: a/ql/src/test/results/clientpositive/llap/bucket5.q.out: does not exist in index
error: a/ql/src/test/results/clientpositive/llap/bucket_many.q.out: does not exist in index
error: a/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out: does not exist
in index
error: a/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out: does not exist
in index
error: a/ql/src/test/results/clientpositive/llap/check_constraint.q.out: does not exist in
index
error: a/ql/src/test/results/clientpositive/llap/default_constraint.q.out: does not exist
in index
error: a/ql/src/test/results/clientpositive/llap/disable_merge_for_bucketing.q.out: does not
exist in index
error: a/ql/src/test/results/clientpositive/llap/insert_into_default_keyword.q.out: does not
exist in index
error: a/ql/src/test/results/clientpositive/smb_mapjoin_20.q.out: does not exist in index
error: a/ql/src/test/results/clientpositive/stats10.q.out: does not exist in index
Trying to apply the patch with -p1
Going to apply patch with: git apply -p1
/data/hiveptest/working/scratch/build.patch:1851: trailing whitespace.
        Map 1 
/data/hiveptest/working/scratch/build.patch:1877: trailing whitespace.
        Reducer 2 
/data/hiveptest/working/scratch/build.patch:1901: trailing whitespace.
            ca_location_type 
/data/hiveptest/working/scratch/build.patch:1970: trailing whitespace.
        Map 1 
/data/hiveptest/working/scratch/build.patch:1996: trailing whitespace.
        Reducer 2 
warning: squelched 5 whitespace errors
warning: 10 lines add whitespace errors.
+ [[ maven == \m\a\v\e\n ]]
+ rm -rf /data/hiveptest/working/maven/org/apache/hive
+ mvn -B clean install -DskipTests -T 4 -q -Dmaven.repo.local=/data/hiveptest/working/maven
protoc-jar: executing: [/tmp/protoc3922765016431108895.exe, --version]
libprotoc 2.5.0
protoc-jar: executing: [/tmp/protoc3922765016431108895.exe, -I/data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-common/src/main/protobuf/org/apache/hadoop/hive/metastore,
--java_out=/data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-common/target/generated-sources,
/data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-common/src/main/protobuf/org/apache/hadoop/hive/metastore/metastore.proto]
ANTLR Parser Generator  Version 3.5.2
protoc-jar: executing: [/tmp/protoc89257793590919887.exe, --version]
libprotoc 2.5.0
ANTLR Parser Generator  Version 3.5.2
Output file /data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-server/target/generated-sources/org/apache/hadoop/hive/metastore/parser/FilterParser.java
does not exist: must build /data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/parser/Filter.g
org/apache/hadoop/hive/metastore/parser/Filter.g
log4j:WARN No appenders could be found for logger (DataNucleus.Persistence).
log4j:WARN Please initialize the log4j system properly.
DataNucleus Enhancer (version 4.1.17) for API "JDO"
DataNucleus Enhancer completed with success for 43 classes.
Processing annotations
Annotations processed
Processing annotations
No elements to process
ANTLR Parser Generator  Version 3.5.2
Output file /data/hiveptest/working/apache-github-source-source/ql/target/generated-sources/antlr3/org/apache/hadoop/hive/ql/parse/HiveLexer.java
does not exist: must build /data/hiveptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveLexer.g
org/apache/hadoop/hive/ql/parse/HiveLexer.g
Output file /data/hiveptest/working/apache-github-source-source/ql/target/generated-sources/antlr3/org/apache/hadoop/hive/ql/parse/HiveParser.java
does not exist: must build /data/hiveptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g
org/apache/hadoop/hive/ql/parse/HiveParser.g
Output file /data/hiveptest/working/apache-github-source-source/ql/target/generated-sources/antlr3/org/apache/hadoop/hive/ql/parse/HintParser.java
does not exist: must build /data/hiveptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/parse/HintParser.g
org/apache/hadoop/hive/ql/parse/HintParser.g
Generating vector expression code
Generating vector expression test code
Processing annotations
Annotations processed
Processing annotations
No elements to process
[ERROR] COMPILATION ERROR : 
[ERROR] /data/hiveptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedDynPartitionOptimizer.java:[308,29]
cannot find symbol
  symbol:   variable ParseUtils
  location: class org.apache.hadoop.hive.ql.optimizer.SortedDynPartitionOptimizer.SortedDynamicPartitionProc
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.6.1:compile
(default-compile) on project hive-exec: Compilation failure
[ERROR] /data/hiveptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedDynPartitionOptimizer.java:[308,29]
cannot find symbol
[ERROR] symbol:   variable ParseUtils
[ERROR] location: class org.apache.hadoop.hive.ql.optimizer.SortedDynPartitionOptimizer.SortedDynamicPartitionProc
[ERROR] -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please read the following
articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
[ERROR] 
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR]   mvn <goals> -rf :hive-exec
+ result=1
+ '[' 1 -ne 0 ']'
+ rm -rf yetus_PreCommit-HIVE-Build-20373
+ exit 1
'
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12991972 - PreCommit-HIVE-Build

> Sorted dynamic partition optimization doesn't work if plan require implicit cast
> --------------------------------------------------------------------------------
>
>                 Key: HIVE-22777
>                 URL: https://issues.apache.org/jira/browse/HIVE-22777
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Planning
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>            Priority: Major
>         Attachments: HIVE-22777.1.patch, HIVE-22777.2.patch
>
>
> *Repro*
> set hive.stats.autogather=false;
> set hive.optimize.sort.dynamic.partition.threshold=1;
> set hive.optimize.bucketingsorting = true;
> {code:sql}
> drop table if exists t1_staging;
> create table t1_staging(
>                            a string,
>                            b int,
>                            c int,
>                            d string)
>     partitioned by (e  decimal(18,0))
>     clustered by(a)
>         into 256 buckets STORED AS TEXTFILE;
> load data local inpath '../../data/files/sortdp/000000_0' overwrite into table t1_staging
partition (e=100);
> drop table t1_n147;
> create table t1_n147(
>                         a string,
>                         b decimal(6,0),
>                         c int,
>                         d string)
>     partitioned by (e decimal(3,0))
>     clustered by(a,b)
>         into 10 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true');
> set hive.stats.autogather=false;
> set hive.optimize.bucketingsorting = true;
> explain insert overwrite table t1_n147 partition(e) select a,b,c,d,e  from t1_staging;
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message