AnsweredAssumed Answered

Error compiling statement (Wrong FS)

Question asked by saviv on Jul 12, 2016
Latest reply on Nov 15, 2016 by bweisslerAginity

I have an error when performing a CTAS statement through Hive on MapR 5.1. Here is a very simple query sequence that will reproduce the problem:

 

create table t1 (

  id string,

  rel string

) stored as orc;

 

create table t2 (

  id string,

  val double

) stored as orc;

 

insert into t1 values ('t1_aaa', 't2_aaa');

insert into t2 values ('t2_aaa', 10);

 

select t1.id, t2.val from

t1 join t2 on (t1.rel = t2.id);

 

create table t3 as

select t1.id, t2.val from

t1 join t2 on (t1.rel = t2.id);

 

While the second to last select statement succeeds, the final CTAS statement fails with:

Error while compiling statement: FAILED: IllegalArgumentException Wrong FS: maprfs:/user/hive/warehouse/t3, expected: file:///

 

Anyone know how to fix this?

Outcomes