https://community.cloudera.com/t5/Support-Questions/Error-while-querying-HIve-tables-from-HUE/m-p/295082#M217584 <P>Hi&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/50045">@bhara</a>&nbsp;,</P> <P>&nbsp;</P> <P>Both error messages points out you need to tune your Hue performance.</P> <P>&nbsp;</P> <P>First thing you need to check if you are using the default SQLite DB. If so, you should move the database from the default database across to another database backend such as MySql/Postgres/Oracle, which handles locking better than the default SQLite DB. Hue should not be run on SQLite in an environment with more than 1 concurrent user. Here is the doc on how to switch the DB:</P> <P><A href="https://docs.cloudera.com/documentation/enterprise/5/latest/topics/hue_dbs_0.html" target="_blank">https://docs.cloudera.com/documentation/enterprise/5/latest/topics/hue_dbs_0.html</A></P> <P>&nbsp;</P> <P>You can also check this&nbsp;Hue performance tuning guide for more information on tuning Hue like load balancing etc:</P> <P><A href="https://gethue.com/performance-tuning/" target="_blank">https://gethue.com/performance-tuning/</A></P> <P>&nbsp;</P> <P>Thanks and hope this helps!</P> <P>Li</P> Wed, 29 Apr 2020 16:43:56 GMT lwang 2020-04-29T16:43:56Z