I think it is worth to mention that I tried doing this before on locally deployed HDFS and it went well.
So my question now, what has gone wrong with creation database with given location?? thanx for your rplies Amjad On Mon, Jun 2, 2014 at 9:50 AM, Siddharth Tiwari <[email protected]> wrote: > Sorry Amzad, I am afraid u can't > > Sent from my iPhone > > On May 30, 2014, at 3:12 AM, "Amjad ALSHABANI" <[email protected]> > 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 > > > >
