Community Articles

Find and share helpful community-sourced technical articles.
Announcements
Welcome to the upgraded Community! Read this blog to see What’s New!
Labels (2)
avatar

Below script is used to get all the Hive Databases and underlining tables or views or INDEX_TABLES in a cluster into a csv file. This helps in evaluating total counts for metrics or identifying any tables:

beeline -u 'jdbc:hive2://zookeeper1:2181,zookeeper2:2181,zookeeper3:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2' --outputformat=csv2 -f table.hql > tableslist.csv 

In table.hql

!tables

Hope this helps you.

4,726 Views
Comments

The script in the blog scans through all the databases on the Hive system, and routes all 'Create' Table statements to a file.. https://tips-to-code.blogspot.com/2018/07/automated-bash-script-to-export-all.html

Labels
Version history
Last update:
‎06-12-2017 09:35 PM
Updated by:
Contributors