How to display Information Schema using Hive?

Question

Is there any way by which we can implement information_schema using Hive? Also, What is the process to do data profiling in Hive?
Example in SQL we use Information_Schema like this :

SELECT * FROM INFORMATION_SCHEMA.TABLES;

Answer 1

information_schema is not implemented in Hive, there is an open JIRA for the same. By default Hive uses Derby as the metastore to store the table metadata. By connecting to Derby, the system tables can be seen.

Answer 2

import pyodbc
import pandas as pd
cnx = pyodbc.connect(dsn = 'Hive', autocommit ='true' )
df = pd.read_sql('DESCRIBE EXTENDED TABLE_NAME;', cnx)
print(df)

i use the above code in python but to answer your question you could simply use DESCRIBE EXTENDED TABLE_NAME;