try desc formatted <table_name>; it shows you table location on hdfs On Thu, Apr 30, 2015 at 2:43 PM, Kumar Jayapal <kjayapa...@gmail.com> wrote:
> I did not find it in .Trash file is moved to hive table I want to move it > back to hdfs. > > On Thu, Apr 30, 2015 at 2:20 PM, Alexander Pivovarov <apivova...@gmail.com > > wrote: > >> Try to find the file in hdfs trash >> On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kjayapa...@gmail.com> wrote: >> >>> Hi, >>> >>> I loaded one file to hive table it is in .gz extension. file is >>> moved/deleted from hdfs. >>> >>> when I execute select command I get an error. >>> >>> Error: Error while processing statement: FAILED: Execution Error, return >>> code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask >>> (state=08S01,code=2) >>> >>> how can I move back the file to HDFS. how can I do it. >>> >>> Thanks >>> Jay >>> >> >