varunrao / aws-blog-emr-ranger

Repo for Amazon EMR and Apache Ranger Integration
6 stars 2 forks source link

"database is locked" error in Hue with V1 and EMR v5.30 #10

Closed varunrao closed 4 years ago

varunrao commented 4 years ago

After installing V1 of the code, and using EMR v5.30, Hive queries using Hue shows a "database is locked" error for tables they have access to

varunrao commented 4 years ago

Issues is tied specifically to EMR v5.30. Need an update to hue.ini to change default DB to mysql instead of "sqlite3"

varunrao commented 4 years ago

Needs an update to the hue.ini (Added a EMR step hue-update.sh) which will only run if version is 5.30