This topic contains 1 reply, has 1 voice, and was last updated by  dfbdteam3 4 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #4825

    dfbdteam3
    Moderator

    What are the types of Tables in Hives?

    #4826

    dfbdteam3
    Moderator

    Apache Hive Internal and External Tables
    Especially, for querying and analyzing large datasets, Hive is an open source data warehouse system. We can categorize data into Table, Partition, and Bucket. So, in Hive, the table is logically made up of the data being stored. They are of 2 kinds:

    – Managed Table (Internal Table)
    – External Table

    Hive Managed Tables-

    A table in Hive manages the data, by default. That says Hive moves the data into its warehouse directory.

    Hive External Tables-

    Also, we create an external table. So, it is responsible for Hive to refer to the data which is at an existing location outside the warehouse directory.

    learn more about Hive tables in detail, follow the link: Comparison between Hive Internal Tables vs External Tables

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.