Re: Unable to connect to S3 after enabling Ranger with Hive

Cool. After adding the configuration it is working fine. 0: jdbc:hive2://usw2dxdpmn01:10010> set hive.security.authorization.sqlstd.confwhitelist.append; ++--+ | set |

Re: Unable to connect to S3 after enabling Ranger with Hive

Selva, Please find the results. set hive.security.authorization.sqlstd.confwhitelist; |

Re: Unable to connect to S3 after enabling Ranger with Hive

Hi, Can you also post here the value for the following two parameters: hive.security.authorization.sqlstd.confwhitelist hive.security.authorization.sqlstd.confwhitelist.append Thanks, Selva- From: Anandha L Ranganathan Reply-To:

Re: Unable to connect to S3 after enabling Ranger with Hive

Selva, We are using HDP and here are versions and results. Hive : 1.2.1.2.4 Ranger: 0.5.0.2.4 0: jdbc:hive2://usw2dxdpmn01:10010> set hive.conf.restricted.list;

Unable to connect to S3 after enabling Ranger with Hive

Hi, Unable to create table pointing to S3 after enabling Ranger. This is database we created before enabling Ranger. 1. SET fs.s3a.impl=org.apache.hadoop.fs.s3a.S3AFileSystem; 2. SET fs.s3a.access.key=xxx; 3. SET fs.s3a.secret.key=yyy; 4. 5. 6. CREATE