Fetch column name from hive via querygrid

Question

My requirement is that I need to fetch only the list of columns of a hive table via querygrid.

For example, the "help foreign table" gives the col_name,data_type and comment as output.

Can someone please suggest how I can fetch only the col_name?

Answer 1

Try the below in hive

show columns in <table name>

this should return you a list of columns in a table.