Hey @Mathi Murugan! Hm, could you share with us more details? Is your environment secure (kerberos, ranger, knox, hdfs acl)? If it isn't, then try to add permission to your user through chmod (to have write/read permissions) or take the ownership through chown, would be smtg like this:
hdfs dfs -chmod - R 777 /apps/hive/warehouse/salaries --TABLE SALARIES hdfs dfs -chown -R hive:hadoop /apps/hive/warehouse/salaries --Changing the ownership from root to hive
Just remember that you'll need to run these commands as hdfs user or have the same permission as hdfs.
I see that currently ALTER (DATABASE|SCHEMA) database_name SET OWNER [USER|ROLE] user_or_role; does not give the desired fine-grained option for only a specific table in a schema/database, so I think the best option would be to use Ranger and give a select privilege on the particular database or underlying table to the new user who can then issue a Create Table As Select (CTAS) which will automatically change the ownership to the issuer of the CTAS.