Can you please let me know if my understanding is correct or it is a misconcpetion.
At present, the users must have access to the raw table though we just want to access the view, is that correct? Any idea when will this limitation move off?
Context: Created a table -TABLE1- the accessgroup assigned for this table- bdrxproj, now we have created a view for this table VIEWTABLE1- with accessgroup assigned as bdrxvproj. Now here while we are accessing the view, we got hive job failed.
I understand that currently even though we are part of the access group assigned to view, we can't execute any queries unless and until we get access to the raw table data. Is that correct?