omejiasq commented on issue #10032: URL: https://github.com/apache/incubator-superset/issues/10032#issuecomment-674564894
Hello cgivre, I uninstalled sqlalchemy-drill of this way: pip uninstall sqlalchemy-drill, after i installed again with this command:pip install sqlalchemy-drill of this way:pip install sqlalchemy-drill (in this case I did not see any errors in the installation.). But i get the same error: AttributeError: module 'sqlalchemy_drill.drilldbapi' has no attribute 'Error' . I send you a complete log of superset: ---------------------------------------------------------------------------------------------------------------------------------------- 2020-08-16 13:31:18,186:DEBUG:urllib3.connectionpool:http://localhost:8047 "POST /query.json HTTP/1.1" 200 7674 2020-08-16 13:31:18,189:DEBUG:root:Mapping column name of Drill type VARCHAR to dtype object 2020-08-16 13:31:18,192:DEBUG:root:Mapping column isDirectory of Drill type BIT to dtype boolean 2020-08-16 13:31:18,196:ERROR:root:module 'sqlalchemy_drill.drilldbapi' has no attribute 'Error' Traceback (most recent call last): File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context cursor, statement, parameters, context File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute cursor.execute(statement, parameters) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy_drill/drilldbapi/_drilldbapi.py", line 69, in func_wrapper return func(self, *args, **kwargs) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy_drill/drilldbapi/_drilldbapi.py", line 186, in execute df[col_name] = df[col_name].astype(col_dtype) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/pandas/util/_decorators.py", line 178, in wrapper return func(*args, **kwargs) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/pandas/core/generic.py", line 5001, in astype **kwargs) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/pandas/core/internals.py", line 3714, in astype return self.apply('astype', dtype=dtype, **kwargs) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/pandas/core/internals.py", line 3581, in apply applied = getattr(b, f)(**kwargs) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/pandas/core/internals.py", line 575, in astype **kwargs) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/pandas/core/internals.py", line 636, in _astype dtype = np.dtype(dtype) TypeError: data type "boolean" not understood During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/superset/views/core.py", line 1781, in testconn return json_success(json.dumps(engine.table_names(), indent=4)) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2209, in table_names return self.dialect.get_table_names(conn, schema) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy_drill/base.py", line 283, in get_table_names curs = connection.execute("SHOW FILES FROM " + quoted_schema) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 974, in execute return self._execute_text(object_, multiparams, params) File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1147, in _execute_text parameters, File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context e, statement, parameters, cursor, context File "/home/edgarubuntustudio/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1347, in _handle_dbapi_exception isinstance(e, self.dialect.dbapi.Error) AttributeError: module 'sqlalchemy_drill.drilldbapi' has no attribute 'Error' ^C[2020-08-16 13:36:31 -0500] [2692] [INFO] Handling signal: int ---------------------------------------------------------------------------------------------------------------------------------------- My server has the following characteristics: 1. Ubuntu 18.04.5 2. Superset installed. I start superset of this way: . venv/bin/activate superset runserver 3. apache drill 1.16.0 version installed and running. I can see all the databases configured even with mongodb databases. 4. I have installed python 3.6.9 in my virtual environment where I run superset and sqlalchemy-drill. What can I do now? Or could we connect at some point and you will enter my server to check everything please? ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
