Is there anyone who has managed creating and inserting data into a hive table as the OS user user who is running Impala shell? In my environment, all tables get created as user mapr as Impala daemon is running under mapr.
Kamal Karunaratna, its difficult to achieve using JUST Impala, as impala doesn't support user impersonation (How Impersonation Works ). By default (when authorization is not enabled), Impala does all read and write operations with the privileges of the Mapr, which is suitable for a development/test environment. you need to configure sentry for that (Configure Impala to Use Sentry Authorization With the Database Storage Model )
Retrieving data ...