Hue3.9 query table's tablebrowser error

How to solve this problem?thank you very much


error log:

[14/Sep/2020 20:11:28 +0800] api2 ERROR Error running <function jobs at 0x7f939c1cc410>
Traceback (most recent call last):
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/jobbrowser/src/jobbrowser/api2.py”, line 38, in decorator
return func(*args, **kwargs)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/jobbrowser/src/jobbrowser/api2.py”, line 57, in jobs
jobs = get_api(request.user, interface).apps(filters)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/jobbrowser/src/jobbrowser/apis/schedule_api.py”, line 48, in apps
jobs = oozie_api.get_coordinators(**kwargs)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/desktop/libs/liboozie/src/liboozie/oozie_api.py”, line 132, in get_coordinators
return self.get_jobs(‘coord’, offset, cnt, filters)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/desktop/libs/liboozie/src/liboozie/oozie_api.py”, line 119, in get_jobs
resp = self._root.get(‘jobs’, params)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/desktop/core/src/desktop/lib/rest/resource.py”, line 106, in get
return self.invoke(“GET”, relpath, params, headers=headers, allow_redirects=True, clear_cookies=clear_cookies)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/desktop/core/src/desktop/lib/rest/resource.py”, line 83, in invoke
clear_cookies=clear_cookies)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/desktop/core/src/desktop/lib/rest/http_client.py”, line 211, in execute
raise self.exc_class(ex)
RestException: HTTPConnectionPool(host=‘kkb-hc-87’, port=11000): Max retries exceeded with url: /oozie/v1/jobs?len=1&doAs=admin&filter=user%3Dadmin%3Bstartcreatedtime%3D-7d%3Bstatus%3DRUNNING%3Bstatus%3DPREP%3Bstatus%3DSUSPENDED&user.name=hue&offset=1&timezone=Asia%2FShanghai&jobtype=coord (Caused by NewConnectionError(’<requests.packages.urllib3.connection.HTTPConnection object at 0x7f936434e450>: Failed to establish a new connection: [Errno 111] Connection refused’,))
[14/Sep/2020 20:11:28 +0800] connectionpool INFO Starting new HTTP connection (152): kkb-hc-87:11000
[14/Sep/2020 20:11:28 +0800] access DEBUG 10.20.18.109 admin - “POST /jobbrowser/jobs/ HTTP/1.1” returned in 20ms
[14/Sep/2020 20:11:28 +0800] access INFO 10.20.18.109 admin - “POST /jobbrowser/api/jobs HTTP/1.1”
[14/Sep/2020 20:11:28 +0800] resource DEBUG GET /cluster/apps Got response in 8ms: {“apps”:null}
[14/Sep/2020 20:11:28 +0800] connectionpool DEBUG “kkb-hc-56:8088 GET /ws/v1/cluster/apps?finalStatus=UNDEFINED&limit=1000&user.name=hue&user=admin&startedTimeBegin=1599480688000&doAs=admin HTTP/1.1” 200 None
[14/Sep/2020 20:11:28 +0800] access INFO 10.20.18.109 admin - “POST /jobbrowser/jobs/ HTTP/1.1”
[14/Sep/2020 20:11:15 +0800] access DEBUG 10.20.18.109 admin - “GET /metastore/table/ods/log_visit HTTP/1.1” returned in 1381ms
[14/Sep/2020 20:11:15 +0800] middleware INFO Processing exception: DB Error: Traceback (most recent call last):
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/core/handlers/base.py”, line 112, in get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/transaction.py”, line 371, in inner
return func(*args, **kwargs)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/metastore/src/metastore/views.py”, line 275, in describe_table
raise PopupException(
(“DB Error”), detail=e.message if hasattr(e, ‘message’) and e.message else e)
PopupException: DB Error
[14/Sep/2020 20:11:15 +0800] exceptions_renderable ERROR Potential trace: [(’/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/metastore/src/metastore/views.py’, 272, ‘describe_table’, ‘table = db.get_table(database, table)’), (’/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/dbms.py’, 212, ‘get_table’, ‘return self.client.get_table(database, table_name)’), (’/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py’, 1265, ‘get_table’, ‘table = self._client.get_table(database, table_name, partition_spec)’), (’/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py’, 844, ‘get_table’, ‘return HiveServerTable(table_results.results, table_schema.schema, desc_results.results, desc_schema.schema)’), (’/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py’, 75, ‘init’, ‘self.describe = HiveServerTTableSchema(self.desc_results, self.desc_schema).cols()’), (’/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py’, 347, ‘cols’, “cols = HiveServerTRowSet(self.columns, self.schema).cols((‘name’, ‘type’, ‘comment’))”), (’/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py’, 214, ‘cols’, ‘cols = [rs.full_col(name) for name in col_names]’), (’/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py’, 241, ‘full_col’, ‘pos = self._get_col_position(colName)’), (’/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py’, 245, ‘_get_col_position’, ‘return filter(lambda (i, col): col.columnName == column_name, enumerate(self.schema.columns))[0][0]’)]
[14/Sep/2020 20:11:15 +0800] exceptions_renderable ERROR Potential detail: list index out of range
[14/Sep/2020 20:11:15 +0800] views ERROR Describe table error
Traceback (most recent call last):
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/metastore/src/metastore/views.py”, line 272, in describe_table
table = db.get_table(database, table)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/dbms.py”, line 212, in get_table
return self.client.get_table(database, table_name)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 1265, in get_table
table = self._client.get_table(database, table_name, partition_spec)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 844, in get_table
return HiveServerTable(table_results.results, table_schema.schema, desc_results.results, desc_schema.schema)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 75, in init
self.describe = HiveServerTTableSchema(self.desc_results, self.desc_schema).cols()
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 347, in cols
cols = HiveServerTRowSet(self.columns, self.schema).cols((‘name’, ‘type’, ‘comment’))
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 214, in cols
cols = [rs.full_col(name) for name in col_names]
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 241, in full_col
pos = self._get_col_position(colName)
File “/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 245, in _get_col_position
return filter(lambda (i, col): col.columnName == column_name, enumerate(self.schema.columns))[0][0]
IndexError: list index out of range
[14/Sep/2020 20:11:15 +0800] thrift_util DEBUG Thrift call: <class ‘TCLIService.TCLIService.Client’>.CloseOperation(args=(TCloseOperationReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret=8b4c3d50c79a3f4b:b1f75b6e308325bf, guid=89453aa77ad11c8d:126f7ea15195208a))),), kwargs={}) returned in 0ms: TCloseOperationResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0))
[14/Sep/2020 20:11:15 +0800] thrift_util DEBUG Thrift call: <class ‘TCLIService.TCLIService.Client’>.CloseOperation(args=(TCloseOperationReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret=8b4c3d50c79a3f4b:b1f75b6e308325bf, guid=89453aa77ad11c8d:126f7ea15195208a))),), kwargs={})
[14/Sep/2020 20:11:15 +0800] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.SuperClient object at 0x7f935bf6fc90> call
[14/Sep/2020 20:11:15 +0800] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7f9452bb6510> got connection <desktop.lib.thrift_util.SuperClient object at 0x7f935bf6fc90> after 0.00 seconds
[14/Sep/2020 20:11:15 +0800] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7f9452bb6510> got connection <desktop.lib.thrift_util.SuperClient object at 0x7f935bf6fc90> after 0.00 seconds