Member since
10-07-2020
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
23755 | 10-07-2020 01:27 PM |
10-07-2020
01:27 PM
Disregard, fixed the issue by update Ranger Settings: Ranger -> Advanced -> Ranger Settings: Updated External URL from public dns (using AWS) to Private DNS. Restarted services and now beeline is working properly.
... View more
10-07-2020
09:48 AM
I'm encountering the following error while using beeline. (Note that I'm able to successfully connect using hive cli. [xxxx@ip-11-1-1-111 data_dir_design]$ beeline -u "jdbc:hive2://ip-11-1-1-111.us-west-1.compute.internal:10000/default;principal=hive/ip-11-1-1-111.us-west-1.compute.internal@EXAMPLE.COM" Connecting to jdbc:hive2://ip-11-1-1-111.us-west-1.compute.internal:10000/default;principal=hive/ip-11-1-1-111.us-west-1.compute.internal@EXAMPLE.COM Connected to: Apache Hive (version 1.2.1000.2.6.5.1175-1) Driver: Hive JDBC (version 1.2.1000.2.6.5.1175-1) Transaction isolation: TRANSACTION_REPEATABLE_READ Beeline version 1.2.1000.2.6.5.1175-1 by Apache Hive 0: jdbc:hive2://ip-11-1-1-111.us-west-1.compu> show databases; Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [xxxx] does not have [USE] privilege on [Unknown resource!!] (state=42000,code=40000) 0: jdbc:hive2://ip-11-1-1-111.us-west-1.compu> When connecting via hive: [xxx@ip-11-1-1-111 data_dir_design]$ hive log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender. Logging initialized using configuration in file:/etc/hive/2.6.5.1175-1/0/hive-log4j.properties hive> show databases; OK data default demo Time taken: 0.971 seconds, Fetched: 3 row(s) hive> I have granted the proper permission in ranger.
... View more
Labels: