Hive Display column to which there is SELECT access

Question

Hi. I had created few tables in Hive and had given SELECT access to some of the columns in the table. Now I want to check to which columns there is SELECT access. How can I check this?

Answer 1

You can use the following query to get list of the columns that has SELECT access:

SHOW COLUMNS (FROM|IN) <table name> [(FROM|IN) <database name>];