[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16389222#comment-16389222 ] Zoltan Haindrich commented on HIVE-18060: - [~osayankin] I didn't understanded why this got stuck :) Thank you [~kuczoram] for your help! +1 > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch, HIVE-18060.2.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16388960#comment-16388960 ] Hive QA commented on HIVE-18060: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12913239/HIVE-18060.2.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 21 failed/errored test(s), 13087 tests executed *Failed tests:* {noformat} TestNegativeCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=94)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16388921#comment-16388921 ] Hive QA commented on HIVE-18060: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 1s{color} | {color:blue} Findbugs executables are not available. {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 35s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 6m 29s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 56s{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:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 52s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 8s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 18s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 2s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 2s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 34s{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} javadoc {color} | {color:green} 0m 53s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:red}-1{color} | {color:red} asflicense {color} | {color:red} 0m 13s{color} | {color:red} The patch generated 49 ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 13m 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-9520/dev-support/hive-personality.sh | | git revision | master / abede8e | | Default Java | 1.8.0_111 | | asflicense | http://104.198.109.242/logs//PreCommit-HIVE-Build-9520/yetus/patch-asflicense-problems.txt | | modules | C: itests ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-9520/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch, HIVE-18060.2.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) >
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16388177#comment-16388177 ] Oleksiy Sayankin commented on HIVE-18060: - Added test with q file. > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch, HIVE-18060.2.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16387964#comment-16387964 ] Marta Kuczora commented on HIVE-18060: -- [~osayankin], that's great, I am glad I could help you! > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16387927#comment-16387927 ] Oleksiy Sayankin commented on HIVE-18060: - Hi [~kuczoram]. You understood correctly. That's exactly what I want. > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16387888#comment-16387888 ] Marta Kuczora commented on HIVE-18060: -- Hi [~osayankin], if you add these steps to updateAccessTime.q (or to a separate q file) and then run the test with the -Dtest.output.overwrite=true flag, the q.out file should be generated. {noformat} mvn test -Dtest=TestCliDriver -Dqfile=updateAccessTime.q -Dtest.output.overwrite=true {noformat} Is this what you are looking for or did I misunderstand your question? :) > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16386332#comment-16386332 ] Hive QA commented on HIVE-18060: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12897547/HIVE-18060.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 20 failed/errored test(s), 13455 tests executed *Failed tests:* {noformat} TestNegativeCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=94)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16386247#comment-16386247 ] Hive QA commented on HIVE-18060: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 0s{color} | {color:blue} Findbugs executables are not available. {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} 6m 56s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 57s{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:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 51s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 11s{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 35s{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} javadoc {color} | {color:green} 0m 51s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:red}-1{color} | {color:red} asflicense {color} | {color:red} 0m 13s{color} | {color:red} The patch generated 49 ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 13m 26s{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-9491/dev-support/hive-personality.sh | | git revision | master / 05d4719 | | Default Java | 1.8.0_111 | | asflicense | http://104.198.109.242/logs//PreCommit-HIVE-Build-9491/yetus/patch-asflicense-problems.txt | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-9491/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16386242#comment-16386242 ] Oleksiy Sayankin commented on HIVE-18060: - Well the only thing I need here is how to obtain q.out file for the test (expected output). The rest is rather simple: STR above is an ideal test-case. Do you know about that? I will appreciate your help and then add the test-case. > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16386233#comment-16386233 ] Marta Kuczora commented on HIVE-18060: -- [~osayankin], do you have plans/time to create the q test? If you don't have time, I am happy to help out. > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16386221#comment-16386221 ] Oleksiy Sayankin commented on HIVE-18060: - Hi [~kuczoram]. The issue is fixed, and we need q tests here only. > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16386215#comment-16386215 ] Oleksiy Sayankin commented on HIVE-18060: - Hi [~kuczoram]. The issue is fixed. We need an update of Hive Integration tests only. The problem is that too many of them create database in the same folder where the other one exists. > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16386204#comment-16386204 ] Marta Kuczora commented on HIVE-18060: -- Hi [~osayankin], what is the status of this patch? Is only the q test update missing or are there other pending works on this patch? Thanks and regards, Marta > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin >Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16276446#comment-16276446 ] Zoltan Haindrich commented on HIVE-18060: - [~osayankin] could you add a test for this use case? > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16251593#comment-16251593 ] Hive QA commented on HIVE-18060: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12897547/HIVE-18060.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 12 failed/errored test(s), 11383 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_sortmerge_join_2] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dbtxnmgr_showlocks] (batchId=77) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[unionDistinct_1] (batchId=146) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[columnstats_part_coltype] (batchId=163) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[insert_values_orig_table_use_metadata] (batchId=162) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[ppd_union_view] (batchId=154) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb] (batchId=156) org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testCliDriver[ct_noperm_loc] (batchId=94) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_multi] (batchId=111) org.apache.hadoop.hive.cli.control.TestDanglingQOuts.checkDanglingQOut (batchId=206) org.apache.hadoop.hive.ql.exec.tez.TestWorkloadManager.testApplyPlanQpChanges (batchId=281) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testConstraints (batchId=223) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/7802/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/7802/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-7802/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 12 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12897547 - PreCommit-HIVE-Build > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at
[jira] [Commented] (HIVE-18060) UpdateInputAccessTimeHook fails for non-current database
[ https://issues.apache.org/jira/browse/HIVE-18060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16251360#comment-16251360 ] Zoltan Haindrich commented on HIVE-18060: - [~osayankin] could you also add/extend a qtest to cover your use case? ([updateAccessTime.q|https://github.com/apache/hive/blob/master/ql/src/test/queries/clientpositive/updateAccessTime.q]) > UpdateInputAccessTimeHook fails for non-current database > > > Key: HIVE-18060 > URL: https://issues.apache.org/jira/browse/HIVE-18060 > Project: Hive > Issue Type: Bug >Reporter: Oleksiy Sayankin >Assignee: Oleksiy Sayankin > Fix For: 3.0.0 > > Attachments: HIVE-18060.1.patch > > > Steps to reproduce: > *STEP 1. Create DBs and tables* > {code} > hive> create database temp; > hive> use temp; > hive> create table test(id int); > hive> create database temp2; > hive> use temp2; > hive> create table test2(id int); > {code} > *STEP 2. Set {{hive.exec.pre.hooks}}* > {code} > hive> set > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > {code} > *STEP 3. Use {{desc}}* > {code} > hive> use temp; > hive> desc temp2.test2; > {code} > *EXPECTED RESULT* > Code works fine and shows table info > *ACTUAL RESULT* > {code} > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > test2) > org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found > test2 > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1258) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1209) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1196) > at > org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec.run(UpdateInputAccessTimeHook.java:61) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1688) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:791) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)