Sorry Amzad, I am afraid u can't Sent from my iPhone
> On May 30, 2014, at 3:12 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 > > >
