[
https://issues.apache.org/jira/browse/HIVE-9481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14310262#comment-14310262
]
Hive QA commented on HIVE-9481:
-------------------------------
{color:red}Overall{color}: -1 no tests executed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12696947/HIVE-9481.patch
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2689/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2689/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2689/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Tests exited with: ExecutionException:
org.apache.hive.ptest.execution.ssh.SSHExecutionException: RSyncResult
[localFile=/data/hive-ptest/logs/PreCommit-HIVE-TRUNK-Build-2689/succeeded/TestHBaseMinimrCliDriver,
remoteFile=/home/hiveptest/54.225.0.71-hiveptest-0/logs/, getExitCode()=12,
getException()=null, getUser()=hiveptest, getHost()=54.225.0.71,
getInstance()=0]: 'Address 54.225.0.71 maps to
ec2-54-225-0-71.compute-1.amazonaws.com, but this does not map back to the
address - POSSIBLE BREAK-IN ATTEMPT!
receiving incremental file list
./
TEST-TestHBaseMinimrCliDriver-TEST-org.apache.hadoop.hive.cli.TestHBaseMinimrCliDriver.xml
0 0% 0.00kB/s 0:00:00
4836 100% 4.61MB/s 0:00:00 (xfer#1, to-check=3/5)
hive.log
0 0% 0.00kB/s 0:00:00
50233344 24% 47.81MB/s 0:00:03
98369536 48% 46.84MB/s 0:00:02
rsync: write failed on
"/data/hive-ptest/logs/PreCommit-HIVE-TRUNK-Build-2689/succeeded/TestHBaseMinimrCliDriver/hive.log":
No space left on device (28)
rsync error: error in file IO (code 11) at receiver.c(301) [receiver=3.0.6]
rsync: connection unexpectedly closed (213 bytes received so far) [generator]
rsync error: error in rsync protocol data stream (code 12) at io.c(600)
[generator=3.0.6]
Address 54.225.0.71 maps to ec2-54-225-0-71.compute-1.amazonaws.com, but this
does not map back to the address - POSSIBLE BREAK-IN ATTEMPT!
receiving incremental file list
./
hive.log
0 0% 0.00kB/s 0:00:00
rsync: write failed on
"/data/hive-ptest/logs/PreCommit-HIVE-TRUNK-Build-2689/succeeded/TestHBaseMinimrCliDriver/hive.log":
No space left on device (28)
rsync error: error in file IO (code 11) at receiver.c(301) [receiver=3.0.6]
rsync: connection unexpectedly closed (213 bytes received so far) [generator]
rsync error: error in rsync protocol data stream (code 12) at io.c(600)
[generator=3.0.6]
Address 54.225.0.71 maps to ec2-54-225-0-71.compute-1.amazonaws.com, but this
does not map back to the address - POSSIBLE BREAK-IN ATTEMPT!
receiving incremental file list
./
hive.log
0 0% 0.00kB/s 0:00:00
rsync: write failed on
"/data/hive-ptest/logs/PreCommit-HIVE-TRUNK-Build-2689/succeeded/TestHBaseMinimrCliDriver/hive.log":
No space left on device (28)
rsync error: error in file IO (code 11) at receiver.c(301) [receiver=3.0.6]
rsync: connection unexpectedly closed (213 bytes received so far) [generator]
rsync error: error in rsync protocol data stream (code 12) at io.c(600)
[generator=3.0.6]
Address 54.225.0.71 maps to ec2-54-225-0-71.compute-1.amazonaws.com, but this
does not map back to the address - POSSIBLE BREAK-IN ATTEMPT!
receiving incremental file list
./
hive.log
0 0% 0.00kB/s 0:00:00
rsync: write failed on
"/data/hive-ptest/logs/PreCommit-HIVE-TRUNK-Build-2689/succeeded/TestHBaseMinimrCliDriver/hive.log":
No space left on device (28)
rsync error: error in file IO (code 11) at receiver.c(301) [receiver=3.0.6]
rsync: connection unexpectedly closed (213 bytes received so far) [generator]
rsync error: error in rsync protocol data stream (code 12) at io.c(600)
[generator=3.0.6]
Address 54.225.0.71 maps to ec2-54-225-0-71.compute-1.amazonaws.com, but this
does not map back to the address - POSSIBLE BREAK-IN ATTEMPT!
receiving incremental file list
./
hive.log
0 0% 0.00kB/s 0:00:00
rsync: write failed on
"/data/hive-ptest/logs/PreCommit-HIVE-TRUNK-Build-2689/succeeded/TestHBaseMinimrCliDriver/hive.log":
No space left on device (28)
rsync error: error in file IO (code 11) at receiver.c(301) [receiver=3.0.6]
rsync: connection unexpectedly closed (213 bytes received so far) [generator]
rsync error: error in rsync protocol data stream (code 12) at io.c(600)
[generator=3.0.6]
'
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12696947 - PreCommit-HIVE-TRUNK-Build
> allow column list specification in INSERT statement
> ---------------------------------------------------
>
> Key: HIVE-9481
> URL: https://issues.apache.org/jira/browse/HIVE-9481
> Project: Hive
> Issue Type: Bug
> Components: Parser, Query Processor, SQL
> Affects Versions: 0.14.0
> Reporter: Eugene Koifman
> Assignee: Eugene Koifman
> Attachments: HIVE-9481.patch
>
>
> Given a table FOO(a int, b int, c int), ANSI SQL supports insert into
> FOO(c,b) select x,y from T. The expectation is that 'x' is written to column
> 'c' and 'y' is written column 'b' and 'a' is set to NULL, assuming column 'a'
> is NULLABLE.
> Hive does not support this. In Hive one has to ensure that the data
> producing statement has a schema that matches target table schema.
> Since Hive doesn't support DEFAULT value for columns in CREATE TABLE, when
> target schema is explicitly provided, missing columns will be set to NULL if
> they are NULLABLE, otherwise an error will be raised.
> If/when DEFAULT clause is supported, this can be enhanced to set default
> value rather than NULL.
> Thus, given {noformat}
> create table source (a int, b int);
> create table target (x int, y int, z int);
> create table target2 (x int, y int, z int);
> {noformat}
> {noformat}insert into target(y,z) select * from source;{noformat}
> will mean
> {noformat}insert into target select null as x, a, b from source;{noformat}
> and
> {noformat}insert into target(z,y) select * from source;{noformat}
> will meant
> {noformat}insert into target select null as x, b, a from source;{noformat}
> Also,
> {noformat}
> from source insert into target(y,z) select null as x, * insert into
> target2(y,z) select null as x, source.*;
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
