Category: hive

Bigdata – Hive

Hive @ Freshers.in

How to drop multiple partition in Hive by giving condition.

Hive Partitions is a good and easy way to organizes Hive tables into partitions by dividing tables into different parts…

Hive @ Freshers.in

How to delete a partition data as well from Hive external table on DROP command?

As you know external tables are tables where¬† Hive does not manage the data of the External table. So when…

Hive @ Freshers.in

How to convert a hive managed table to external table without recreating it ?

In Hive, Managed tables / Internal table are Hive owned tables and the tables data are managed and controlled by…

How can I get all the hive tables and its external location,partitions etc ?

There may be some situations where you may need to give all the hive tables created and its location and…

Hive – Where can I get the hive metastore details (Credentials,Host,Server etc)

In General we don’t deal directly with Hive metastore . But there are some situation that we may need to…

Hive – What are the metastore tables in Hive ?

Metastore is the central repository of Apache Hive metadata. It stores metadata for Hive tables AUX_TABLE BUCKETING_COLS CDS COLUMNS_V2 COMPACTION_QUEUE…

How to access hive using Python (Source code )

Use case : If you want to do some scheduling or some automation , we may need to access Hive…