Re: HS2: Permission denied for my own table?

I checked that the impersonation setting is correct. Also not using SQL authentication. Side note: looks like HS2 really wants to read the table's folder using user "hive" (just the folder) before it does anything else for the actual files. In the setup as describe above, I can query the table

Re: HS2: Permission denied for my own table?

Are you using SQL Authorisation? If you create tables using the hive cli, you won't be able to select the table from a connection to the hive server. On Thu, 18 Apr 2019 at 04:34, Alan Gates wrote: > See >

Re: HS2: Permission denied for my own table?

See https://cwiki.apache.org/confluence/display/Hive/Setting+up+HiveServer2#SettingUpHiveServer2-Impersonation Alan. On Tue, Apr 16, 2019 at 10:03 PM Kaidi Zhao wrote: > Hello! > > Did I miss anything here or it is an known issue? Hive 1.2.1, hadoop > 2.7.x, kerberos, impersonation. > > Using

HS2: Permission denied for my own table?

Hello! Did I miss anything here or it is an known issue? Hive 1.2.1, hadoop 2.7.x, kerberos, impersonation. Using hive client, create a hive db and hive table. I can select from this table correctly. In hdfs, change the table folder's permission to be 711. In hive client, I can still select from