Let’s discuss on enabling Hive Metastore NULL result for an empty string. In Hive, while inserting values, if some columns have empty strings and you want to display it as NULL when queried the table. From the below image, you can see the empty string are displayed just like that. And this property applies to only…
Lets us look into S3 bucket Hive sentry permission to create external table. If you are planning to create an external table and to have the data in S3. We must give the hive sentry permission on S3 bucket URI. S3 Bucket Hive Sentry Permission: – Below are the sentry rules for providing permission to create external…
We will look in to Hive Sentry Roles commands. Here in this post you will get all sentry role creation and grant permission commands. 1. Create hive sentry role :- CREATE ROLE `role_name`; # Here were are using group name as hadoop-developer CREATE ROLE `hadoop-developer_role`; It is always a good practice to create a role…