hive查看数据库里库的信息,如何获取Hive数据库中的所有表定义？

I am looking to get all table definitions in Hive. I know that for single table definition I can use something like -

describe <>

describe extended <>

But, I couldn't find a way to get all table definitions. Is there any table in megastore similar to Information_Schema in mysql or is there command to get all table definitions ?

解决方案

You can do this by writing a simple bash script and some bash commands.

First, write all table names in a database to a text file using:

$hive -e 'show tables in ' | tee tables.txt

Then create a bash script (describe_tables.sh) to loop over each table in this list:

while read line

do

echo "$line"

eval "hive -e 'describe .$line'"

done

Then execute the script:

$chmod +x describe_tables.sh

$./describe_tables.sh < tables.txt > definitions.txt

The definitions.txt file will contain all the table definitions.