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?
Asked
Active
Viewed 74 times
1 Answers
0
Try the below in hive
show columns in <table name>
this should return you a list of columns in a table.
Rishu Shrivastava
- 3,745
- 1
- 20
- 41
-
This is in hive. I need to fetch it in my teradata using querygrid – user3263255 Jun 30 '20 at 11:28
-
Ok then why did you tag HIVE into this? – Rishu Shrivastava Jun 30 '20 at 12:35
-
Because its a hive table which needs to be accessed via querygrid – user3263255 Jun 30 '20 at 15:55