question Re: Error while querying Hive tables from HUE in Support Questions

question Re: Error while querying Hive tables from HUE in Support Questions https://community.cloudera.com/t5/Support-Questions/Error-while-querying-HIve-tables-from-HUE/m-p/295097#M217592 Hi <a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/5016">@lwang</a>  I was able to get the details . But when i configure my oracle database i am seeing below error .I dont see any tables were also create in oracle metadata db . [29/Apr/2020 12:36:36 +0000] exception ERROR Internal Server Error: / Traceback (most recent call last): File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/core/handlers/exception.py", line 41, in inner response = get_response(request) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/core/handlers/base.py", line 244, in _legacy_get_response response = middleware_method(request) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/middleware/locale.py", line 25, in process_request language = translation.get_language_from_request(request, check_path=i18n_patterns_used) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/utils/translation/__init__.py", line 211, in get_language_from_request return _trans.get_language_from_request(request, check_path) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/utils/translation/trans_real.py", line 519, in get_language_from_request lang_code = request.session.get(LANGUAGE_SESSION_KEY) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/contrib/sessions/backends/base.py", line 68, in get return self._session.get(key, default) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/contrib/sessions/backends/base.py", line 207, in _get_session self._session_cache = self.load() File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/contrib/sessions/backends/db.py", line 35, in load expire_date__gt=timezone.now() File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py", line 374, in get num = len(clone) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py", line 232, in __len__ self._fetch_all() File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py", line 1121, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py", line 53, in __iter__ results = compiler.execute_sql(chunked_fetch=self.chunked_fetch) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/sql/compiler.py", line 899, in execute_sql raise original_exception DatabaseError: ORA-00942: table or view does not exist   Below are my databse detaisl i put in hue.ini [[database]] # Database engine is typically one of: # postgresql_psycopg2, mysql, sqlite3 or oracle. # # Note that for sqlite3, 'name', below is a path to the filename. For other backends, it is the database name # Note for Oracle, options={"threaded":true} must be set in order to avoid crashes. # Note for Oracle, you can use the Oracle Service Name by setting "host=" and "port=" and then "name=(host):(port)/(service_name)". # Note for MariaDB use the 'mysql' engine. engine=oracle host= port=0 user=hue password=xxxxx # conn_max_age option to make database connection persistent value in seconds # <A href="https://docs.djangoproject.com/en/1.11/ref/databases/#persistent-connections" target="_blank" rel="noopener">https://docs.djangoproject.com/en/1.11/ref/databases/#persistent-connections</A> ## conn_max_age=0 # Execute this script to produce the database password. This will be used when 'password' is not set. ## password_script=/path/script name= options={"threaded":true} # Database schema, to be used only when public schema is revoked in postgres ## schema=public and i see the below coming up when i open hue UI with error page .    <TABLE width="99px"><TBODY><TR><TD width="99.2333px">DATABASES</TD></TR></TBODY></TABLE> Wed, 29 Apr 2020 23:20:59 GMT bhara 2020-04-29T23:20:59Z