Using HDP-2.6.4.0 - Superset. Getting internal error when I select source - databases from menu bar. Error is as following. File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask/app.py", line 1982, in wsgi_app response = self.full_dispatch_request() File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask/app.py", line 1614, in full_dispatch_request rv = self.handle_user_exception(e) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask/app.py", line 1517, in handle_user_exception reraise(exc_type, exc_value, tb) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask/_compat.py", line 33, in reraise raise value File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask/app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask/app.py", line 1598, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/security/decorators.py", line 26, in wraps return f(self, *args, **kwargs) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/views.py", line 453, in list widgets=widgets) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/baseviews.py", line 158, in render_template return render_template(template, **dict(list(kwargs.items()) + list(self.extra_args.items()))) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask/templating.py", line 134, in render_template context, ctx.app) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask/templating.py", line 116, in _render rv = template.render(context) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/jinja2/environment.py", line 1008, in render return self.environment.handle_exception(exc_info, True) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/jinja2/environment.py", line 780, in handle_exception reraise(exc_type, exc_value, tb) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/jinja2/_compat.py", line 37, in reraise raise value.with_traceback(tb) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/templates/appbuilder/general/model/list.html", line 2, in top-level template code {% import 'appbuilder/general/lib.html' as lib %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/templates/appbuilder/base.html", line 1, in top-level template code {% extends base_template %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/superset/templates/superset/base.html", line 1, in top-level template code {% extends "appbuilder/baselayout.html" %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/superset/templates/appbuilder/baselayout.html", line 2, in top-level template code {% import 'appbuilder/baselib.html' as baselib %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/templates/appbuilder/init.html", line 46, in top-level template code {% block body %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/superset/templates/appbuilder/baselayout.html", line 21, in block "body" {% block content %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/templates/appbuilder/general/model/list.html", line 13, in block "content" {% block list_list scoped %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/templates/appbuilder/general/model/list.html", line 15, in block "list_list" {{ widgets.get('list')()|safe }} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/widgets.py", line 34, in __call__ return template.render(args) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/jinja2/environment.py", line 1008, in render return self.environment.handle_exception(exc_info, True) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/jinja2/environment.py", line 780, in handle_exception reraise(exc_type, exc_value, tb) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/jinja2/_compat.py", line 37, in reraise raise value.with_traceback(tb) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/templates/appbuilder/general/widgets/list.html", line 2, in top-level template code {% extends 'appbuilder/general/widgets/base_list.html' %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/templates/appbuilder/general/widgets/base_list.html", line 23, in top-level template code {% block begin_loop_values %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/templates/appbuilder/general/widgets/list.html", line 45, in block "begin_loop_values" {% for item in value_columns %} File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/jinja2/runtime.py", line 435, in __init__ self._after = self._safe_next() File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/jinja2/runtime.py", line 455, in _safe_next return next(self._iterator) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/models/base.py", line 87, in get_values retdict[col] = self._get_attr_value(item, col) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_appbuilder/models/base.py", line 36, in _get_attr_value if not hasattr(item, col): File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/superset/models.py", line 712, in backend url = make_url(self.sqlalchemy_uri_decrypted) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/superset/models.py", line 859, in sqlalchemy_uri_decrypted return str(conn) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/engine/url.py", line 90, in __str__ return self.__to_string__(hide_password=False) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/engine/url.py", line 72, in __to_string__ else _rfc_1738_quote(self.password)) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/engine/url.py", line 247, in _rfc_1738_quote return re.sub(r'[:@/]', lambda m: "%%%X" % ord(m.group(0)), text) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/re.py", line 179, in sub return _compile(pattern, flags).sub(repl, string, count) TypeError: can't use a string pattern on a bytes-like object ... View more

Using HDP-2.6.4.0. Enabled apache superset service. Service start is failing with following error. I am using postgresql as database for storing superset metadata. 2018-08-28 10:05:16,587:INFO:root:Creating database reference Loaded your LOCAL configuration Traceback (most recent call last): File "/usr/hdp/current/superset/bin/superset", line 85, in <module> manager.run() File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_script/__init__.py", line 412, in run result = self.handle(sys.argv[0], sys.argv[1:]) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_script/__init__.py", line 383, in handle res = handle(*args, **config) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/flask_script/commands.py", line 216, in __call__ return self.run(*args, **kwargs) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/superset/cli.py", line 27, in init security.sync_role_definitions() File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/superset/security.py", line 122, in sync_role_definitions get_or_create_main_db() File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/superset/security.py", line 96, in get_or_create_main_db .filter_by(database_name='main') File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2690, in first ret = list(self[0:1]) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2482, in __getitem__ return list(res) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/orm/loading.py", line 90, in instances util.raise_from_cause(err) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 187, in reraise raise value File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/orm/loading.py", line 75, in instances rows = [proc(row) for row in fetch] File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/orm/loading.py", line 75, in <listcomp> rows = [proc(row) for row in fetch] File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/orm/loading.py", line 437, in _instance loaded_instance, populate_existing, populators) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/orm/loading.py", line 498, in _populate_full dict_[key] = getter(row) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy/sql/type_api.py", line 1122, in process return process_value(impl_processor(value), dialect) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy_utils/types/encrypted.py", line 266, in process_result_value decrypted_value = self.engine.decrypt(value) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/site-packages/sqlalchemy_utils/types/encrypted.py", line 90, in decrypt decrypted = base64.b64decode(value) File "/usr/hdp/2.6.4.0-91/superset/lib/python3.4/base64.py", line 90, in b64decode return binascii.a2b_base64(s) binascii.Error: Incorrect padding Looks like a malformed string getting passed to base64.b64decode() function ... View more

I am running HDP 2.6.0 with zeppelin configured with Active Directory for authentication. Is there a way to pass on the currently logged-in zeppelin user to JDBC data sources such as a hive instance. (This hive instance is also configured with the same Active Directory instance via ranger) ... View more