[jira] [Created] (HIVE-20342) Create table from CTAS with location fails for managed tables

["Pablo Idiaquez (JIRA)" <ji...@apache.org>]

Pablo Idiaquez created HIVE-20342:
-------------------------------------

             Summary: Create table from CTAS with location fails for managed tables
                 Key: HIVE-20342
                 URL: https://issues.apache.org/jira/browse/HIVE-20342
             Project: Hive
          Issue Type: Bug
          Components: Beeline, HiveServer2
    Affects Versions: 3.0.0
            Reporter: Pablo Idiaquez


When attempting to create table from SELECT with LOCATION  (managed tables)

 

To reproduce CREATE source table CLASS with some data

then use the code below to CREATE table TABLE42 from select on CLASS and LOCATION /tmp/test1

 
{code:java}
CREATE TABLE TABLE42 ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' STORED AS RCFILE
LOCATION '/tmp/test1'
AS SELECT * FROM
CLASS;
{code}
 

it fails with ERROR:
{code:java}
ERROR : Job Commit failed with exception 'org.apache.hadoop.hive.ql.metadata.HiveException(The following files were committed but not found: [/tmp/test1/delta_0000001_0000001_0000/000000_0])' 
org.apache.hadoop.hive.ql.metadata.HiveException: The following files were committed but not found: [/tmp/test1/delta_0000001_0000001_0000/000000_0] 
at org.apache.hadoop.hive.ql.exec.Utilities.handleMmTableFinalPath(Utilities.java:4329) 
at org.apache.hadoop.hive.ql.exec.FileSinkOperator.jobCloseOp(FileSinkOperator.java:1393) 
{code}
 

If the same is attempted for an EXTERNAL table will work OK
{code:java}
CREATE EXTERNAL TABLE test3 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' STORED AS RCFILE LOCATION '/tmp/test2' AS SELECT * FROM test;
{code}
if we CREATE table on statement 1, and INSERT from SELECT on statement 2 , will work OK.

(Step1 CREATE TABLE)
{code:java}
CREATE TABLE `TABLE42`( 
`COL1` double, 
`COL2` varchar(8), 
`COL3` varchar(1), 
`COL4` double, 
`COL5` double) 
ROW FORMAT SERDE 
'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' 
STORED AS INPUTFORMAT 
'org.apache.hadoop.hive.ql.io.RCFileInputFormat' 
OUTPUTFORMAT 
'org.apache.hadoop.hive.ql.io.RCFileOutputFormat' 
LOCATION '/tmp/test1';

{code}
(Step2 INSERT from SELECT)
{code:java}
INSERT into TABLE42 select * FROM CLASS;
{code}
will work as expected.

 

Thanks

Pablo

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)