Specify the different types of tables accessible in Hive?

devquora
devquora

Posted On: Feb 22, 2018

 

Managed and External tables are the two different kinds of tables in hive used to enhance how information is loaded, managed and controlled

Two types of tables, which are used are:

  • Managed Table -: Managed table is also known as an internal table. This is the default table in Hive. When we make a table in Hive without specifying it as external, naturally we will get a Managed table. If we make a table as a managed table, the table will be made in a specific area in HDFS.
  • External table: External table is made up for external use as when the information is utilized outside Hive. At whatever point we need to erase the table’s meta information and we need to keep the table’s information as it seems to be, we utilize External table. The external table just erases the pattern of the table.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Hive Interview Questions

    What do you understand by Hive?

    Hive is an information warehouse programming which is utilized for encourages questioning and overseeing vast data sets..

    Hive Interview Questions

    How can a developer utilize Hive?

    Hive is helpful when influencing information to warehouse applications when you are dealing with static information rath..

    Hive Interview Questions

    Specify the different methods of Hive?

    Various methods of the hive are as follows:Local mode Map reduce modeThe Hive can work in the above modes relying up..