Flash Sale: Flat 70% + Addl. 25% Off on all Courses | Use Coupon DS25 in Checkout | Offer Expires InEnroll Now
Each table in Hive has a location. By default, the table is located in a directory inside
/apps/hive/warehouse. We can override the location by specifying LOCATION keyword while creating the table. Loading the data into a table copies the data to warehouse if data is local. Loading the data into a table moves the data to warehouse if data that we are loading is in HDFS for both managed as well as external tables.
Dropping a managed table deletes the data from the location while dropping an external table does not delete the underlying data. The metadata is stored in a relational database called as metastore.
Hope you enjoyed the video. Happy learning and have a great day!
No hints are availble for this assesment
Answer is not availble for this assesment