Comments

  1. if we drop the table in hive ..metastore will get lost then how we can get the location of the table

    • mahesh chimmiri says:

      If u drop d external table in hive u have to check manually in default location of hive /user/hive/warehouse

      hadoop fs -ls /user/hive/warehouse

      Above I explained the same things with examples

  2. venkatramireddy says:

    Hi, my question is, while creating external table if we give location then the files will store in that mentioned location instead of default warehouse(/user/hive/warehouse) folder.
    In external case if I delete data then it will delete from meta store , so how you can I dentify the location of the table. becz in this case it is not storing in default location.
    Kindly explain .

    Thanks in advance.
    Regards,
    Venkat

Speak Your Mind

*