question Re: Resource temporarily unavailable error message from Impala shell in Support Questions

question Re: Resource temporarily unavailable error message from Impala shell in Support Questions https://community.cloudera.com/t5/Support-Questions/Resource-temporarily-unavailable-error-message-from-Impala/m-p/27479#M11696 Hi Alex, I first created these 2 tables via Impala Shell (v2.2.0). [eplnx070:21000] > CREATE TABLE svuedhd1_s.src (                 >   col1 INT,                 >   col2 STRING                 > )                 > STORED AS TEXTFILE                 > LOCATION '/data/BI/SVUEDHD1_S/src';Query: create TABLE svuedhd1_s.src (col1 INT,col2 STRING)STORED AS TEXTFILELOCATION '/data/BI/SVUEDHD1_S/src' Fetched 0 row(s) in 0.44s[eplnx070:21000] > CREATE TABLE svuedhd1_s.tgt (                 >   col1 INT,                 >   col2 STRING                 > )                 > STORED AS TEXTFILE                 > LOCATION '/data/BI/SVUEDHD1_S/tgt';Query: create TABLE svuedhd1_s.tgt (col1 INT,col2 STRING)STORED AS TEXTFILELOCATION '/data/BI/SVUEDHD1_S/tgt' Fetched 0 row(s) in 0.48s. Once that was done, here is the content of these files in HDFS. They both contain nothing. bash-4.1$ hadoop fs -ls /data/BI/SVUEDHD1_S/srcbash-4.1$ hadoop fs -ls /data/BI/SVUEDHD1_S/tgtbash-4.1$ Next, I tried to just INSERT the data into tgt from src and that works absolutely fine in Impala. [eplnx070:21000] > use svuedhd1_s;Query: use svuedhd1_s[eplnx070:21000] > select count(*) from tgt;Query: select count(*) from tgt+----------+| count(*) |+----------+| 0        |+----------+Fetched 1 row(s) in 4.15s[eplnx070:21000] > select count(*) from src;Query: select count(*) from src+----------+| count(*) |+----------+| 0        |+----------+Fetched 1 row(s) in 5.11s [eplnx070:21000] > insert into tgt select * from src;Query: insert into tgt select * from srcInserted 0 row(s) in 0.53s[eplnx070:21000] > But when, I do an INSERT OVERWRITE, I get the error and the warning. [eplnx070:21000] > insert overwrite tgt select * from src;Query: insert overwrite tgt select * from srcWARNINGS: Could not list directory: hdfs://nameservice1/data/BI/SVUEDHD1_S/tgtError(11): Resource temporarily unavailable    [eplnx070:21000] > On the flipside, if I create these tables in Impala and then do an INSERT OVERWRITE using Hive, it works perfectly fine without any issue. I will also, send out the JIRA link and the file descriptor issue to our Admin to see if that could be a possible problem. Thanks,Ajay Thu, 14 May 2015 21:19:08 GMT ajayshenai15 2015-05-14T21:19:08Z