Member since
05-03-2017
74
Posts
4
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1637 | 07-15-2020 06:25 AM | |
3214 | 04-21-2020 06:25 AM |
04-29-2020
07:20 AM
Team , We are seeing below errors when querying hive from HUE . Error 1 :- [29/Apr/2020 07:07:22 -0700] middleware ERROR Error saving profile information Traceback (most recent call last): File "/usr/local/hue/apps/useradmin/src/useradmin/middleware.py", line 104, in process_request profile.save() File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/base.py", line 808, in save force_update=force_update, update_fields=update_fields) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/base.py", line 838, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/base.py", line 905, in _save_table forced_update) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/base.py", line 955, in _do_update return filtered._update(values) > 0 File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py", line 667, in _update return query.get_compiler(self.db).execute_sql(CURSOR) 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 1204, in execute_sql cursor = super(SQLUpdateCompiler, self).execute_sql(result_type) 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 OperationalError: database is locked ERROR 2:- [29/Apr/2020 07:06:51 -0700] exception ERROR Internal Server Error: /hue/accounts/login 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 249, in _legacy_get_response response = self._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 187, in _get_response response = self.process_exception_by_middleware(e, 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 185, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/utils/decorators.py", line 185, in inner return func(*args, **kwargs) File "/usr/local/hue/build/env/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py", line 271, in decorated_login response = func(request, *args, **kwargs) File "/usr/local/hue/desktop/core/src/desktop/auth/views.py", line 206, in dt_login 'user': request.user File "/usr/local/hue/desktop/core/src/desktop/lib/django_util.py", line 241, in render **kwargs File "/usr/local/hue/desktop/core/src/desktop/lib/django_util.py", line 154, in _render_to_response return django_mako.render_to_response(template, *args, **kwargs) File "/usr/local/hue/desktop/core/src/desktop/lib/django_mako.py", line 127, in render_to_response return HttpResponse(render_to_string(template_name, data_dictionary), **kwargs) File "/usr/local/hue/desktop/core/src/desktop/lib/django_mako.py", line 116, in render_to_string_normal result = template.render(**data_dict) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/template.py", line 462, in render return runtime._render(self, self.callable_, args, data) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py", line 838, in _render **_kwargs_for_callable(callable_, data)) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py", line 873, in _render_context _exec_template(inherit, lclcontext, args=args, kwargs=kwargs) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py", line 899, in _exec_template callable_(context, *args, **kwargs) File "/tmp/tmpVKDTTV/desktop/login.mako.py", line 176, in render_body __M_writer(unicode( commonfooter(None, messages) )) File "/usr/local/hue/desktop/core/src/desktop/views.py", line 559, in commonfooter hue_settings = Settings.get_settings() File "/usr/local/hue/desktop/core/src/desktop/models.py", line 130, in get_settings settings, created = Settings.objects.get_or_create(id=1) 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 464, in get_or_create return self.get(**lookup), False 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 TransactionManagementError: An error occurred in the current transaction. You can't execute queries until the end of the 'atomic' block. Any help is appreciated . Regards Bharad
... View more
Labels:
- Labels:
-
Cloudera Hue
04-28-2020
08:09 AM
Team , HUE UI caches username password .i have to restart HUE to prompt username and password . I made below change but it did not change . # UI customizations # ------------------- [[custom]] # Top banner HTML code # e.g. (H4)Test Lab A2 Hue Services(/H4) ## banner_top_html= # Login splash HTML code # e.g. WARNING: You are required to have authorization before you proceed ## login_splash_html= ## logo_svg= cacheable_ttl=0 Regards Bharad
... View more
Labels:
- Labels:
-
Cloudera Hue
04-21-2020
06:25 AM
Hi @cjervis i resolved it by adding the below parameter hive.server2.parallel.ops.in.session=true under Hive > Config > Advanced > "Custom hive-site" .
... View more
04-21-2020
06:23 AM
thanks @GangWar i thought users in community might be having up to date details on CDP so was checking .
... View more
04-20-2020
11:50 AM
Team , Any idea on the migration process from HDP 2.x version to CDP version . Regards Bharad
... View more
Labels:
04-16-2020
07:10 AM
1 Kudo
@stevenmatison Thanks for looking into it .I was able to fix the issue . Thanks Bharad
... View more
04-15-2020
11:34 AM
Team ,
I am not able to see any databases when i configure HUE with hive . below is the only error i see in the logs and i cannot make out what exactly is the error .
[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.FetchResults(args=(TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f)), orientation=0, maxRows=5000),), kwargs={}) returned in 5ms: TFetchResultsResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), results=TRowSet(columnCount=None, binaryColumns=None, rows=[], columns=[TColumn(i32Val=None, byteVal=None, i16Val=None, i64Val=None, stringVal=TStringColumn(nulls='\x00', values=[]), boolVal=None, doubleVal=None, binaryVal=None), TColumn(i32Val=None, byteVal=None, i16Val=None, i64Val=None, stringVal=TStringColumn(nulls='\x00', values=[]), boolVal=None, doubleVal=None, binaryVal=None)], startRowOffset=0), hasMoreRows=False) [15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7fe2b85b54d0> got connection 49 after 0.00 seconds [15/Apr/2020 11:31:35 -0700] hive_server2_lib DEBUG 1 sessions found [15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7fe2b85b54d0> got connection 49 after 0.00 seconds [15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.GetResultSetMetadata(args=(TGetResultSetMetadataReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f))),), kwargs={}) [15/Apr/2020 11:31:35 -0700] connectionpool DEBUG http://catl0dlbd00027.corp.cox.com:10001 "POST /cliservice/ HTTP/1.1" 200 None [15/Apr/2020 11:31:35 -0700] kerberos_ DEBUG handle_mutual_auth(): Handling: 200 [15/Apr/2020 11:31:35 -0700] kerberos_ DEBUG handle_response(): returning <Response [200]> [15/Apr/2020 11:31:35 -0700] resource DEBUG POST <class 'requests_kerberos.kerberos_.HTTPKerberosAuth'> http://catl0dlbd00027.corp.cox.com:10001/cliservice/ �GetResultSetMetadata
����KZD�x�.���� *o$�{�Hw�|�9�� returned in 6ms 200 201 �GetResultSetMetadata
TABLE_SCHEM
Schema name. TABLE_CATALOG
Catalog name. [15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.GetResultSetMetadata(args=(TGetResultSetMetadataReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f))),), kwargs={}) returned in 8ms: TGetResultSetMetadataResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), schema=TTableSchema(columns=[TColumnDesc(comment='Schema name.', columnName='TABLE_SCHEM', typeDesc=TTypeDesc(types=[TTypeEntry(mapEntry=None, unionEntry=None, arrayEntry=None, userDefinedTypeEntry=None, structEntry=None, primitiveEntry=TPrimitiveTypeEntry(typeQualifiers=None, type=7))]), position=1), TColumnDesc(comment='Catalog name.', columnName='TABLE_CATALOG', typeDesc=TTypeDesc(types=[TTypeEntry(mapEntry=None, unionEntry=None, arrayEntry=None, userDefinedTypeEntry=None, structEntry=None, primitiveEntry=TPrimitiveTypeEntry(typeQualifiers=None, type=7))]), position=2)])) [15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7fe2b85b54d0> got connection 49 after 0.00 seconds [15/Apr/2020 11:31:35 -0700] hive_server2_lib DEBUG 1 sessions found [15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7fe2b85b54d0> got connection 49 after 0.00 seconds [15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.CloseOperation(args=(TCloseOperationReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f))),), kwargs={}) [15/Apr/2020 11:31:35 -0700] connectionpool DEBUG http://catl0dlbd00027.corp.cox.com:10001 "POST /cliservice/ HTTP/1.1" 200 None [15/Apr/2020 11:31:35 -0700] kerberos_ DEBUG handle_mutual_auth(): Handling: 200 [15/Apr/2020 11:31:35 -0700] kerberos_ DEBUG handle_response(): returning <Response [200]> [15/Apr/2020 11:31:35 -0700] resource DEBUG POST <class 'requests_kerberos.kerberos_.HTTPKerberosAuth'> http://catl0dlbd00027.corp.cox.com:10001/cliservice/ �CloseOperation
����KZD�x�.���� *o$�{�Hw�|�9�� returned in 5ms 200 42 �CloseOperation
[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.CloseOperation(args=(TCloseOperationReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f))),), kwargs={}) returned in 6ms: TCloseOperationResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0))
... View more
Labels:
- Labels:
-
Apache Hive
-
Cloudera Hue
-
Kerberos
04-09-2020
10:45 AM
Team ,
I have installed and configured HUE .but i see below error when i try to access HDSF .
Cannot access: /user/admin.
HTTPSConnectionPool(host='catl0dlbd00028.corp.cox.com', port=50070): Max retries exceeded with url: /webhdfs/v1/user/admin?op=GETFILESTATUS&user.name=hue&doas=admin (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'SSL23_GET_SERVER_HELLO', 'unknown protocol')],)",),))
I have logged in to HUE using default admin password . DO i have to configure LDAP before accessing HUE ? . I see its going to /user/admin wheer that folder might not be available in hdfs .
... View more
Labels:
- Labels:
-
Cloudera Hue
04-08-2020
11:22 AM
Team ,
I have installed HUE using the below steps .
https://github.com/steven-dfheinz/HDP2-Hue4-Service.
I was able to install HUE successfully ,but it fails to start . below is the error i am getting .
Traceback (most recent call last):
File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/hue_server.py", line 76, in <module>
HueServer().execute()
File "/usr/lib/ambari-agent/lib/resource_management/libraries/script/script.py", line 375, in execute
method(env)
File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/hue_server.py", line 26, in start
import params
File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/params.py", line 194, in <module>
webhdfs_url = format('http://' + dfs_namenode_http_address + '/webhdfs/v1')
File "/usr/lib/ambari-agent/lib/resource_management/libraries/script/config_dictionary.py", line 73, in __getattr__
raise Fail("Configuration parameter '" + self.name + "' was not found in configurations dictionary!")
resource_management.core.exceptions.Fail: Configuration parameter 'dfs.namenode.http-address' was not found in configurations dictionary!
Any help would be appreciated .
Regards Bharad
... View more
Labels: