How To: Get all the Hive Table Create table DDLs in one query

This query can be run via Analyze, Notebooks or the API.

qds.py --token '' hivecmd run --query "show tables" > /tmp/tableslist.txt awk '{print "show create table " $0;}' /tmp/tableslist.txt > /tmp/createtableslist.sql
Have more questions? Submit a request

Comments

Powered by Zendesk