Section 7:59. Apache Hive – Managing Tables in Hive

To create a table in Hive and list all the tables in the current database, you can use the following commands:

By default We will Create Managed table 

If you add the option IF NOT EXISTS, Hive ignores the statement in case the table already exists.

AS part of Our Labs we created Orders table

Share this post