Try this command: hadoop fs -ls -lrt /user/hive/warehouse/ Regards.
On Fri, May 30, 2014 at 6:10 AM, Amjad ALSHABANI <ashshab...@gmail.com> wrote: > Hello Everybody, > > I know that this question may concern Hadoop list but i ve made this > mistake when using Hive. > I created new database giving the location on HDFS but i found that it > removed all other data that exist already. > > ===== > before creation, the directory on HDFS contains : > pns@app11:~$ hadoop fs -ls /user/hive/warehouse > Found 25 items > drwxr-xr-x - user1 supergroup 0 2013-11-20 13:40 > */user/hive/warehouse/*dfy_ans_autres > drwxr-xr-x - user1 supergroup 0 2013-11-20 13:40 > /user/hive/warehouse/dfy_ans_maillog > drwxr-xr-x - user1 supergroup 0 2013-11-20 14:28 > /user/hive/warehouse/dfy_cnx > drwxr-xr-x - user2 supergroup 0 2014-05-30 06:05 > /user/hive/warehouse/pns.db > drwxr-xr-x - user2 supergroup 0 2014-02-24 17:00 > /user/hive/warehouse/pns_fr_integ > drwxr-xr-x - user2 supergroup 0 2014-05-06 15:33 > /user/hive/warehouse/pns_logstat.db > > > hive -e "CREATE DATABASE my_stats LOCATION 'hdfs://XXXX:9000 > */user/hive/warehouse/*mystats.db'" > > but now I couldn't see the other directories on HDFS: > > pns@app11:~/aalshabani$ hls /user/hive/warehouse > Found 1 items > drwxr-xr-x - user2 supergroup 0 2014-05-30 11:37 > */user/hive/warehouse*/mystats.db > > > Is there anyway I could restore the other data?? > > > Best regards. > > Amjad > > > >
