As you know external tables are tables where Hive does not manage the data of…
Category: hive
Bigdata – Hive
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 to copy data from Redshift to Hive ? How to unload from Redshift in Parquet format ? Explained with Sample code .
There may be some business scenario to copy daily data from Redshift to Hive. For the compression , it is…
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…