[ https://issues.apache.org/jira/browse/HIVE-11427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15238114#comment-15238114 ]
Hive QA commented on HIVE-11427: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12798319/HIVE-11427.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 9974 tests executed *Failed tests:* {noformat} TestJdbcWithMiniHS2 - did not produce a TEST-*.xml file org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_auto_mult_tables org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_index_bitmap3 {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7567/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7567/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-7567/ 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: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12798319 - PreCommit-HIVE-TRUNK-Build > Location of temporary table for CREATE TABLE SELECT broken by HIVE-7079 > ------------------------------------------------------------------------ > > Key: HIVE-11427 > URL: https://issues.apache.org/jira/browse/HIVE-11427 > Project: Hive > Issue Type: Bug > Reporter: Grisha Trubetskoy > Assignee: Yongzhi Chen > Attachments: HIVE-11427.1.patch > > > If a user _does not_ have HDFS write permissions to the _default_ database, > and attempts to create a table in a _private_ database to which the user > _does_ have permissions using CREATE TABLE AS SELECT from a table in the > default database, the following happens: > {code} > use default; > create table grisha.blahblah as select * from some_table; > FAILED: SemanticException 0:0 Error creating temporary folder on: > hdfs://nn.example.com/user/hive/warehouse. Error encountered near token > 'TOK_TMP_FILE’ > {code} > I've edited this issue because my initial explanation was completely bogus. A > more likely explanation is in > https://github.com/apache/hive/commit/1614314ef7bd0c3b8527ee32a434ababf7711278 > {code} > - fname = ctx.getExternalTmpPath( > + fname = ctx.getExtTmpPathRelTo( > // and then something incorrect happens in getExtTmpPathRelTo() > {code} > In any event - the bug is that the location chosen for the temporary storage > is not in the same place as the target table. It should be same as the target > table (/user/hive/warehouse/grisha.db in the above example) because this is > where presumably the user running the query would have write permissions to. -- This message was sent by Atlassian JIRA (v6.3.4#6332)