[jira] [Commented] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744751#comment-16744751 ] Hive QA commented on HIVE-21078: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955187/HIVE-21078.09.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15658/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15658/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15658/ 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' 2019-01-17 07:23:24.437 + [[ -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-15658/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' 2019-01-17 07:23:24.440 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 8e7c3b3 HIVE-21124: HPL/SQL does not support the CREATE TABLE LIKE statement (Baoning He, reviewed by Daniel Dai) + git clean -f -d + git checkout master Already on 'master' Your branch is up-to-date with 'origin/master'. + git reset --hard origin/master HEAD is now at 8e7c3b3 HIVE-21124: HPL/SQL does not support the CREATE TABLE LIKE statement (Baoning He, reviewed by Daniel Dai) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-17 07:23:25.142 + rm -rf ../yetus_PreCommit-HIVE-Build-15658 + mkdir ../yetus_PreCommit-HIVE-Build-15658 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15658 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15658/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 error: a/hcatalog/server-extensions/src/main/java/org/apache/hive/hcatalog/listener/DbNotificationListener.java: does not exist in index error: a/itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/TestReplicationScenarios.java: does not exist in index error: a/itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/TestReplicationScenariosAcidTables.java: does not exist in index error: a/itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/TestReplicationScenariosAcrossInstances.java: does not exist in index error: a/itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/WarehouseInstance.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ColumnStatsUpdateTask.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/MoveTask.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/repl/ReplDumpTask.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/repl/bootstrap/events/filesystem/FSTableEvent.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/repl/bootstrap/load/table/LoadTable.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/metadata/SessionHiveMetaStoreClient.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/metadata/Table.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/ImportSemanticAnalyzer.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/repl/dump/HiveWrapper.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/repl/dump/TableExport.java: does not exist in index error: a/ql/src/java/org/apache/hadoop
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Attachment: HIVE-21078.09.patch Status: Patch Available (was: In Progress) This is rebased version of 05 patch on top of latest head i.e. 8e7c3b340f36a3b76453338b04b8cda360eeaa70. > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.06.patch, HIVE-21078.07.patch, HIVE-21078.08.patch, > HIVE-21078.09.patch, HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Status: In Progress (was: Patch Available) > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.06.patch, HIVE-21078.07.patch, HIVE-21078.08.patch, > HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (HIVE-21016) Duplicate column name in GROUP BY statement causing Vertex failures
[ https://issues.apache.org/jira/browse/HIVE-21016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mani M reassigned HIVE-21016: - Assignee: Mani M > Duplicate column name in GROUP BY statement causing Vertex failures > --- > > Key: HIVE-21016 > URL: https://issues.apache.org/jira/browse/HIVE-21016 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 1.2.1 >Reporter: Bjorn Olsen >Assignee: Mani M >Priority: Major > > Hive queries fail with "Vertex failure" messages when the user submits a > query containing duplicate GROUP BY columns. The Hive query parser should > detect and reject this scenario with a meaningful error message, rather than > executing the query and failing with an obfuscated message. For complex > queries this can result in a lot of debugging effort, whereas a simple error > message could have saved some time. > To repeat the issue, choose any table and perform a GROUP BY with a duplicate > column name. > {{For example:}} > select count( * ), party_id from party {{group by party_id, party_id;}} > Note the duplicate column in the GROUP BY. > This will fail with messages similar to below: > Caused by: java.lang.RuntimeException: > org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while > processing vector batch (tag=0) ffb9-5fb1-3024-922a-10cc313a7c171 > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecordVector(ReduceRecordSource.java:390) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:232) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.run(ReduceRecordProcessor.java:266) > at > org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:150) > ... 14 more > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime > Error while processing vector batch (tag=0) > ffb9-5fb1-3024-922a-10cc313a7c171 > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.processVectorGroup(ReduceRecordSource.java:454) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecordVector(ReduceRecordSource.java:381) > ... 17 more > *Caused by: java.lang.ClassCastException: > org.apache.hadoop.hive.ql.exec.vector.LongColumnVector cannot be cast to > org.apache.hadoop.hive.ql.exec.vector.BytesColumnVector* -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744725#comment-16744725 ] Hive QA commented on HIVE-21078: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955182/HIVE-21078.08.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15657/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15657/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15657/ 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' 2019-01-17 06:35:09.526 + [[ -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-15657/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' 2019-01-17 06:35:09.528 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 8e7c3b3 HIVE-21124: HPL/SQL does not support the CREATE TABLE LIKE statement (Baoning He, reviewed by Daniel Dai) + git clean -f -d + git checkout master Already on 'master' Your branch is up-to-date with 'origin/master'. + git reset --hard origin/master HEAD is now at 8e7c3b3 HIVE-21124: HPL/SQL does not support the CREATE TABLE LIKE statement (Baoning He, reviewed by Daniel Dai) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-17 06:35:10.255 + rm -rf ../yetus_PreCommit-HIVE-Build-15657 + mkdir ../yetus_PreCommit-HIVE-Build-15657 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15657 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15657/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 error: a/hcatalog/server-extensions/src/main/java/org/apache/hive/hcatalog/listener/DbNotificationListener.java: does not exist in index error: a/itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/TestReplicationScenarios.java: does not exist in index error: a/itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/TestReplicationScenariosAcidTables.java: does not exist in index error: a/itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/TestReplicationScenariosAcrossInstances.java: does not exist in index error: a/itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/WarehouseInstance.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/ColumnStatsUpdateTask.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/MoveTask.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/repl/ReplDumpTask.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/repl/bootstrap/events/filesystem/FSTableEvent.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/exec/repl/bootstrap/load/table/LoadTable.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/metadata/SessionHiveMetaStoreClient.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/metadata/Table.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/ImportSemanticAnalyzer.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/repl/dump/HiveWrapper.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/repl/dump/TableExport.java: does not exist in index error: a/ql/src/java/org/apache/hadoop
[jira] [Commented] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744724#comment-16744724 ] Hive QA commented on HIVE-21001: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955180/HIVE-21001.09.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15656/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15656/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15656/ 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' 2019-01-17 06:33:26.869 + [[ -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-15656/source-prep.txt + [[ true == \t\r\u\e ]] + rm -rf ivy maven + 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' 2019-01-17 06:33:27.444 + cd apache-github-source-source + git fetch origin >From https://github.com/apache/hive 4d5d806..8e7c3b3 master -> origin/master + git reset --hard HEAD HEAD is now at 4d5d806 Revert "HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna)" + git clean -f -d Removing standalone-metastore/metastore-server/src/gen/ + 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 8e7c3b3 HIVE-21124: HPL/SQL does not support the CREATE TABLE LIKE statement (Baoning He, reviewed by Daniel Dai) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-17 06:33:28.292 + rm -rf ../yetus_PreCommit-HIVE-Build-15656 + mkdir ../yetus_PreCommit-HIVE-Build-15656 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15656 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15656/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 Going to apply patch with: git apply -p0 /data/hiveptest/working/scratch/build.patch:1840: trailing whitespace. null sort order: /data/hiveptest/working/scratch/build.patch:1841: trailing whitespace. sort order: /data/hiveptest/working/scratch/build.patch:1862: trailing whitespace. columns.comments /data/hiveptest/working/scratch/build.patch:1877: trailing whitespace. /data/hiveptest/working/scratch/build.patch:1887: trailing whitespace. columns.comments warning: squelched 68 whitespace errors warning: 73 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/protoc7197927695367038546.exe, --version] libprotoc 2.5.0 protoc-jar: executing: [/tmp/protoc7197927695367038546.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] [ERROR] Failed to execute goal on project hive-service-rpc: Could not resolve dependencies for project org.apache.hive:hive-service-rpc:jar:4.0.0-SNAPSHOT: Failed to collect dependencies for [commons-codec:commons-codec:jar:1.7 (compile), commons-cli:commons-cli:jar:1.2 (compile), org.apac
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Status: In Progress (was: Patch Available) > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.06.patch, HIVE-21078.07.patch, HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Attachment: HIVE-21078.08.patch Status: Patch Available (was: In Progress) The failure in previous ptest run is because of a spark job failure " java.lang.RuntimeException: Error caching map.xml" in hive.log. This isn't related to the code chages. Re-submitting the same patch as 05 but renamed as 08 to trigger ptests. > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.06.patch, HIVE-21078.07.patch, HIVE-21078.08.patch, > HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21124) HPL/SQL does not support the CREATE TABLE LIKE statement
[ https://issues.apache.org/jira/browse/HIVE-21124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Dai updated HIVE-21124: -- Resolution: Fixed Hadoop Flags: Reviewed Fix Version/s: 4.0.0 Status: Resolved (was: Patch Available) Patch pushed to master. Thanks for contributing! > HPL/SQL does not support the CREATE TABLE LIKE statement > > > Key: HIVE-21124 > URL: https://issues.apache.org/jira/browse/HIVE-21124 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-21124.1.patch > > > Hive supports the CREATE TABLE LIKE statement but HPL/SQL does not support. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Haindrich updated HIVE-21001: Attachment: HIVE-21001.09.patch > Upgrade to calcite-1.18 > --- > > Key: HIVE-21001 > URL: https://issues.apache.org/jira/browse/HIVE-21001 > Project: Hive > Issue Type: Improvement >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich >Priority: Major > Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch, > HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch, > HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch, > HIVE-21001.07.patch, HIVE-21001.08.patch, HIVE-21001.08.patch, > HIVE-21001.08.patch, HIVE-21001.09.patch > > > CLEAR LIBRARY CACHE -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744702#comment-16744702 ] Hive QA commented on HIVE-21078: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955173/HIVE-21078.07.patch {color:green}SUCCESS:{color} +1 due to 8 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 15700 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[orc_merge9] (batchId=190) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15655/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15655/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15655/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12955173 - PreCommit-HIVE-Build > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.06.patch, HIVE-21078.07.patch, HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744692#comment-16744692 ] Hive QA commented on HIVE-21078: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 26s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 6m 26s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 2m 56s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 1m 25s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 2m 6s{color} | {color:blue} standalone-metastore/metastore-common in master has 29 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 1s{color} | {color:blue} standalone-metastore/metastore-server in master has 188 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 40s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 24s{color} | {color:blue} hcatalog/server-extensions in master has 3 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 38s{color} | {color:blue} itests/hive-unit in master has 2 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 2m 30s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 25s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 3m 10s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 2m 47s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 2m 47s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 41s{color} | {color:red} ql: The patch generated 21 new + 759 unchanged - 1 fixed = 780 total (was 760) {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 21s{color} | {color:red} itests/hive-unit: The patch generated 3 new + 771 unchanged - 0 fixed = 774 total (was 771) {color} | | {color:red}-1{color} | {color:red} whitespace {color} | {color:red} 0m 0s{color} | {color:red} The patch has 4 line(s) that end in whitespace. Use git apply --whitespace=fix <>. Refer https://git-scm.com/docs/git-apply {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 8m 29s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 50s{color} | {color:green} metastore-common in the patch passed. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 17s{color} | {color:green} standalone-metastore_metastore-server generated 0 new + 49 unchanged - 1 fixed = 49 total (was 50) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 55s{color} | {color:green} ql in the patch passed. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 11s{color} | {color:green} server-extensions in the patch passed. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 21s{color} | {color:green} hive-unit in the patch passed. {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 12s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 42m 53s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15655/dev-s
[jira] [Commented] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744678#comment-16744678 ] Hive QA commented on HIVE-20318: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955172/HIVE-20318.03.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 15694 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15654/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15654/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15654/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12955172 - PreCommit-HIVE-Build > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch, > HIVE-20318.03.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.NullPointerException > at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901) > at > org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1020) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:697) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189) > ... 8 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744659#comment-16744659 ] Hive QA commented on HIVE-20318: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 42s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 1s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 36s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 39s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 55s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 21s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 1s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 1s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 36s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 3m 47s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 12s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 22m 14s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15654/dev-support/hive-personality.sh | | git revision | master / 4d5d806 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15654/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch, > HIVE-20318.03.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.secu
[jira] [Commented] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744642#comment-16744642 ] Hive QA commented on HIVE-20318: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955169/HIVE-20318.02.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 15694 tests executed *Failed tests:* {noformat} org.apache.hive.jdbc.TestSSL.testMetastoreWithSSL (batchId=260) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15653/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15653/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15653/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12955169 - PreCommit-HIVE-Build > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch, > HIVE-20318.03.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.NullPointerException > at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901) > at > org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1020) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:697) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189) > ... 8 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Attachment: HIVE-21078.07.patch Status: Patch Available (was: In Progress) Ran TestSSL which failed in the last ptest run locally. It passed. Also, it has passed for past ptest runs. This patch is same as .05 patch. Renaming it to trigger ptest. > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.06.patch, HIVE-21078.07.patch, HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Status: In Progress (was: Patch Available) > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.06.patch, HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744612#comment-16744612 ] Hive QA commented on HIVE-20318: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 52s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 1s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 35s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 45s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 53s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 24s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 58s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 58s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 38s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 3m 52s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 51s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 22m 29s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15653/dev-support/hive-personality.sh | | git revision | master / 4d5d806 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15653/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch, > HIVE-20318.03.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.secu
[jira] [Updated] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ryu Kobayashi updated HIVE-20318: - Attachment: (was: HIVE-20318.02.patch) > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch, > HIVE-20318.03.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.NullPointerException > at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901) > at > org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1020) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:697) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189) > ... 8 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ryu Kobayashi updated HIVE-20318: - Attachment: HIVE-20318.03.patch > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch, > HIVE-20318.03.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.NullPointerException > at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901) > at > org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1020) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:697) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189) > ... 8 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ryu Kobayashi updated HIVE-20318: - Attachment: HIVE-20318.02.patch > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch, > HIVE-20318.03.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.NullPointerException > at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901) > at > org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1020) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:697) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189) > ... 8 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ryu Kobayashi updated HIVE-20318: - Attachment: HIVE-20318.02.patch > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.NullPointerException > at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901) > at > org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1020) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:697) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189) > ... 8 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ryu Kobayashi updated HIVE-20318: - Attachment: (was: HIVE-20318.02.patch) > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.NullPointerException > at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901) > at > org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1020) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:697) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189) > ... 8 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744591#comment-16744591 ] Hive QA commented on HIVE-20318: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955159/HIVE-20318.02.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 15694 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_multi_insert] (batchId=81) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15652/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15652/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15652/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12955159 - PreCommit-HIVE-Build > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.NullPointerException > at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901) > at > org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1020) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:697) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189) > ... 8 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744570#comment-16744570 ] Hive QA commented on HIVE-20318: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 47s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 3s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 38s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 42s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 55s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 22s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 59s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 59s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 39s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 3m 57s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 57s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 22m 34s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15652/dev-support/hive-personality.sh | | git revision | master / 4d5d806 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15652/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformatio
[jira] [Commented] (HIVE-20707) Automatic partition management
[ https://issues.apache.org/jira/browse/HIVE-20707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744562#comment-16744562 ] Prasanth Jayachandran commented on HIVE-20707: -- [~jcamachorodriguez] This patch brings in breaking changes mostly for external tables (auto partition discovery is enabled by default). That's why did not backport the patch to branch-3. I am guessing the fixes are primarily related to catalog name missing in metastore APIs?. If that's the case we could pick only the changes to ObjectStore.java, NonCatCallsWithCatalog.java which are pretty small. What do you think? > Automatic partition management > -- > > Key: HIVE-20707 > URL: https://issues.apache.org/jira/browse/HIVE-20707 > Project: Hive > Issue Type: New Feature >Affects Versions: 4.0.0 >Reporter: Prasanth Jayachandran >Assignee: Prasanth Jayachandran >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-20702.3.patch, HIVE-20707-branch-3.patch, > HIVE-20707.1.patch, HIVE-20707.2.patch, HIVE-20707.4.patch, > HIVE-20707.5.patch, HIVE-20707.6.patch, HIVE-20707.6.patch, HIVE-20707.7.patch > > > In current scenario, to add partitions for external tables to metastore, MSCK > REPAIR command has to be executed manually. To avoid this manual step, > external tables can be specified a table property based on which a background > metastore thread can sync partitions periodically. Tables can also be > specified with partition retention period. Any partition whose age exceeds > the retention period will be dropped automatically. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21077) Database and catalogs should have creation time
[ https://issues.apache.org/jira/browse/HIVE-21077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744549#comment-16744549 ] Hive QA commented on HIVE-21077: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955160/HIVE-21077.09.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15651/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15651/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15651/ 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' 2019-01-17 00:13:43.057 + [[ -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-15651/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' 2019-01-17 00:13:43.060 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 4c73511 HIVE-21040 : msck does unnecessary file listing at last level of directory tree (Vihang Karajgaonkar, reviewed by Prasanth Jayachandran) + git clean -f -d + git checkout master Switched to branch '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 4d5d806 Revert "HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna)" + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-17 00:13:47.398 + rm -rf ../yetus_PreCommit-HIVE-Build-15651 + mkdir ../yetus_PreCommit-HIVE-Build-15651 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15651 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15651/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 error: a/standalone-metastore/metastore-common/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Catalog.java: does not exist in index error: a/standalone-metastore/metastore-common/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Database.java: does not exist in index error: a/standalone-metastore/metastore-common/src/gen/thrift/gen-php/metastore/Types.php: does not exist in index error: a/standalone-metastore/metastore-common/src/gen/thrift/gen-py/hive_metastore/ttypes.py: does not exist in index error: a/standalone-metastore/metastore-common/src/gen/thrift/gen-rb/hive_metastore_types.rb: does not exist in index error: a/standalone-metastore/metastore-common/src/main/thrift/hive_metastore.thrift: does not exist in index error: a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java: does not exist in index error: a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java: does not exist in index error: a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/ObjectStore.java: does not exist in index error: a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/client/builder/DatabaseBuilder.java: does not exist in index error: a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/model/MCatalog.java: does not exist in index error: a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/model/MDatabase.java: does not exist in index error: a/standalone-metastore/metastore-server/src/main/resources/package.jdo: does not exist in index error: a/standalone-metastore/metastore-server/src/main/sql/derby/hive-schem
[jira] [Commented] (HIVE-21077) Database and catalogs should have creation time
[ https://issues.apache.org/jira/browse/HIVE-21077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744545#comment-16744545 ] Vihang Karajgaonkar commented on HIVE-21077: I actually reverted the v8 patch from the master since I wanted to include the schema changes for 3.2.0 release as well. In order to keep master in sync, the v9 patch makes changes to both the hive-schema-3.2.0* and hive-schema-4.0.0* files. Also, the upgrade scripts from 3.1.0-to-3.2.0 are modified so that we port this patch to branch-3 as well. [~bharos92] Can you please take a look again? There is no code change involved since last patch. The only additional change over v8 is schema changes are applied to 3.2.0 files as well and the upgrade logic is moved to 3.1.0-to-3.2.0 files. > Database and catalogs should have creation time > --- > > Key: HIVE-21077 > URL: https://issues.apache.org/jira/browse/HIVE-21077 > Project: Hive > Issue Type: Improvement > Components: Standalone Metastore >Reporter: Vihang Karajgaonkar >Assignee: Vihang Karajgaonkar >Priority: Major > Attachments: HIVE-21077.01.patch, HIVE-21077.02.patch, > HIVE-21077.03.patch, HIVE-21077.04.patch, HIVE-21077.05.patch, > HIVE-21077.06.patch, HIVE-21077.07.patch, HIVE-21077.08.branch-3.patch, > HIVE-21077.09.patch > > > Currently, database do not have creation time like we have for tables and > partitions. > {noformat} > // namespace for tables > struct Database { > 1: string name, > 2: string description, > 3: string locationUri, > 4: map parameters, // properties associated with the > database > 5: optional PrincipalPrivilegeSet privileges, > 6: optional string ownerName, > 7: optional PrincipalType ownerType, > 8: optional string catalogName > } > {noformat} > Currently, without creationTime there is no way to identify if the copy of > Database which a client has is the same as the one on the server if the name > is same. Without object ids creationTime value is the only way currently to > identify uniquely a instance of metastore object. It would be good to have > Database creation time as well. > Same applies for catalogs as well. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21077) Database and catalogs should have creation time
[ https://issues.apache.org/jira/browse/HIVE-21077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vihang Karajgaonkar updated HIVE-21077: --- Attachment: HIVE-21077.09.patch > Database and catalogs should have creation time > --- > > Key: HIVE-21077 > URL: https://issues.apache.org/jira/browse/HIVE-21077 > Project: Hive > Issue Type: Improvement > Components: Standalone Metastore >Reporter: Vihang Karajgaonkar >Assignee: Vihang Karajgaonkar >Priority: Major > Attachments: HIVE-21077.01.patch, HIVE-21077.02.patch, > HIVE-21077.03.patch, HIVE-21077.04.patch, HIVE-21077.05.patch, > HIVE-21077.06.patch, HIVE-21077.07.patch, HIVE-21077.08.branch-3.patch, > HIVE-21077.09.patch > > > Currently, database do not have creation time like we have for tables and > partitions. > {noformat} > // namespace for tables > struct Database { > 1: string name, > 2: string description, > 3: string locationUri, > 4: map parameters, // properties associated with the > database > 5: optional PrincipalPrivilegeSet privileges, > 6: optional string ownerName, > 7: optional PrincipalType ownerType, > 8: optional string catalogName > } > {noformat} > Currently, without creationTime there is no way to identify if the copy of > Database which a client has is the same as the one on the server if the name > is same. Without object ids creationTime value is the only way currently to > identify uniquely a instance of metastore object. It would be good to have > Database creation time as well. > Same applies for catalogs as well. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-20318) NullPointerException when union with lateral view
[ https://issues.apache.org/jira/browse/HIVE-20318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ryu Kobayashi updated HIVE-20318: - Attachment: HIVE-20318.02.patch > NullPointerException when union with lateral view > - > > Key: HIVE-20318 > URL: https://issues.apache.org/jira/browse/HIVE-20318 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0, 2.3.2, 3.1.0, 3.1.1 > Environment: Run on MR, hadoop 2.7.3 and Tez >Reporter: Wang Yan >Assignee: Ryu Kobayashi >Priority: Blocker > Attachments: HIVE-20318.01.patch, HIVE-20318.02.patch > > > The following sql throws NullPointerException. > This sql is not table/data specific and can be run directly. > {code:sql} > WITH > t1 AS (SELECT 0 AS c1), > t2 AS ( > SELECT 0 AS c1 > FROM ( > SELECT COLLECT_SET('line') AS c2 >) t3 lateral VIEW explode(ARRAY("a")) er AS c3 > ) > SELECT c1 > FROM t1 > UNION ALL > SELECT c1 > FROM t2 > {code} > This is the exception. > {code:java} > 2018-04-20 01:53:50,845 WARN [Thread-5] org.apache.hadoop.mapred.YarnChild: > Exception running child : java.lang.RuntimeException: Hive Runtime Error > while closing operators > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.lang.NullPointerException > at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901) > at > org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1020) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:697) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:711) > at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189) > ... 8 more > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21077) Database and catalogs should have creation time
[ https://issues.apache.org/jira/browse/HIVE-21077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1676#comment-1676 ] Hive QA commented on HIVE-21077: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955144/HIVE-21077.08.branch-3.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15650/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15650/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15650/ 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' 2019-01-16 20:37:58.776 + [[ -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-15650/source-prep.txt + [[ false == \t\r\u\e ]] + mkdir -p maven ivy + [[ git = \s\v\n ]] + [[ git = \g\i\t ]] + [[ -z branch-3 ]] + [[ -d apache-github-source-source ]] + [[ ! -d apache-github-source-source/.git ]] + [[ ! -d apache-github-source-source ]] + date '+%Y-%m-%d %T.%3N' 2019-01-16 20:37:58.779 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 4c73511 HIVE-21040 : msck does unnecessary file listing at last level of directory tree (Vihang Karajgaonkar, reviewed by Prasanth Jayachandran) + git clean -f -d Removing kafka-handler/ Removing standalone-metastore/metastore-common/ Removing standalone-metastore/metastore-server/ Removing standalone-metastore/metastore-tools/ Removing upgrade-acid/pre-upgrade/ + git checkout branch-3 Already on 'branch-3' Your branch is up-to-date with 'origin/branch-3'. + git reset --hard origin/branch-3 HEAD is now at 4c73511 HIVE-21040 : msck does unnecessary file listing at last level of directory tree (Vihang Karajgaonkar, reviewed by Prasanth Jayachandran) + git merge --ff-only origin/branch-3 Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-16 20:37:59.391 + rm -rf ../yetus_PreCommit-HIVE-Build-15650 + mkdir ../yetus_PreCommit-HIVE-Build-15650 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15650 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15650/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 error: a/standalone-metastore/src/gen/thrift/gen-cpp/hive_metastore_types.cpp: does not exist in index error: a/standalone-metastore/src/gen/thrift/gen-cpp/hive_metastore_types.h: does not exist in index error: a/standalone-metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Catalog.java: does not exist in index error: a/standalone-metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Database.java: does not exist in index error: a/standalone-metastore/src/gen/thrift/gen-php/metastore/Types.php: does not exist in index error: a/standalone-metastore/src/gen/thrift/gen-py/hive_metastore/ttypes.py: does not exist in index error: a/standalone-metastore/src/gen/thrift/gen-rb/hive_metastore_types.rb: does not exist in index error: a/standalone-metastore/src/main/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java: does not exist in index error: a/standalone-metastore/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java: does not exist in index error: a/standalone-metastore/src/main/java/org/apache/hadoop/hive/metastore/ObjectStore.java: does not exist in index error: a/standalone-metastore/src/main/java/org/apache/hadoop/hive/metastore/client/builder/DatabaseBuilder.java: does not exist in index error: a/standalone-metastore/src/main/java/org/apache/hadoop/hive/metastore/model/MCatalog.java: does not exist in index error: a/standalone-metastore/src/main/java/org/apache/hadoop/hive/metastore/model/MDatabase.java: does not exist in index error: a/standalone-metastore/src/main/resources/package.jdo: does not exist in index error: a/standalone-metastore/src/main/sql/derby/hive-schem
[jira] [Commented] (HIVE-21128) hive.version.shortname should be 3.2 on branch-3
[ https://issues.apache.org/jira/browse/HIVE-21128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1674#comment-1674 ] Hive QA commented on HIVE-21128: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955143/HIVE-21128.01.branch-3.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15649/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15649/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15649/ 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' 2019-01-16 20:36:03.206 + [[ -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-15649/source-prep.txt + [[ false == \t\r\u\e ]] + mkdir -p maven ivy + [[ git = \s\v\n ]] + [[ git = \g\i\t ]] + [[ -z branch-3 ]] + [[ -d apache-github-source-source ]] + [[ ! -d apache-github-source-source/.git ]] + [[ ! -d apache-github-source-source ]] + date '+%Y-%m-%d %T.%3N' 2019-01-16 20:36:03.209 + cd apache-github-source-source + git fetch origin >From https://github.com/apache/hive 4d8320d..4d5d806 master -> origin/master + git reset --hard HEAD HEAD is now at 4d8320d HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna) + git clean -f -d + git checkout branch-3 Switched to branch 'branch-3' Your branch is behind 'origin/branch-3' by 2 commits, and can be fast-forwarded. (use "git pull" to update your local branch) + git reset --hard origin/branch-3 HEAD is now at 4c73511 HIVE-21040 : msck does unnecessary file listing at last level of directory tree (Vihang Karajgaonkar, reviewed by Prasanth Jayachandran) + git merge --ff-only origin/branch-3 Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-16 20:36:06.434 + rm -rf ../yetus_PreCommit-HIVE-Build-15649 + mkdir ../yetus_PreCommit-HIVE-Build-15649 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15649 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15649/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 error: a/standalone-metastore/pom.xml: does not exist in index Going to apply patch with: git apply -p1 + [[ 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/protoc5371160071875224398.exe, --version] libprotoc 2.5.0 protoc-jar: executing: [/tmp/protoc5371160071875224398.exe, -I/data/hiveptest/working/apache-github-source-source/standalone-metastore/src/main/protobuf/org/apache/hadoop/hive/metastore, --java_out=/data/hiveptest/working/apache-github-source-source/standalone-metastore/target/generated-sources, /data/hiveptest/working/apache-github-source-source/standalone-metastore/src/main/protobuf/org/apache/hadoop/hive/metastore/metastore.proto] ANTLR Parser Generator Version 3.5.2 Output file /data/hiveptest/working/apache-github-source-source/standalone-metastore/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/src/main/java/org/apache/hadoop/hive/metastore/parser/Filter.g org/apache/hadoop/hive/metastore/parser/Filter.g [ERROR] Failed to execute goal on project hive-shims-0.23: Could not resolve dependencies for project org.apache.hive.shims:hive-shims-0.23:jar:3.2.0-SNAPSHOT: The following artifacts could not be resolved: org.apache.hadoop:hadoop-yarn-server-resourcemanager:jar:3.1.0, org.apache.hadoop:hadoop-yarn-server-common:jar:3.1.0, org.apache.hadoop:hadoop-yarn-registry:jar:3.1.0, dnsjava:dnsjava:jar:2.1.7, org.apache.geronimo.specs:geronimo-jcache_1.0_spec:jar:1.0-alpha-1, org.ehcache
[jira] [Commented] (HIVE-21077) Database and catalogs should have creation time
[ https://issues.apache.org/jira/browse/HIVE-21077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744430#comment-16744430 ] Vihang Karajgaonkar commented on HIVE-21077: Thanks for the review [~bharos92]. Attaching a patch for branch-3. I merged the patch for the master branch, but I think since I plan to merge this patch in branch-3 as well, I will have to add a addentum patch to the master branch so that upgrade scripts are from 3.1.0-3.2.0 are modified instead of 3.2.0-4.0.0. > Database and catalogs should have creation time > --- > > Key: HIVE-21077 > URL: https://issues.apache.org/jira/browse/HIVE-21077 > Project: Hive > Issue Type: Improvement > Components: Standalone Metastore >Reporter: Vihang Karajgaonkar >Assignee: Vihang Karajgaonkar >Priority: Major > Attachments: HIVE-21077.01.patch, HIVE-21077.02.patch, > HIVE-21077.03.patch, HIVE-21077.04.patch, HIVE-21077.05.patch, > HIVE-21077.06.patch, HIVE-21077.07.patch, HIVE-21077.08.branch-3.patch > > > Currently, database do not have creation time like we have for tables and > partitions. > {noformat} > // namespace for tables > struct Database { > 1: string name, > 2: string description, > 3: string locationUri, > 4: map parameters, // properties associated with the > database > 5: optional PrincipalPrivilegeSet privileges, > 6: optional string ownerName, > 7: optional PrincipalType ownerType, > 8: optional string catalogName > } > {noformat} > Currently, without creationTime there is no way to identify if the copy of > Database which a client has is the same as the one on the server if the name > is same. Without object ids creationTime value is the only way currently to > identify uniquely a instance of metastore object. It would be good to have > Database creation time as well. > Same applies for catalogs as well. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21077) Database and catalogs should have creation time
[ https://issues.apache.org/jira/browse/HIVE-21077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vihang Karajgaonkar updated HIVE-21077: --- Attachment: HIVE-21077.08.branch-3.patch > Database and catalogs should have creation time > --- > > Key: HIVE-21077 > URL: https://issues.apache.org/jira/browse/HIVE-21077 > Project: Hive > Issue Type: Improvement > Components: Standalone Metastore >Reporter: Vihang Karajgaonkar >Assignee: Vihang Karajgaonkar >Priority: Major > Attachments: HIVE-21077.01.patch, HIVE-21077.02.patch, > HIVE-21077.03.patch, HIVE-21077.04.patch, HIVE-21077.05.patch, > HIVE-21077.06.patch, HIVE-21077.07.patch, HIVE-21077.08.branch-3.patch > > > Currently, database do not have creation time like we have for tables and > partitions. > {noformat} > // namespace for tables > struct Database { > 1: string name, > 2: string description, > 3: string locationUri, > 4: map parameters, // properties associated with the > database > 5: optional PrincipalPrivilegeSet privileges, > 6: optional string ownerName, > 7: optional PrincipalType ownerType, > 8: optional string catalogName > } > {noformat} > Currently, without creationTime there is no way to identify if the copy of > Database which a client has is the same as the one on the server if the name > is same. Without object ids creationTime value is the only way currently to > identify uniquely a instance of metastore object. It would be good to have > Database creation time as well. > Same applies for catalogs as well. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21128) hive.version.shortname should be 3.2 on branch-3
[ https://issues.apache.org/jira/browse/HIVE-21128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vihang Karajgaonkar updated HIVE-21128: --- Status: Patch Available (was: Open) > hive.version.shortname should be 3.2 on branch-3 > > > Key: HIVE-21128 > URL: https://issues.apache.org/jira/browse/HIVE-21128 > Project: Hive > Issue Type: Bug >Reporter: Vihang Karajgaonkar >Assignee: Vihang Karajgaonkar >Priority: Major > Attachments: HIVE-21128.01.branch-3.patch > > > Since 3.1.0 is already release, the {{hive.version.shortname}} property in > the pom.xml of standalone-metastore should be 3.2.0. This version shortname > is used to generate the metastore schema version and used by Schematool to > initialize the schema using the correct script. Currently it using 3.1.0 > schema init script instead of 3.2.0 init script -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21128) hive.version.shortname should be 3.2 on branch-3
[ https://issues.apache.org/jira/browse/HIVE-21128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vihang Karajgaonkar updated HIVE-21128: --- Attachment: HIVE-21128.01.branch-3.patch > hive.version.shortname should be 3.2 on branch-3 > > > Key: HIVE-21128 > URL: https://issues.apache.org/jira/browse/HIVE-21128 > Project: Hive > Issue Type: Bug >Reporter: Vihang Karajgaonkar >Assignee: Vihang Karajgaonkar >Priority: Major > Attachments: HIVE-21128.01.branch-3.patch > > > Since 3.1.0 is already release, the {{hive.version.shortname}} property in > the pom.xml of standalone-metastore should be 3.2.0. This version shortname > is used to generate the metastore schema version and used by Schematool to > initialize the schema using the correct script. Currently it using 3.1.0 > schema init script instead of 3.2.0 init script -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (HIVE-21128) hive.version.shortname should be 3.2 on branch-3
[ https://issues.apache.org/jira/browse/HIVE-21128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vihang Karajgaonkar reassigned HIVE-21128: -- Assignee: Vihang Karajgaonkar > hive.version.shortname should be 3.2 on branch-3 > > > Key: HIVE-21128 > URL: https://issues.apache.org/jira/browse/HIVE-21128 > Project: Hive > Issue Type: Bug >Reporter: Vihang Karajgaonkar >Assignee: Vihang Karajgaonkar >Priority: Major > > Since 3.1.0 is already release, the {{hive.version.shortname}} property in > the pom.xml of standalone-metastore should be 3.2.0. This version shortname > is used to generate the metastore schema version and used by Schematool to > initialize the schema using the correct script. Currently it using 3.1.0 > schema init script instead of 3.2.0 init script -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21056) Make CompactionInfo extend CompactionInfoStruct
[ https://issues.apache.org/jira/browse/HIVE-21056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744368#comment-16744368 ] Hive QA commented on HIVE-21056: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955138/HIVE-21056.2.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15648/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15648/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15648/ 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' 2019-01-16 19:12:37.017 + [[ -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-15648/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' 2019-01-16 19:12:37.019 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 4d8320d HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna) + git clean -f -d + git checkout master Already on 'master' Your branch is up-to-date with 'origin/master'. + git reset --hard origin/master HEAD is now at 4d8320d HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-16 19:12:37.886 + rm -rf ../yetus_PreCommit-HIVE-Build-15648 + mkdir ../yetus_PreCommit-HIVE-Build-15648 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15648 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15648/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 Going to apply patch with: git apply -p0 + [[ 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/protoc3532778246148931043.exe, --version] libprotoc 2.5.0 protoc-jar: executing: [/tmp/protoc3532778246148931043.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 [ERROR] Failed to execute goal on project hive-shims-common: Could not resolve dependencies for project org.apache.hive.shims:hive-shims-common:jar:4.0.0-SNAPSHOT: The following artifacts could not be resolved: com.fasterxml.jackson.core:jackson-databind:jar:2.9.5, org.apache.hadoop:hadoop-hdfs-client:jar:3.1.0, com.squareup.okhttp:okhttp:jar:2.7.5, com.squareup.okio:okio:jar:1.6.0, org.apache.hadoop:hadoop-yarn-api:jar:3.1.0, org.apache.hadoop:hadoop-yarn-client:jar:3.1.0, org.apache.hadoop:hadoop-mapreduce-client-core:jar:3.1.0, org.apache.hadoop:hadoop-yarn-common:jar:3.1.0: Could not find artifact com.fasterxml.jackson.core:jackson-databind:jar:2.9.5 in datanucleus (http://www.datanucleus.org/downloads/maven2) -> [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/
[jira] [Commented] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744367#comment-16744367 ] Hive QA commented on HIVE-21001: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955137/HIVE-21001.08.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15647/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15647/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15647/ 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' 2019-01-16 19:10:59.380 + [[ -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-15647/source-prep.txt + [[ true == \t\r\u\e ]] + rm -rf ivy maven + 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' 2019-01-16 19:10:59.509 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 4d8320d HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna) + git clean -f -d + git checkout master Already on 'master' Your branch is up-to-date with 'origin/master'. + git reset --hard origin/master HEAD is now at 4d8320d HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-16 19:11:00.270 + rm -rf ../yetus_PreCommit-HIVE-Build-15647 + mkdir ../yetus_PreCommit-HIVE-Build-15647 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15647 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15647/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 Going to apply patch with: git apply -p0 /data/hiveptest/working/scratch/build.patch:1840: trailing whitespace. null sort order: /data/hiveptest/working/scratch/build.patch:1841: trailing whitespace. sort order: /data/hiveptest/working/scratch/build.patch:1862: trailing whitespace. columns.comments /data/hiveptest/working/scratch/build.patch:1877: trailing whitespace. /data/hiveptest/working/scratch/build.patch:1887: trailing whitespace. columns.comments warning: squelched 68 whitespace errors warning: 73 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 [ERROR] Failed to execute goal on project hive-vector-code-gen: Could not resolve dependencies for project org.apache.hive:hive-vector-code-gen:jar:4.0.0-SNAPSHOT: Failed to collect dependencies for [commons-lang:commons-lang:jar:2.6 (compile), com.google.guava:guava:jar:19.0 (compile), org.apache.ant:ant:jar:1.9.1 (compile), org.apache.velocity:velocity:jar:1.5 (compile), org.slf4j:slf4j-api:jar:1.7.10 (compile), org.mockito:mockito-all:jar:1.10.19 (test)]: Failed to read artifact descriptor for org.apache.ant:ant:jar:1.9.1: Could not find artifact org.apache.ant:ant-parent:pom:1.9.1 in datanucleus (http://www.datanucleus.org/downloads/maven2) -> [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/DependencyResolutionException [ERROR] [ERROR] After c
[jira] [Updated] (HIVE-21056) Make CompactionInfo extend CompactionInfoStruct
[ https://issues.apache.org/jira/browse/HIVE-21056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jaume M updated HIVE-21056: --- Attachment: HIVE-21056.2.patch Status: Patch Available (was: Open) > Make CompactionInfo extend CompactionInfoStruct > --- > > Key: HIVE-21056 > URL: https://issues.apache.org/jira/browse/HIVE-21056 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Jaume M >Assignee: Jaume M >Priority: Major > Attachments: HIVE-21056.1.patch, HIVE-21056.2.patch > > > CompactionInfo is serialized into CompactionInfoStruct and by doing so if new > fields are added to CompactionInfo they may not be added to the serialization > functions. Doing it this way will help prevent bugs. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21056) Make CompactionInfo extend CompactionInfoStruct
[ https://issues.apache.org/jira/browse/HIVE-21056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jaume M updated HIVE-21056: --- Status: Open (was: Patch Available) > Make CompactionInfo extend CompactionInfoStruct > --- > > Key: HIVE-21056 > URL: https://issues.apache.org/jira/browse/HIVE-21056 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Jaume M >Assignee: Jaume M >Priority: Major > Attachments: HIVE-21056.1.patch, HIVE-21056.2.patch > > > CompactionInfo is serialized into CompactionInfoStruct and by doing so if new > fields are added to CompactionInfo they may not be added to the serialization > functions. Doing it this way will help prevent bugs. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21056) Make CompactionInfo extend CompactionInfoStruct
[ https://issues.apache.org/jira/browse/HIVE-21056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744356#comment-16744356 ] Hive QA commented on HIVE-21056: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955132/HIVE-21056.1.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15645/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15645/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15645/ 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' 2019-01-16 18:55:30.572 + [[ -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-15645/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' 2019-01-16 18:55:30.575 + cd apache-github-source-source + git fetch origin >From https://github.com/apache/hive 1fff171..4d8320d master -> origin/master + git reset --hard HEAD HEAD is now at 1fff171 HIVE-21095: Show create table should not display a time zone for timestamp with local time zone (Karen Coppage via Marta Kuczora) + git clean -f -d Removing standalone-metastore/metastore-server/src/gen/ + 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 4d8320d HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-16 18:55:31.461 + rm -rf ../yetus_PreCommit-HIVE-Build-15645 + mkdir ../yetus_PreCommit-HIVE-Build-15645 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15645 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15645/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 error: patch failed: ql/src/java/org/apache/hadoop/hive/ql/txn/compactor/Worker.java:152 Falling back to three-way merge... Applied patch to 'ql/src/java/org/apache/hadoop/hive/ql/txn/compactor/Worker.java' with conflicts. Going to apply patch with: git apply -p0 error: patch failed: ql/src/java/org/apache/hadoop/hive/ql/txn/compactor/Worker.java:152 Falling back to three-way merge... Applied patch to 'ql/src/java/org/apache/hadoop/hive/ql/txn/compactor/Worker.java' with conflicts. U ql/src/java/org/apache/hadoop/hive/ql/txn/compactor/Worker.java + result=1 + '[' 1 -ne 0 ']' + rm -rf yetus_PreCommit-HIVE-Build-15645 + exit 1 ' {noformat} This message is automatically generated. ATTACHMENT ID: 12955132 - PreCommit-HIVE-Build > Make CompactionInfo extend CompactionInfoStruct > --- > > Key: HIVE-21056 > URL: https://issues.apache.org/jira/browse/HIVE-21056 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Jaume M >Assignee: Jaume M >Priority: Major > Attachments: HIVE-21056.1.patch > > > CompactionInfo is serialized into CompactionInfoStruct and by doing so if new > fields are added to CompactionInfo they may not be added to the serialization > functions. Doing it this way will help prevent bugs. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Haindrich updated HIVE-21001: Attachment: HIVE-21001.08.patch > Upgrade to calcite-1.18 > --- > > Key: HIVE-21001 > URL: https://issues.apache.org/jira/browse/HIVE-21001 > Project: Hive > Issue Type: Improvement >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich >Priority: Major > Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch, > HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch, > HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch, > HIVE-21001.07.patch, HIVE-21001.08.patch, HIVE-21001.08.patch, > HIVE-21001.08.patch > > > CLEAR LIBRARY CACHE -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744358#comment-16744358 ] Hive QA commented on HIVE-21001: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955134/HIVE-21001.08.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15646/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15646/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15646/ 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' 2019-01-16 18:56:44.816 + [[ -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-15646/source-prep.txt + [[ true == \t\r\u\e ]] + rm -rf ivy maven + 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' 2019-01-16 18:56:51.081 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 4d8320d HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna) + git clean -f -d + git checkout master Already on 'master' Your branch is up-to-date with 'origin/master'. + git reset --hard origin/master HEAD is now at 4d8320d HIVE-21077 : Database and Catalogs should have creation time (Vihang Karajgaonkar reviewed by Karthik Manamcheri and Bharath Krishna) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-16 18:56:52.085 + rm -rf ../yetus_PreCommit-HIVE-Build-15646 + mkdir ../yetus_PreCommit-HIVE-Build-15646 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15646 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15646/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 Going to apply patch with: git apply -p0 /data/hiveptest/working/scratch/build.patch:1840: trailing whitespace. null sort order: /data/hiveptest/working/scratch/build.patch:1841: trailing whitespace. sort order: /data/hiveptest/working/scratch/build.patch:1862: trailing whitespace. columns.comments /data/hiveptest/working/scratch/build.patch:1877: trailing whitespace. /data/hiveptest/working/scratch/build.patch:1887: trailing whitespace. columns.comments warning: squelched 68 whitespace errors warning: 73 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 [ERROR] Failed to execute goal on project hive-standalone-metastore-common: Could not resolve dependencies for project org.apache.hive:hive-standalone-metastore-common:jar:4.0.0-SNAPSHOT: Failed to collect dependencies for [org.apache.orc:orc-core:jar:1.5.1 (compile), com.fasterxml.jackson.core:jackson-databind:jar:2.9.5 (compile), com.github.joshelser:dropwizard-metrics-hadoop-metrics2-reporter:jar:0.1.2 (compile), com.google.guava:guava:jar:19.0 (compile), com.google.protobuf:protobuf-java:jar:2.5.0 (compile), com.jolbox:bonecp:jar:0.8.0.RELEASE (compile), com.zaxxer:HikariCP:jar:2.6.1 (compile), commons-dbcp:commons-dbcp:jar:1.4 (compile), io.dropwizard.metrics:metrics-core:jar:3.1.0 (compile), io.dropwizard.metrics:metrics-jvm:jar:3.1.0 (compile), io.dropwizard.metrics:metrics-json:jar:3.1.0 (compile), javolution:javolution:jar:5.5.1 (compile), org.antlr:antlr-runtime:jar:3.5.2 (compile), org.apache.commons:commons-lang3:jar:3.2 (compile), org.apache.derby:derby:jar:10.10.2.0 (compile), org.apache.hadoop:hadoop-common:jar:3.1.0 (compile?),
[jira] [Updated] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Haindrich updated HIVE-21001: Description: CLEAR LIBRARY CACHE > Upgrade to calcite-1.18 > --- > > Key: HIVE-21001 > URL: https://issues.apache.org/jira/browse/HIVE-21001 > Project: Hive > Issue Type: Improvement >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich >Priority: Major > Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch, > HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch, > HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch, > HIVE-21001.07.patch, HIVE-21001.08.patch > > > CLEAR LIBRARY CACHE -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Haindrich updated HIVE-21001: Attachment: HIVE-21001.08.patch > Upgrade to calcite-1.18 > --- > > Key: HIVE-21001 > URL: https://issues.apache.org/jira/browse/HIVE-21001 > Project: Hive > Issue Type: Improvement >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich >Priority: Major > Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch, > HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch, > HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch, > HIVE-21001.07.patch, HIVE-21001.08.patch, HIVE-21001.08.patch > > > CLEAR LIBRARY CACHE -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744335#comment-16744335 ] Zoltan Haindrich commented on HIVE-21001: - thank you [~jcamachorodriguez], great idea! > Upgrade to calcite-1.18 > --- > > Key: HIVE-21001 > URL: https://issues.apache.org/jira/browse/HIVE-21001 > Project: Hive > Issue Type: Improvement >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich >Priority: Major > Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch, > HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch, > HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch, > HIVE-21001.07.patch, HIVE-21001.08.patch > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Haindrich updated HIVE-21001: Attachment: HIVE-21001.08.patch > Upgrade to calcite-1.18 > --- > > Key: HIVE-21001 > URL: https://issues.apache.org/jira/browse/HIVE-21001 > Project: Hive > Issue Type: Improvement >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich >Priority: Major > Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch, > HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch, > HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch, > HIVE-21001.07.patch, HIVE-21001.08.patch > > > CLEAR LIBRARY CACHE -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21056) Make CompactionInfo extend CompactionInfoStruct
[ https://issues.apache.org/jira/browse/HIVE-21056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jaume M updated HIVE-21056: --- Attachment: HIVE-21056.1.patch Status: Patch Available (was: Open) > Make CompactionInfo extend CompactionInfoStruct > --- > > Key: HIVE-21056 > URL: https://issues.apache.org/jira/browse/HIVE-21056 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Jaume M >Assignee: Jaume M >Priority: Major > Attachments: HIVE-21056.1.patch > > > CompactionInfo is serialized into CompactionInfoStruct and by doing so if new > fields are added to CompactionInfo they may not be added to the serialization > functions. Doing it this way will help prevent bugs. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21052) Make sure transactions get cleaned if they are aborted before addPartitions is called
[ https://issues.apache.org/jira/browse/HIVE-21052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744315#comment-16744315 ] Jaume M commented on HIVE-21052: The flow through the database would be the following: * Rows to TXN_COMPONENTS with operation type 'p' are added in enqueueLockWithRetry. It is not checked if this row exist in TXN_COMPONENTS but it makes sure no duplicate rows are added in a single call to enqueueLockWithRetry. Could this happen?Different calls to enqueueLockWithRetry adding the same row? * A row per table per writeId is added to TXN_COMPONENTS. * If addDynamicPartitions is called the entry in TXN_COMPONENTS is cleaned. Should it be cleaned in some other circumstance? For example when commit is called. * If the transaction is marked as aborted, the Initiator adds only one row per table to COMPACTION_QUEUE (with type 'p') independently of how many rows there are for that table in TXN_COMPONENTS (this rows must have a different writeId) * When the Cleaner sees and entry in COMPACTION_QUEUE with type 'p' for a particular table know that there's at list one entry for this table in TXN_COMPONENTS, but collects all the writeIds from TXN_COMPONENTS corresponding to the table in the entry of COMPACTION_QUEUE.. * markCleaned deletes the entries in TXN_COMPONENTS corresponding to the writeIds cleaned. Some other notes: * Hadoop23Shims.listLocatedHdfsStatusIterator is not tested since the filesystem of the tests seems to fail ensureDfs therefore is HdfsUtils.listLocatedStatusIterator. Can you review again [~ekoifman], I've updated reviewboard. > Make sure transactions get cleaned if they are aborted before addPartitions > is called > - > > Key: HIVE-21052 > URL: https://issues.apache.org/jira/browse/HIVE-21052 > Project: Hive > Issue Type: Bug > Components: Transactions >Affects Versions: 3.0.0 >Reporter: Jaume M >Assignee: Jaume M >Priority: Critical > Attachments: Aborted Txn w_Direct Write.pdf, HIVE-21052.1.patch, > HIVE-21052.2.patch, HIVE-21052.3.patch, HIVE-21052.4.patch, > HIVE-21052.5.patch, HIVE-21052.6.patch, HIVE-21052.7.patch > > > If the transaction is aborted between openTxn and addPartitions and data has > been written on the table the transaction manager will think it's an empty > transaction and no cleaning will be done. > This is currently an issue in the streaming API and in micromanaged tables. > As proposed by [~ekoifman] this can be solved by: > * Writing an entry with a special marker to TXN_COMPONENTS at openTxn and > when addPartitions is called remove this entry from TXN_COMPONENTS and add > the corresponding partition entry to TXN_COMPONENTS. > * If the cleaner finds and entry with a special marker in TXN_COMPONENTS that > specifies that a transaction was opened and it was aborted it must generate > jobs for the worker for every possible partition available. > cc [~ewohlstadter] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20707) Automatic partition management
[ https://issues.apache.org/jira/browse/HIVE-20707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744314#comment-16744314 ] Jesus Camacho Rodriguez commented on HIVE-20707: [~prasanth_j], I see there is a branch-3 patch that was never pushed. Should this be backported? It seems to fix issues such as HIVE-21072. > Automatic partition management > -- > > Key: HIVE-20707 > URL: https://issues.apache.org/jira/browse/HIVE-20707 > Project: Hive > Issue Type: New Feature >Affects Versions: 4.0.0 >Reporter: Prasanth Jayachandran >Assignee: Prasanth Jayachandran >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-20702.3.patch, HIVE-20707-branch-3.patch, > HIVE-20707.1.patch, HIVE-20707.2.patch, HIVE-20707.4.patch, > HIVE-20707.5.patch, HIVE-20707.6.patch, HIVE-20707.6.patch, HIVE-20707.7.patch > > > In current scenario, to add partitions for external tables to metastore, MSCK > REPAIR command has to be executed manually. To avoid this manual step, > external tables can be specified a table property based on which a background > metastore thread can sync partitions periodically. Tables can also be > specified with partition retention period. Any partition whose age exceeds > the retention period will be dropped automatically. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20879) Using null in a projection expression leads to CastException
[ https://issues.apache.org/jira/browse/HIVE-20879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744306#comment-16744306 ] Hive QA commented on HIVE-20879: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955124/HIVE-20879.3.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15644/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15644/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15644/ 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' 2019-01-16 17:58:13.562 + [[ -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-15644/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' 2019-01-16 17:58:13.565 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 1fff171 HIVE-21095: Show create table should not display a time zone for timestamp with local time zone (Karen Coppage via Marta Kuczora) + 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 1fff171 HIVE-21095: Show create table should not display a time zone for timestamp with local time zone (Karen Coppage via Marta Kuczora) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-01-16 17:58:14.797 + rm -rf ../yetus_PreCommit-HIVE-Build-15644 + mkdir ../yetus_PreCommit-HIVE-Build-15644 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-15644 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-15644/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 error: a/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java: does not exist in index Going to apply patch with: git apply -p1 + [[ 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/protoc8929306273878899621.exe, --version] libprotoc 2.5.0 protoc-jar: executing: [/tmp/protoc8929306273878899621.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/protoc2531296463155860462.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 41 classes. [ERROR] Failed to execute goal org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process (process-resource-bundles) on project hive
[jira] [Commented] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744302#comment-16744302 ] Hive QA commented on HIVE-21078: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955109/HIVE-21078.06.patch {color:green}SUCCESS:{color} +1 due to 8 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 15700 tests executed *Failed tests:* {noformat} org.apache.hive.jdbc.TestSSL.testMetastoreWithSSL (batchId=260) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15643/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15643/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15643/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12955109 - PreCommit-HIVE-Build > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.06.patch, HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744278#comment-16744278 ] Hive QA commented on HIVE-21078: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 42s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 7s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 2m 51s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 1m 29s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 2m 24s{color} | {color:blue} standalone-metastore/metastore-common in master has 29 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 6s{color} | {color:blue} standalone-metastore/metastore-server in master has 188 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 48s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 25s{color} | {color:blue} hcatalog/server-extensions in master has 3 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 38s{color} | {color:blue} itests/hive-unit in master has 2 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 2m 43s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 28s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 3m 23s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 2m 52s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 2m 52s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 41s{color} | {color:red} ql: The patch generated 21 new + 759 unchanged - 1 fixed = 780 total (was 760) {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 20s{color} | {color:red} itests/hive-unit: The patch generated 3 new + 771 unchanged - 0 fixed = 774 total (was 771) {color} | | {color:red}-1{color} | {color:red} whitespace {color} | {color:red} 0m 0s{color} | {color:red} The patch has 4 line(s) that end in whitespace. Use git apply --whitespace=fix <>. Refer https://git-scm.com/docs/git-apply {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 8m 45s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} metastore-common in the patch passed. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 17s{color} | {color:green} standalone-metastore_metastore-server generated 0 new + 49 unchanged - 1 fixed = 49 total (was 50) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 52s{color} | {color:green} ql in the patch passed. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 13s{color} | {color:green} server-extensions in the patch passed. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 24s{color} | {color:green} hive-unit in the patch passed. {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 45m 14s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15643/dev-s
[jira] [Commented] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744245#comment-16744245 ] Jesus Camacho Rodriguez commented on HIVE-21001: [~kgyrtkirk], maybe the CLEAR LIBRARY CACHE option would help with this? https://cwiki.apache.org/confluence/display/Hive/Hive+PreCommit+Patch+Testing > Upgrade to calcite-1.18 > --- > > Key: HIVE-21001 > URL: https://issues.apache.org/jira/browse/HIVE-21001 > Project: Hive > Issue Type: Improvement >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich >Priority: Major > Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch, > HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch, > HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch, > HIVE-21001.07.patch > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-20879) Using null in a projection expression leads to CastException
[ https://issues.apache.org/jira/browse/HIVE-20879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Lavati updated HIVE-20879: Attachment: HIVE-20879.3.patch Status: Patch Available (was: In Progress) > Using null in a projection expression leads to CastException > > > Key: HIVE-20879 > URL: https://issues.apache.org/jira/browse/HIVE-20879 > Project: Hive > Issue Type: Bug >Reporter: Zoltan Haindrich >Assignee: David Lavati >Priority: Major > Attachments: HIVE-20879.2.patch, HIVE-20879.3.patch, HIVE-20879.patch > > > repro: > {code} > create table cx1(bool0 boolean); > select NULL or bool0 from cx1; > {code} > workaround(correct type of null): > {code} > select cast(NULL as boolean) or bool0 from cx1; > {code} > exception: > {code} > 2018-11-07T07:28:39,628 ERROR [3533166f-7174-45cd-9d9e-d487038cb6e0 main] > ql.Driver: FAILED: ClassCastEx > ception > org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableVoidObjectInspector > cannot be ca > st to > org.apache.hadoop.hive.serde2.objectinspector.primitive.BooleanObjectInspector > java.lang.ClassCastException: > org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableVoidObject > Inspector cannot be cast to > org.apache.hadoop.hive.serde2.objectinspector.primitive.BooleanObjectInspect > or > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPAnd.initialize(GenericUDFOPAnd.java:56) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDF.initializeAndFoldConstants(GenericUDF.java:1 > 48) > at > org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc.newInstance(ExprNodeGenericFuncDesc.ja > va:260) > at > org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprN > odeDesc(TypeCheckProcFactory.java:1251) > at > org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckPr > ocFactory.java:1660) > at > org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:10 > 5) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-20879) Using null in a projection expression leads to CastException
[ https://issues.apache.org/jira/browse/HIVE-20879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Lavati updated HIVE-20879: Status: In Progress (was: Patch Available) > Using null in a projection expression leads to CastException > > > Key: HIVE-20879 > URL: https://issues.apache.org/jira/browse/HIVE-20879 > Project: Hive > Issue Type: Bug >Reporter: Zoltan Haindrich >Assignee: David Lavati >Priority: Major > Attachments: HIVE-20879.2.patch, HIVE-20879.patch > > > repro: > {code} > create table cx1(bool0 boolean); > select NULL or bool0 from cx1; > {code} > workaround(correct type of null): > {code} > select cast(NULL as boolean) or bool0 from cx1; > {code} > exception: > {code} > 2018-11-07T07:28:39,628 ERROR [3533166f-7174-45cd-9d9e-d487038cb6e0 main] > ql.Driver: FAILED: ClassCastEx > ception > org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableVoidObjectInspector > cannot be ca > st to > org.apache.hadoop.hive.serde2.objectinspector.primitive.BooleanObjectInspector > java.lang.ClassCastException: > org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableVoidObject > Inspector cannot be cast to > org.apache.hadoop.hive.serde2.objectinspector.primitive.BooleanObjectInspect > or > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPAnd.initialize(GenericUDFOPAnd.java:56) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDF.initializeAndFoldConstants(GenericUDF.java:1 > 48) > at > org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc.newInstance(ExprNodeGenericFuncDesc.ja > va:260) > at > org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprN > odeDesc(TypeCheckProcFactory.java:1251) > at > org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckPr > ocFactory.java:1660) > at > org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:10 > 5) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744179#comment-16744179 ] Hive QA commented on HIVE-21001: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955100/HIVE-21001.07.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 154 failed/errored test(s), 15661 tests executed *Failed tests:* {noformat} TestHiveKVResultCache - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestHiveSparkClient - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestLocalHiveSparkClient - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSmallTableCache - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkInvalidFileFormat - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkJobMonitor - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkPlan - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkSessionManagerImpl - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkTask - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkUtilities - did not produce a TEST-*.xml file (likely timed out) (batchId=319) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constprog_when_case] (batchId=63) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[fold_eq_with_case_when] (batchId=88) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[fold_to_null] (batchId=74) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[folder_predicate] (batchId=5) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[in_typecheck_char] (batchId=51) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[in_typecheck_mixed] (batchId=6) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_6] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_7] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_8] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[parquet_vectorization_6] (batchId=44) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[pcs] (batchId=53) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_join_filter] (batchId=62) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_udf_case] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[rand_partitionpruner3] (batchId=86) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamp_ints_casts] (batchId=1) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_isops_simplify] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_offcbo] (batchId=49) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_date_1] (batchId=23) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_decimal_math_funcs] (batchId=25) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_6] (batchId=29) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_casts] (batchId=89) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_math_funcs] (batchId=22) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_string_funcs] (batchId=63) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_timestamp_ints_casts] (batchId=53) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[windowing_duplicate] (batchId=34) org.apache.hadoop.hive.cli.TestMiniDruidCliDriver.testCliDriver[druidmini_extractTime] (batchId=195) org.apache.hadoop.hive.cli.TestMiniDruidCliDriver.testCliDriver[druidmini_floorTime] (batchId=195) org.apache.hadoop.hive.cli.TestMiniDruidCliDriver.testCliDriver[druidmini_mv] (batchId=195) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[auto_sortmerge_join_16] (batchId=174) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucketpruning1] (batchId=183) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[kryo] (batchId=170) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[lineage3] (batchId=171) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[results_cache_2] (batchId=181) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_multi] (batchId=163) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_notin] (batchId=178) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_null_agg] (batchId=178) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_case_when_1] (batchId=182) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_date_1] (batchId=164) org.apache.hadoop.hive.cli.Tes
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Attachment: HIVE-21078.06.patch Status: Patch Available (was: In Progress) This patch is exactly same as .05 but renamed for triggering ptests. > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.06.patch, HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Status: In Progress (was: Patch Available) > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744138#comment-16744138 ] Hive QA commented on HIVE-21001: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 41s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 41s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 7m 13s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 7m 41s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 39s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 33s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 7m 49s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 7m 49s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} xml {color} | {color:green} 0m 1s{color} | {color:green} The patch has no ill-formed XML file. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 7m 52s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 14s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 49m 20s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc xml compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15642/dev-support/hive-personality.sh | | git revision | master / 1fff171 | | Default Java | 1.8.0_111 | | modules | C: ql accumulo-handler hbase-handler . U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15642/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Upgrade to calcite-1.18 > --- > > Key: HIVE-21001 > URL: https://issues.apache.org/jira/browse/HIVE-21001 > Project: Hive > Issue Type: Improvement >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich >Priority: Major > Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch, > HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch, > HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch, > HIVE-21001.07.patch > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21125) Hive does not check for dependent materialized views when issuing a DROP TABLE command
[ https://issues.apache.org/jira/browse/HIVE-21125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Barnabas Maidics updated HIVE-21125: Description: Dropping a table leads to undefined behavior when that table is the source of an existing materialized view. The following behavior is observed: * Table still appears in 'show tables' despite not being in metastore * Actions on table hang and then display a "could not fetch table" error * Rebuilding any dependent materialized view has same error It seems that the root cause is the fact that users are allowed to issue a DROP TABLE command against a table even if there is a materialized view using this table at the time. This is not something I have seen other query languages permit. Repro steps: Launch these commands from any Hive 3 client: {code:java} create table footable (id int); insert into footable values (1), (2), (3); create materialized view mv_footable as select count(*) from footable; drop table footable; --These lines have unexpected behavior show tables; select * from footable; alter materialized view mv_footable rebuild;{code} was: Dropping a table leads to undefined behavior when that table is the source of an existing materialized view. The following behavior is observed: * Table still appears in 'show tables' despite not being in metastore * Actions on table hang and then display a "could not fetch table" error * Rebuilding any dependent materialized view has same error It seems that the root cause is the fact that users are allowed to issue a DROP TABLE command against a table even if there is a materialized view using this table at the time. This is not something I have seen other query languages permit. Repro steps: Launch these commands from any Hive 3 client: {code:java} create table footable (id int); insert into footable values (1), (2), (3); create materialized view mv_footable as select count(*) from footable; drop table footable; --These lines have unexpected behavior show tables; select * from footable; alter materialized view mv_footable rebuild;{code} > Hive does not check for dependent materialized views when issuing a DROP > TABLE command > -- > > Key: HIVE-21125 > URL: https://issues.apache.org/jira/browse/HIVE-21125 > Project: Hive > Issue Type: Bug > Components: Materialized views >Affects Versions: 3.1.0 >Reporter: Taylor Cox >Priority: Major > > Dropping a table leads to undefined behavior when that table is the source of > an existing materialized view. The following behavior is observed: > > * Table still appears in 'show tables' despite not being in metastore > * Actions on table hang and then display a "could not fetch table" error > * Rebuilding any dependent materialized view has same error > It seems that the root cause is the fact that users are allowed to issue a > DROP TABLE command against a table even if there is a materialized view using > this table at the time. This is not something I have seen other query > languages permit. > Repro steps: Launch these commands from any Hive 3 client: > {code:java} > create table footable (id int); insert into footable values (1), (2), (3); > create materialized view mv_footable as select count(*) from footable; > drop table footable; > --These lines have unexpected behavior > show tables; > select * from footable; > alter materialized view mv_footable rebuild;{code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21001) Upgrade to calcite-1.18
[ https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Haindrich updated HIVE-21001: Attachment: HIVE-21001.07.patch > Upgrade to calcite-1.18 > --- > > Key: HIVE-21001 > URL: https://issues.apache.org/jira/browse/HIVE-21001 > Project: Hive > Issue Type: Improvement >Reporter: Zoltan Haindrich >Assignee: Zoltan Haindrich >Priority: Major > Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch, > HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch, > HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch, > HIVE-21001.07.patch > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Comment Edited] (HIVE-21072) NPE when running partitioned CTAS statements
[ https://issues.apache.org/jira/browse/HIVE-21072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744000#comment-16744000 ] Barnabas Maidics edited comment on HIVE-21072 at 1/16/19 12:53 PM: --- [~jcamachorodriguez], yes that patch you referred fixes this issue. was (Author: b.maidics): [~jcamachorodriguez], yes, that patch you referred fixes this issue. > NPE when running partitioned CTAS statements > > > Key: HIVE-21072 > URL: https://issues.apache.org/jira/browse/HIVE-21072 > Project: Hive > Issue Type: Bug >Reporter: Liang-Chi Hsieh >Priority: Major > Labels: pull-request-available > > HIVE-20241 adds support of partitioned CTAS statements: > {code:sql} > CREATE TABLE partition_ctas_1 PARTITIONED BY (key) AS > SELECT value, key FROM src where key > 200 and key < 300;{code} > > However, I've tried this feature by checking out latest branch-3, and > encountered NPE: > {code:java} > hive> CREATE TABLE t PARTITIONED BY (part) AS SELECT 1 as id, "a" as part; > FAILED: NullPointerException null > {code} > I also ran the query test partition_ctas.q. The test passes when using > TestMiniLlapLocalCliDriver, but when I go to test it with TestCliDriver > manually, it also throws NullPointerException: > {code:java} > 2018-12-25T05:58:22,221 ERROR [a96009a7-3dda-4d95-9536-e2e16d976856 main] > ql.Driver: FAILED: NullPointerException null > java.lang.NullPointerException > at > org.apache.hadoop.hive.ql.optimizer.GenMapRedUtils.usePartitionColumns(GenMapRedUtils.java:2103) > at > org.apache.hadoop.hive.ql.optimizer.GenMapRedUtils.createMRWorkForMergingFiles(GenMapRedUtils.java:1323) > at > org.apache.hadoop.hive.ql.optimizer.GenMRFileSink1.process(GenMRFileSink1.java:113) > at > org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:105) > at > org.apache.hadoop.hive.ql.parse.GenMapRedWalker.walk(GenMapRedWalker.java:54) > at > org.apache.hadoop.hive.ql.parse.GenMapRedWalker.walk(GenMapRedWalker.java:65) > at > org.apache.hadoop.hive.ql.parse.GenMapRedWalker.walk(GenMapRedWalker.java:65) > at > org.apache.hadoop.hive.ql.parse.GenMapRedWalker.walk(GenMapRedWalker.java:65) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:120) > at > org.apache.hadoop.hive.ql.parse.MapReduceCompiler.generateTaskTree(MapReduceCompiler.java:323) > at > org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(TaskCompiler.java:244) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:12503) > at > org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:357) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:285) > at > org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:166) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:285) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:664) > at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1854) > at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1801) > at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1796) > at > org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126) > at > org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:214) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:188) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:402) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21072) NPE when running partitioned CTAS statements
[ https://issues.apache.org/jira/browse/HIVE-21072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744000#comment-16744000 ] Barnabas Maidics commented on HIVE-21072: - [~jcamachorodriguez], yes, that patch you referred fixes this issue. > NPE when running partitioned CTAS statements > > > Key: HIVE-21072 > URL: https://issues.apache.org/jira/browse/HIVE-21072 > Project: Hive > Issue Type: Bug >Reporter: Liang-Chi Hsieh >Priority: Major > Labels: pull-request-available > > HIVE-20241 adds support of partitioned CTAS statements: > {code:sql} > CREATE TABLE partition_ctas_1 PARTITIONED BY (key) AS > SELECT value, key FROM src where key > 200 and key < 300;{code} > > However, I've tried this feature by checking out latest branch-3, and > encountered NPE: > {code:java} > hive> CREATE TABLE t PARTITIONED BY (part) AS SELECT 1 as id, "a" as part; > FAILED: NullPointerException null > {code} > I also ran the query test partition_ctas.q. The test passes when using > TestMiniLlapLocalCliDriver, but when I go to test it with TestCliDriver > manually, it also throws NullPointerException: > {code:java} > 2018-12-25T05:58:22,221 ERROR [a96009a7-3dda-4d95-9536-e2e16d976856 main] > ql.Driver: FAILED: NullPointerException null > java.lang.NullPointerException > at > org.apache.hadoop.hive.ql.optimizer.GenMapRedUtils.usePartitionColumns(GenMapRedUtils.java:2103) > at > org.apache.hadoop.hive.ql.optimizer.GenMapRedUtils.createMRWorkForMergingFiles(GenMapRedUtils.java:1323) > at > org.apache.hadoop.hive.ql.optimizer.GenMRFileSink1.process(GenMRFileSink1.java:113) > at > org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:105) > at > org.apache.hadoop.hive.ql.parse.GenMapRedWalker.walk(GenMapRedWalker.java:54) > at > org.apache.hadoop.hive.ql.parse.GenMapRedWalker.walk(GenMapRedWalker.java:65) > at > org.apache.hadoop.hive.ql.parse.GenMapRedWalker.walk(GenMapRedWalker.java:65) > at > org.apache.hadoop.hive.ql.parse.GenMapRedWalker.walk(GenMapRedWalker.java:65) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:120) > at > org.apache.hadoop.hive.ql.parse.MapReduceCompiler.generateTaskTree(MapReduceCompiler.java:323) > at > org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(TaskCompiler.java:244) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:12503) > at > org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:357) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:285) > at > org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:166) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:285) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:664) > at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1854) > at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1801) > at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1796) > at > org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126) > at > org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:214) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:188) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:402) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21126) Allow session level queries in LlapBaseInputFormat#getSplits() before actual get_splits() call
[ https://issues.apache.org/jira/browse/HIVE-21126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743995#comment-16743995 ] Hive QA commented on HIVE-21126: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955072/HIVE-21126.3.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 15694 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15641/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15641/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15641/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12955072 - PreCommit-HIVE-Build > Allow session level queries in LlapBaseInputFormat#getSplits() before actual > get_splits() call > -- > > Key: HIVE-21126 > URL: https://issues.apache.org/jira/browse/HIVE-21126 > Project: Hive > Issue Type: Improvement > Components: llap >Affects Versions: 3.1.1 >Reporter: Shubham Chaurasia >Assignee: Shubham Chaurasia >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21126.1.patch, HIVE-21126.2.patch, > HIVE-21126.3.patch > > > Facilitate execution of session level queries before \{{select get_splits()}} > call. This will allow us to set params like \{{tez.grouping.split-count}} > which can be taken into consideration while splits calculation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21126) Allow session level queries in LlapBaseInputFormat#getSplits() before actual get_splits() call
[ https://issues.apache.org/jira/browse/HIVE-21126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743940#comment-16743940 ] Hive QA commented on HIVE-21126: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 50s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 17s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 11s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 0m 24s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 11s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 16s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 16s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 16s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 9s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 0m 32s{color} | {color:red} llap-ext-client generated 1 new + 0 unchanged - 0 fixed = 1 total (was 0) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 11s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 12s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 10m 52s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | FindBugs | module:llap-ext-client | | | org.apache.hadoop.hive.llap.LlapBaseInputFormat.getSplits(JobConf, int) passes a nonconstant String to an execute or addBatch method on an SQL statement At LlapBaseInputFormat.java:String to an execute or addBatch method on an SQL statement At LlapBaseInputFormat.java:[line 279] | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15641/dev-support/hive-personality.sh | | git revision | master / 1fff171 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-15641/yetus/new-findbugs-llap-ext-client.html | | modules | C: llap-ext-client U: llap-ext-client | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15641/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Allow session level queries in LlapBaseInputFormat#getSplits() before actual > get_splits() call > -- > > Key: HIVE-21126 > URL: https://issues.apache.org/jira/browse/HIVE-21126 > Project: Hive > Issue Type: Improvement > Components: llap >Affects Versions: 3.1.1 >Reporter: Shubham Chaurasia >Assignee: Shubham Chaurasia >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21126.1.patch, HIVE-21126.2.patch, > HIVE-21126.3.patch > > > Facilitate execution of session level queries before \{{select get_splits()}} > call. This will allow us to set params like \{{tez.grouping.split-count}} > which can be taken into consideration while splits calculation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21099) Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles
[ https://issues.apache.org/jira/browse/HIVE-21099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743896#comment-16743896 ] Hive QA commented on HIVE-21099: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955062/HIVE.21099.04.PATCH {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 15694 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15639/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15639/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15639/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12955062 - PreCommit-HIVE-Build > Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles > --- > > Key: HIVE-21099 > URL: https://issues.apache.org/jira/browse/HIVE-21099 > Project: Hive > Issue Type: Improvement > Components: Query Planning >Affects Versions: 3.0.0, 4.0.0 >Reporter: Mani M >Assignee: Mani M >Priority: Minor > Labels: logging, newbie, noob > Attachments: HIVE.21099.02.patch, HIVE.21099.03.patch, > HIVE.21099.04.PATCH, HIVE.21099.04.PATCH, HIVE.21099.patch > > > [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/plan/ConditionalResolverMergeFiles.java]#L193 > > {code:java} > } catch (IOException e){ > e.printStackTrace(); > } > {code} > This is inline with the HIVE-20159 to print the error using the SLF4J. in > Method getTasks > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marta Kuczora updated HIVE-21095: - Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch Available) > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Affects Versions: 3.0.0 >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marta Kuczora updated HIVE-21095: - Affects Version/s: 3.0.0 > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Affects Versions: 3.0.0 >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743894#comment-16743894 ] Marta Kuczora commented on HIVE-21095: -- Pushed to master. Thanks again [~klcopp] for the patch. > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21126) Allow session level queries in LlapBaseInputFormat#getSplits() before actual get_splits() call
[ https://issues.apache.org/jira/browse/HIVE-21126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shubham Chaurasia updated HIVE-21126: - Attachment: HIVE-21126.3.patch > Allow session level queries in LlapBaseInputFormat#getSplits() before actual > get_splits() call > -- > > Key: HIVE-21126 > URL: https://issues.apache.org/jira/browse/HIVE-21126 > Project: Hive > Issue Type: Improvement > Components: llap >Affects Versions: 3.1.1 >Reporter: Shubham Chaurasia >Assignee: Shubham Chaurasia >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21126.1.patch, HIVE-21126.2.patch, > HIVE-21126.3.patch > > > Facilitate execution of session level queries before \{{select get_splits()}} > call. This will allow us to set params like \{{tez.grouping.split-count}} > which can be taken into consideration while splits calculation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21099) Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles
[ https://issues.apache.org/jira/browse/HIVE-21099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743843#comment-16743843 ] Hive QA commented on HIVE-21099: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 38s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 2s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 33s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 40s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 53s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 19s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 0s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 0s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 36s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 1s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 3m 49s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 52s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 22m 13s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15639/dev-support/hive-personality.sh | | git revision | master / fd3498b | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15639/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles > --- > > Key: HIVE-21099 > URL: https://issues.apache.org/jira/browse/HIVE-21099 > Project: Hive > Issue Type: Improvement > Components: Query Planning >Affects Versions: 3.0.0, 4.0.0 >Reporter: Mani M >Assignee: Mani M >Priority: Minor > Labels: logging, newbie, noob > Attachments: HIVE.21099.02.patch, HIVE.21099.03.patch, > HIVE.21099.04.PATCH, HIVE.21099.04.PATCH, HIVE.21099.patch > > > [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/plan/ConditionalResolverMergeFiles.java]#L193 > > {code:java} > } catch (IOException e){ > e.printStackTrace(); > } > {code} > This is inline with the HIVE-20159 to print the error using the SLF4J. in > Method getTasks > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Attachment: HIVE-21078.sameas.05.patch Status: Patch Available (was: In Progress) The test TestTriggersTezSessionPoolManager, which failed in last ptest run because of timeout is passing locally for me. The same test failed for [https://builds.apache.org/job/PreCommit-HIVE-Build/15631.] So re-submitting the same patch to trigger another ptest run. > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch, > HIVE-21078.sameas.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21016) Duplicate column name in GROUP BY statement causing Vertex failures
[ https://issues.apache.org/jira/browse/HIVE-21016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743828#comment-16743828 ] Mani M commented on HIVE-21016: --- HI [~pvary] Is it correct to put the validation check before this line [https://github.com/apache/hive/blob/f37c5de6c32b9395d1b34fa3c02ed06d1bfbf6eb/ql/src/java/org/apache/hadoop/hive/ql/optimizer/GroupByOptimizer.java#L359] > Duplicate column name in GROUP BY statement causing Vertex failures > --- > > Key: HIVE-21016 > URL: https://issues.apache.org/jira/browse/HIVE-21016 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 1.2.1 >Reporter: Bjorn Olsen >Priority: Major > > Hive queries fail with "Vertex failure" messages when the user submits a > query containing duplicate GROUP BY columns. The Hive query parser should > detect and reject this scenario with a meaningful error message, rather than > executing the query and failing with an obfuscated message. For complex > queries this can result in a lot of debugging effort, whereas a simple error > message could have saved some time. > To repeat the issue, choose any table and perform a GROUP BY with a duplicate > column name. > {{For example:}} > select count( * ), party_id from party {{group by party_id, party_id;}} > Note the duplicate column in the GROUP BY. > This will fail with messages similar to below: > Caused by: java.lang.RuntimeException: > org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while > processing vector batch (tag=0) ffb9-5fb1-3024-922a-10cc313a7c171 > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecordVector(ReduceRecordSource.java:390) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:232) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.run(ReduceRecordProcessor.java:266) > at > org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:150) > ... 14 more > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime > Error while processing vector batch (tag=0) > ffb9-5fb1-3024-922a-10cc313a7c171 > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.processVectorGroup(ReduceRecordSource.java:454) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecordVector(ReduceRecordSource.java:381) > ... 17 more > *Caused by: java.lang.ClassCastException: > org.apache.hadoop.hive.ql.exec.vector.LongColumnVector cannot be cast to > org.apache.hadoop.hive.ql.exec.vector.BytesColumnVector* -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Bapat updated HIVE-21078: -- Status: In Progress (was: Patch Available) > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21126) Allow session level queries in LlapBaseInputFormat#getSplits() before actual get_splits() call
[ https://issues.apache.org/jira/browse/HIVE-21126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743823#comment-16743823 ] Hive QA commented on HIVE-21126: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955053/HIVE-21126.2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 15694 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mapjoin_memcheck] (batchId=45) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15638/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15638/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15638/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12955053 - PreCommit-HIVE-Build > Allow session level queries in LlapBaseInputFormat#getSplits() before actual > get_splits() call > -- > > Key: HIVE-21126 > URL: https://issues.apache.org/jira/browse/HIVE-21126 > Project: Hive > Issue Type: Improvement > Components: llap >Affects Versions: 3.1.1 >Reporter: Shubham Chaurasia >Assignee: Shubham Chaurasia >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21126.1.patch, HIVE-21126.2.patch > > > Facilitate execution of session level queries before \{{select get_splits()}} > call. This will allow us to set params like \{{tez.grouping.split-count}} > which can be taken into consideration while splits calculation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20925) test
[ https://issues.apache.org/jira/browse/HIVE-20925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743808#comment-16743808 ] Mani M commented on HIVE-20925: --- HI [~sudarshan.bhide] Can I close this issue as no information available. > test > > > Key: HIVE-20925 > URL: https://issues.apache.org/jira/browse/HIVE-20925 > Project: Hive > Issue Type: Bug >Reporter: Sudarshan Bhide >Priority: Minor > Labels: Gamma > > test -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-2722) GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be better
[ https://issues.apache.org/jira/browse/HIVE-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743806#comment-16743806 ] Mani M commented on HIVE-2722: -- HI [~ashutoshc], [~pvary] Recent changes were gone to the same file (ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFUtils.java)- as available in patch, under HIVE-20204, whether still this ticket need to be addressed. > GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be better > > > Key: HIVE-2722 > URL: https://issues.apache.org/jira/browse/HIVE-2722 > Project: Hive > Issue Type: Improvement > Components: UDF >Affects Versions: 0.8.0, 0.9.0 > Environment: Linux zongren-VirtualBox 3.0.0-14-generic #23-Ubuntu SMP > Mon Nov 21 20:34:47 UTC 2011 i686 i686 i386 GNU/Linux > java version "1.6.0_25" > hadoop-0.20.2-cdh3u0 > hive-0.7.0-cdh3u0 >Reporter: caofangkun >Priority: Minor > Labels: udf > Attachments: HIVE-2722.patch, udf_instr_1.q > > Original Estimate: 1h > Remaining Estimate: 1h > > select instr("中文字符测试-第一行","-") from testTable limit 1; > result:19 (one Chinese Character was considered as 3 Unicode bits) > select substr("中文字符测试-第一行",1,2) from testTable limit 1; > result: "中文" (one Chinese Character was considered as 1 Unicode Unit ) > instr should considered one chinese character as one Unicode Unit too. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21099) Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles
[ https://issues.apache.org/jira/browse/HIVE-21099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mani M updated HIVE-21099: -- Status: Patch Available (was: In Progress) Applied the same patch to avoid the failure due to falky tests > Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles > --- > > Key: HIVE-21099 > URL: https://issues.apache.org/jira/browse/HIVE-21099 > Project: Hive > Issue Type: Improvement > Components: Query Planning >Affects Versions: 3.0.0, 4.0.0 >Reporter: Mani M >Assignee: Mani M >Priority: Minor > Labels: logging, newbie, noob > Attachments: HIVE.21099.02.patch, HIVE.21099.03.patch, > HIVE.21099.04.PATCH, HIVE.21099.04.PATCH, HIVE.21099.patch > > > [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/plan/ConditionalResolverMergeFiles.java]#L193 > > {code:java} > } catch (IOException e){ > e.printStackTrace(); > } > {code} > This is inline with the HIVE-20159 to print the error using the SLF4J. in > Method getTasks > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21099) Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles
[ https://issues.apache.org/jira/browse/HIVE-21099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mani M updated HIVE-21099: -- Attachment: HIVE.21099.04.PATCH > Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles > --- > > Key: HIVE-21099 > URL: https://issues.apache.org/jira/browse/HIVE-21099 > Project: Hive > Issue Type: Improvement > Components: Query Planning >Affects Versions: 3.0.0, 4.0.0 >Reporter: Mani M >Assignee: Mani M >Priority: Minor > Labels: logging, newbie, noob > Attachments: HIVE.21099.02.patch, HIVE.21099.03.patch, > HIVE.21099.04.PATCH, HIVE.21099.04.PATCH, HIVE.21099.patch > > > [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/plan/ConditionalResolverMergeFiles.java]#L193 > > {code:java} > } catch (IOException e){ > e.printStackTrace(); > } > {code} > This is inline with the HIVE-20159 to print the error using the SLF4J. in > Method getTasks > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21099) Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles
[ https://issues.apache.org/jira/browse/HIVE-21099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mani M updated HIVE-21099: -- Attachment: HIVE.21099.04.PATCH > Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles > --- > > Key: HIVE-21099 > URL: https://issues.apache.org/jira/browse/HIVE-21099 > Project: Hive > Issue Type: Improvement > Components: Query Planning >Affects Versions: 3.0.0, 4.0.0 >Reporter: Mani M >Assignee: Mani M >Priority: Minor > Labels: logging, newbie, noob > Attachments: HIVE.21099.02.patch, HIVE.21099.03.patch, > HIVE.21099.04.PATCH, HIVE.21099.04.PATCH, HIVE.21099.patch > > > [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/plan/ConditionalResolverMergeFiles.java]#L193 > > {code:java} > } catch (IOException e){ > e.printStackTrace(); > } > {code} > This is inline with the HIVE-20159 to print the error using the SLF4J. in > Method getTasks > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21099) Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles
[ https://issues.apache.org/jira/browse/HIVE-21099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mani M updated HIVE-21099: -- Status: In Progress (was: Patch Available) Fixing again to remove to avoid the falky tests > Do Not Print StackTraces to STDERR in ConditionalResolverMergeFiles > --- > > Key: HIVE-21099 > URL: https://issues.apache.org/jira/browse/HIVE-21099 > Project: Hive > Issue Type: Improvement > Components: Query Planning >Affects Versions: 3.0.0, 4.0.0 >Reporter: Mani M >Assignee: Mani M >Priority: Minor > Labels: logging, newbie, noob > Attachments: HIVE.21099.02.patch, HIVE.21099.03.patch, > HIVE.21099.patch > > > [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/plan/ConditionalResolverMergeFiles.java]#L193 > > {code:java} > } catch (IOException e){ > e.printStackTrace(); > } > {code} > This is inline with the HIVE-20159 to print the error using the SLF4J. in > Method getTasks > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (HIVE-21127) desc table Command optimize
[ https://issues.apache.org/jira/browse/HIVE-21127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ann reassigned HIVE-21127: -- > desc table Command optimize > --- > > Key: HIVE-21127 > URL: https://issues.apache.org/jira/browse/HIVE-21127 > Project: Hive > Issue Type: Improvement > Components: Hive >Affects Versions: 2.3.2 >Reporter: ann >Assignee: ann >Priority: Critical > Attachments: desc.patch > > > when execute command : desc table \{table} > if the \{table} is a partitioned table which has many partitions, it will > read the partitions from metastore, and load very slow. > desc table command does not show partitions' stats, so it not need to load > these information. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21104) PTF with nested structure throws ClassCastException
[ https://issues.apache.org/jira/browse/HIVE-21104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajesh Balamohan updated HIVE-21104: Resolution: Fixed Hadoop Flags: Reviewed Fix Version/s: 4.0.0 Status: Resolved (was: Patch Available) > PTF with nested structure throws ClassCastException > --- > > Key: HIVE-21104 > URL: https://issues.apache.org/jira/browse/HIVE-21104 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 2.3.0, 3.0.0, 4.0.0 >Reporter: Rajesh Balamohan >Assignee: Rajesh Balamohan >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-21104.1.patch > > > {noformat} > DROP TABLE IF EXISTS dummy; > CREATE TABLE dummy (i int); > INSERT INTO TABLE dummy VALUES (1); > DROP TABLE IF EXISTS struct_table_example; > CREATE TABLE struct_table_example (a int, s1 struct f3: int, f4: int> ) STORED AS ORC; > INSERT INTO TABLE struct_table_example SELECT 1, named_struct('f1', false, > 'f2', 'test', 'f3', 3, 'f4', 4) FROM dummy; > select s1.f1, s1.f2, rank() over (partition by s1.f2 order by s1.f4) from > struct_table_example; > {noformat} > This would throw the following error > {noformat} > Caused by: java.lang.RuntimeException: > org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while > processing row (tag=0) > {"key":{"reducesinkkey0":"test","reducesinkkey1":4},"value":{"_col1":{"f1":false,"f2":"test","f3":3,"f4":4}}} > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:297) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.run(ReduceRecordProcessor.java:317) > at > org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:185) > ... 14 more > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime > Error while processing row (tag=0) > {"key":{"reducesinkkey0":"test","reducesinkkey1":4},"value":{"_col1":{"f1":false,"f2":"test","f3":3,"f4":4}}} > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:365) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:287) > ... 16 more > Caused by: java.lang.ClassCastException: > org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct cannot be cast to > org.apache.hadoop.io.IntWritable > at > org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableIntObjectInspector.getPrimitiveJavaObject(WritableIntObjectInspector.java:46) > at > org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.copyToStandardObject(ObjectInspectorUtils.java:412) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRank.copyToStandardObject(GenericUDAFRank.java:219) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRank$GenericUDAFAbstractRankEvaluator.iterate(GenericUDAFRank.java:154) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFEvaluator.aggregate(GenericUDAFEvaluator.java:192) > at > org.apache.hadoop.hive.ql.udf.ptf.WindowingTableFunction.processRow(WindowingTableFunction.java:407) > at > org.apache.hadoop.hive.ql.exec.PTFOperator$PTFInvocation.processRow(PTFOperator.java:325) > at > org.apache.hadoop.hive.ql.exec.PTFOperator.process(PTFOperator.java:139) > at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:897) > at > org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:95) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:356) > ... 17 more > ]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 > killedTasks:0, Vertex vertex_1546783872011_263870_1_01 [Reducer 2] > killed/failed due to:OWN_TASK_FAILURE]DAG did not succeed due to > VERTEX_FAILURE. failedVertices:1 killedVertices:0 > at org.apache.hadoop.hive.ql.exec.tez.TezTask.execute(TezTask.java:196) > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:199) > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100) > at org.apache.hadoop.hive.ql.exec.TaskRunner.run(TaskRunner.java:79) > (state=08S01,code=2) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21095) 'Show create table' should not display a time zone for timestamp with local time zone
[ https://issues.apache.org/jira/browse/HIVE-21095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743780#comment-16743780 ] Karen Coppage commented on HIVE-21095: -- Thanks for the reviews, [~kuczoram] and [~jcamachorodriguez] > 'Show create table' should not display a time zone for timestamp with local > time zone > - > > Key: HIVE-21095 > URL: https://issues.apache.org/jira/browse/HIVE-21095 > Project: Hive > Issue Type: Improvement >Reporter: Karen Coppage >Assignee: Karen Coppage >Priority: Major > Attachments: HIVE-21095.1.patch, HIVE-21095.2.patch, > HIVE-21095.2.patch, HIVE-21095.2.patch, HIVE-21095.3.patch, HIVE-21095.4.patch > > > SHOW CREATE TABLE shows the time zone that the table was created in (if it > contains a TIMESTAMPTZ column). This is also misleading, since it has nothing > to do with the actual data or server or user time zone. > e.g. > {code:java} > hive> set time zone America/Los_Angeles; > hive> create table text_local (ts timestamp with local time zone) stored as > textfile; > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone('America/Los_Angeles')) > {code} > should be: > {code:java} > hive> show create table text_local; > CREATE TABLE `text_local`( > `ts` timestamp with local time zone) > {code} > This was discussed in the community doc [Consistent timestamp types in Hadoop > SQL > engines|https://docs.google.com/document/d/1gNRww9mZJcHvUDCXklzjFEQGpefsuR_akCDfWsdE35Q/edit?usp=sharing] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21126) Allow session level queries in LlapBaseInputFormat#getSplits() before actual get_splits() call
[ https://issues.apache.org/jira/browse/HIVE-21126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743779#comment-16743779 ] Hive QA commented on HIVE-21126: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 20s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 16s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 12s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 0m 26s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 11s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 17s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 16s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 16s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 10s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 0m 30s{color} | {color:red} llap-ext-client generated 1 new + 0 unchanged - 0 fixed = 1 total (was 0) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 11s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 11m 30s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | FindBugs | module:llap-ext-client | | | org.apache.hadoop.hive.llap.LlapBaseInputFormat.getSplits(JobConf, int) passes a nonconstant String to an execute or addBatch method on an SQL statement At LlapBaseInputFormat.java:String to an execute or addBatch method on an SQL statement At LlapBaseInputFormat.java:[line 279] | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15638/dev-support/hive-personality.sh | | git revision | master / a3aa074 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-15638/yetus/new-findbugs-llap-ext-client.html | | modules | C: llap-ext-client U: llap-ext-client | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15638/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Allow session level queries in LlapBaseInputFormat#getSplits() before actual > get_splits() call > -- > > Key: HIVE-21126 > URL: https://issues.apache.org/jira/browse/HIVE-21126 > Project: Hive > Issue Type: Improvement > Components: llap >Affects Versions: 3.1.1 >Reporter: Shubham Chaurasia >Assignee: Shubham Chaurasia >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21126.1.patch, HIVE-21126.2.patch > > > Facilitate execution of session level queries before \{{select get_splits()}} > call. This will allow us to set params like \{{tez.grouping.split-count}} > which can be taken into consideration while splits calculation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21104) PTF with nested structure throws ClassCastException
[ https://issues.apache.org/jira/browse/HIVE-21104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743773#comment-16743773 ] Rajesh Balamohan commented on HIVE-21104: - Thanks [~gopalv]. I will commit it shortly. > PTF with nested structure throws ClassCastException > --- > > Key: HIVE-21104 > URL: https://issues.apache.org/jira/browse/HIVE-21104 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 2.3.0, 3.0.0, 4.0.0 >Reporter: Rajesh Balamohan >Assignee: Rajesh Balamohan >Priority: Major > Attachments: HIVE-21104.1.patch > > > {noformat} > DROP TABLE IF EXISTS dummy; > CREATE TABLE dummy (i int); > INSERT INTO TABLE dummy VALUES (1); > DROP TABLE IF EXISTS struct_table_example; > CREATE TABLE struct_table_example (a int, s1 struct f3: int, f4: int> ) STORED AS ORC; > INSERT INTO TABLE struct_table_example SELECT 1, named_struct('f1', false, > 'f2', 'test', 'f3', 3, 'f4', 4) FROM dummy; > select s1.f1, s1.f2, rank() over (partition by s1.f2 order by s1.f4) from > struct_table_example; > {noformat} > This would throw the following error > {noformat} > Caused by: java.lang.RuntimeException: > org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while > processing row (tag=0) > {"key":{"reducesinkkey0":"test","reducesinkkey1":4},"value":{"_col1":{"f1":false,"f2":"test","f3":3,"f4":4}}} > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:297) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.run(ReduceRecordProcessor.java:317) > at > org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:185) > ... 14 more > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime > Error while processing row (tag=0) > {"key":{"reducesinkkey0":"test","reducesinkkey1":4},"value":{"_col1":{"f1":false,"f2":"test","f3":3,"f4":4}}} > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:365) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:287) > ... 16 more > Caused by: java.lang.ClassCastException: > org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct cannot be cast to > org.apache.hadoop.io.IntWritable > at > org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableIntObjectInspector.getPrimitiveJavaObject(WritableIntObjectInspector.java:46) > at > org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.copyToStandardObject(ObjectInspectorUtils.java:412) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRank.copyToStandardObject(GenericUDAFRank.java:219) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRank$GenericUDAFAbstractRankEvaluator.iterate(GenericUDAFRank.java:154) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFEvaluator.aggregate(GenericUDAFEvaluator.java:192) > at > org.apache.hadoop.hive.ql.udf.ptf.WindowingTableFunction.processRow(WindowingTableFunction.java:407) > at > org.apache.hadoop.hive.ql.exec.PTFOperator$PTFInvocation.processRow(PTFOperator.java:325) > at > org.apache.hadoop.hive.ql.exec.PTFOperator.process(PTFOperator.java:139) > at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:897) > at > org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:95) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:356) > ... 17 more > ]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 > killedTasks:0, Vertex vertex_1546783872011_263870_1_01 [Reducer 2] > killed/failed due to:OWN_TASK_FAILURE]DAG did not succeed due to > VERTEX_FAILURE. failedVertices:1 killedVertices:0 > at org.apache.hadoop.hive.ql.exec.tez.TezTask.execute(TezTask.java:196) > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:199) > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100) > at org.apache.hadoop.hive.ql.exec.TaskRunner.run(TaskRunner.java:79) > (state=08S01,code=2) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743762#comment-16743762 ] Hive QA commented on HIVE-21078: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955048/HIVE-21078.05.patch {color:green}SUCCESS:{color} +1 due to 8 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 7 failed/errored test(s), 15700 tests executed *Failed tests:* {noformat} org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomCreatedDynamicPartitions (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomCreatedDynamicPartitionsUnionAll (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomNonExistent (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerHighBytesRead (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerHighShuffleBytes (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerSlowQueryElapsedTime (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerSlowQueryExecutionTime (batchId=264) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15637/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15637/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15637/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 7 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12955048 - PreCommit-HIVE-Build > Replicate column and table level statistics for unpartitioned Hive tables > - > > Key: HIVE-21078 > URL: https://issues.apache.org/jira/browse/HIVE-21078 > Project: Hive > Issue Type: Sub-task >Reporter: Ashutosh Bapat >Assignee: Ashutosh Bapat >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21078.01.patch, HIVE-21078.02.patch, > HIVE-21078.03.patch, HIVE-21078.04.patch, HIVE-21078.05.patch > > > This task is for replicating column and table level statistics for > unpartitioned tables. The same for partitioned tables will be worked upon in > a separate sub-task. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21104) PTF with nested structure throws ClassCastException
[ https://issues.apache.org/jira/browse/HIVE-21104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743753#comment-16743753 ] Gopal V commented on HIVE-21104: LGTM - +1 I see that this reverts the change from HIVE-13453 {code} streamingState.rollingPart.append(row); -row = streamingState.rollingPart -.getAt(streamingState.rollingPart.size() - 1); {code} > PTF with nested structure throws ClassCastException > --- > > Key: HIVE-21104 > URL: https://issues.apache.org/jira/browse/HIVE-21104 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 2.3.0, 3.0.0, 4.0.0 >Reporter: Rajesh Balamohan >Assignee: Rajesh Balamohan >Priority: Major > Attachments: HIVE-21104.1.patch > > > {noformat} > DROP TABLE IF EXISTS dummy; > CREATE TABLE dummy (i int); > INSERT INTO TABLE dummy VALUES (1); > DROP TABLE IF EXISTS struct_table_example; > CREATE TABLE struct_table_example (a int, s1 struct f3: int, f4: int> ) STORED AS ORC; > INSERT INTO TABLE struct_table_example SELECT 1, named_struct('f1', false, > 'f2', 'test', 'f3', 3, 'f4', 4) FROM dummy; > select s1.f1, s1.f2, rank() over (partition by s1.f2 order by s1.f4) from > struct_table_example; > {noformat} > This would throw the following error > {noformat} > Caused by: java.lang.RuntimeException: > org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while > processing row (tag=0) > {"key":{"reducesinkkey0":"test","reducesinkkey1":4},"value":{"_col1":{"f1":false,"f2":"test","f3":3,"f4":4}}} > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:297) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.run(ReduceRecordProcessor.java:317) > at > org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:185) > ... 14 more > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime > Error while processing row (tag=0) > {"key":{"reducesinkkey0":"test","reducesinkkey1":4},"value":{"_col1":{"f1":false,"f2":"test","f3":3,"f4":4}}} > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:365) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:287) > ... 16 more > Caused by: java.lang.ClassCastException: > org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct cannot be cast to > org.apache.hadoop.io.IntWritable > at > org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableIntObjectInspector.getPrimitiveJavaObject(WritableIntObjectInspector.java:46) > at > org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.copyToStandardObject(ObjectInspectorUtils.java:412) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRank.copyToStandardObject(GenericUDAFRank.java:219) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRank$GenericUDAFAbstractRankEvaluator.iterate(GenericUDAFRank.java:154) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFEvaluator.aggregate(GenericUDAFEvaluator.java:192) > at > org.apache.hadoop.hive.ql.udf.ptf.WindowingTableFunction.processRow(WindowingTableFunction.java:407) > at > org.apache.hadoop.hive.ql.exec.PTFOperator$PTFInvocation.processRow(PTFOperator.java:325) > at > org.apache.hadoop.hive.ql.exec.PTFOperator.process(PTFOperator.java:139) > at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:897) > at > org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:95) > at > org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:356) > ... 17 more > ]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 > killedTasks:0, Vertex vertex_1546783872011_263870_1_01 [Reducer 2] > killed/failed due to:OWN_TASK_FAILURE]DAG did not succeed due to > VERTEX_FAILURE. failedVertices:1 killedVertices:0 > at org.apache.hadoop.hive.ql.exec.tez.TezTask.execute(TezTask.java:196) > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:199) > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100) > at org.apache.hadoop.hive.ql.exec.TaskRunner.run(TaskRunner.java:79) > (state=08S01,code=2) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21078) Replicate column and table level statistics for unpartitioned Hive tables
[ https://issues.apache.org/jira/browse/HIVE-21078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743740#comment-16743740 ] Hive QA commented on HIVE-21078: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 1s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 18s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 6m 25s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 2m 49s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 1m 26s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 2m 12s{color} | {color:blue} standalone-metastore/metastore-common in master has 29 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 2s{color} | {color:blue} standalone-metastore/metastore-server in master has 188 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 41s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 25s{color} | {color:blue} hcatalog/server-extensions in master has 3 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 37s{color} | {color:blue} itests/hive-unit in master has 2 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 2m 40s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 26s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 3m 15s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 2m 45s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 2m 45s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 42s{color} | {color:red} ql: The patch generated 21 new + 759 unchanged - 1 fixed = 780 total (was 760) {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 20s{color} | {color:red} itests/hive-unit: The patch generated 3 new + 771 unchanged - 0 fixed = 774 total (was 771) {color} | | {color:red}-1{color} | {color:red} whitespace {color} | {color:red} 0m 0s{color} | {color:red} The patch has 4 line(s) that end in whitespace. Use git apply --whitespace=fix <>. Refer https://git-scm.com/docs/git-apply {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 8m 34s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 47s{color} | {color:green} metastore-common in the patch passed. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 17s{color} | {color:green} standalone-metastore_metastore-server generated 0 new + 49 unchanged - 1 fixed = 49 total (was 50) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 52s{color} | {color:green} ql in the patch passed. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 11s{color} | {color:green} server-extensions in the patch passed. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 22s{color} | {color:green} hive-unit in the patch passed. {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 12s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 43m 6s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15637/dev-s
[jira] [Updated] (HIVE-21126) Allow session level queries in LlapBaseInputFormat#getSplits() before actual get_splits() call
[ https://issues.apache.org/jira/browse/HIVE-21126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shubham Chaurasia updated HIVE-21126: - Attachment: HIVE-21126.2.patch > Allow session level queries in LlapBaseInputFormat#getSplits() before actual > get_splits() call > -- > > Key: HIVE-21126 > URL: https://issues.apache.org/jira/browse/HIVE-21126 > Project: Hive > Issue Type: Improvement > Components: llap >Affects Versions: 3.1.1 >Reporter: Shubham Chaurasia >Assignee: Shubham Chaurasia >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21126.1.patch, HIVE-21126.2.patch > > > Facilitate execution of session level queries before \{{select get_splits()}} > call. This will allow us to set params like \{{tez.grouping.split-count}} > which can be taken into consideration while splits calculation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)