Hello Ashish, Unfortunately,I got this error when running the commande you provided:
pns@app11:~$ hadoop fs -ls -lrt /user/hive/warehouse -ls: Illegal option -lrt Usage: hadoop fs [generic options] -ls [-d] [-h] [-R] [<path> ...] On Sun, Jun 1, 2014 at 8:17 PM, Ashish Garg <gargcreation1...@gmail.com> wrote: > 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 >> >> >> >> >
