You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/03/05 10:51:50 UTC
[GitHub] [incubator-superset] ablegao opened a new issue #6977: Can't
determine which FROM clause to join from,
there are multiple FROMS which can join to this entity.
ablegao opened a new issue #6977: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity.
URL: https://github.com/apache/incubator-superset/issues/6977
python 3.6.6
Superset 0.999.0dev and pip install superset=[0.27.0, 0.28.0, 0.28.1, 0.29.0rc6, 0.29.0rc]
sqlalchemy==1.3.0
ERROR:
(pyweb) [root@li1853-91 incubator-superset]# superset db upgrade
* Tip: There are .env files present. Do "pip install python-dotenv" to use them.
INFO [alembic.runtime.migration] Context impl SQLiteImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running upgrade bddc498dd179 -> 4451805bbaa1, remove double percents
Traceback (most recent call last):
File "/usr/local/pyweb/bin/superset", line 4, in <module>
__import__('pkg_resources').run_script('apache-superset==0.999.0.dev0', 'superset')
File "/usr/local/pyweb/lib64/python3.6/site-packages/pkg_resources/__init__.py", line 666, in run_script
self.require(requires)[0].run_script(script_name, ns)
File "/usr/local/pyweb/lib64/python3.6/site-packages/pkg_resources/__init__.py", line 1446, in run_script
exec(code, namespace, namespace)
File "/usr/local/pyweb/lib/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/EGG-INFO/scripts/superset", line 31, in <module>
cli()
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 722, in __call__
return self.main(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask/cli.py", line 557, in main
return super(FlaskGroup, self).main(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 697, in main
rv = self.invoke(ctx)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 535, in invoke
return callback(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask/cli.py", line 412, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 535, in invoke
return callback(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask_migrate/cli.py", line 134, in upgrade
_upgrade(directory, revision, sql, tag, x_arg)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 95, in wrapped
f(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 280, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/command.py", line 276, in upgrade
script.run_env()
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/script/base.py", line 475, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/util/pyfiles.py", line 90, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/util/compat.py", line 156, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 678, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/usr/local/pyweb/lib64/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/superset/migrations/env.py", line 116, in <module>
run_migrations_online()
File "/usr/local/pyweb/lib64/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/superset/migrations/env.py", line 109, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/runtime/environment.py", line 839, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/runtime/migration.py", line 361, in run_migrations
step.migration_fn(**kw)
File "/usr/local/pyweb/lib64/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/superset/migrations/versions/4451805bbaa1_remove_double_percents.py", line 98, in upgrade
replace('%%', '%')
File "/usr/local/pyweb/lib64/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/superset/migrations/versions/4451805bbaa1_remove_double_percents.py", line 69, in replace
.join(Table)
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2189, in join
from_joinpoint=from_joinpoint,
File "<string>", line 2, in _join
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/base.py", line 220, in generate
fn(self, *args[1:], **kw)
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2368, in _join
left, right, onclause, prop, create_aliases, outerjoin, full
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2391, in _join_left_to_right
) = self._join_determine_implicit_left_side(left, right, onclause)
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2522, in _join_determine_implicit_left_side
"Can't determine which FROM clause to join "
sqlalchemy.exc.InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Try adding an explicit ON clause to help resolve the ambiguity.
(pyweb) [root@li1853-91 incubator-superset]# pip install sqlalchemy==1.3.0
Collecting sqlalchemy==1.3.0
Using cached https://files.pythonhosted.org/packages/35/9e/5eb467ed50cdd8e88b808a7e65045020fa12b3b9c2ab51de0f452d269d4d/SQLAlchemy-1.3.0.tar.gz
Installing collected packages: sqlalchemy
Found existing installation: SQLAlchemy 1.3.0b3
Uninstalling SQLAlchemy-1.3.0b3:
Successfully uninstalled SQLAlchemy-1.3.0b3
Running setup.py install for sqlalchemy ... done
Successfully installed sqlalchemy-1.3.0
(pyweb) [root@li1853-91 incubator-superset]# superset db upgrade
* Tip: There are .env files present. Do "pip install python-dotenv" to use them.
INFO [alembic.runtime.migration] Context impl SQLiteImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running upgrade bddc498dd179 -> 4451805bbaa1, remove double percents
Traceback (most recent call last):
File "/usr/local/pyweb/bin/superset", line 4, in <module>
__import__('pkg_resources').run_script('apache-superset==0.999.0.dev0', 'superset')
File "/usr/local/pyweb/lib64/python3.6/site-packages/pkg_resources/__init__.py", line 666, in run_script
self.require(requires)[0].run_script(script_name, ns)
File "/usr/local/pyweb/lib64/python3.6/site-packages/pkg_resources/__init__.py", line 1446, in run_script
exec(code, namespace, namespace)
File "/usr/local/pyweb/lib/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/EGG-INFO/scripts/superset", line 31, in <module>
cli()
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 722, in __call__
return self.main(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask/cli.py", line 557, in main
return super(FlaskGroup, self).main(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 697, in main
rv = self.invoke(ctx)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 535, in invoke
return callback(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask/cli.py", line 412, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/click/core.py", line 535, in invoke
return callback(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask_migrate/cli.py", line 134, in upgrade
_upgrade(directory, revision, sql, tag, x_arg)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 95, in wrapped
f(*args, **kwargs)
File "/usr/local/pyweb/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 280, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/command.py", line 276, in upgrade
script.run_env()
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/script/base.py", line 475, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/util/pyfiles.py", line 90, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/util/compat.py", line 156, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 678, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/usr/local/pyweb/lib64/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/superset/migrations/env.py", line 116, in <module>
run_migrations_online()
File "/usr/local/pyweb/lib64/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/superset/migrations/env.py", line 109, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/runtime/environment.py", line 839, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/local/pyweb/lib64/python3.6/site-packages/alembic/runtime/migration.py", line 361, in run_migrations
step.migration_fn(**kw)
File "/usr/local/pyweb/lib64/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/superset/migrations/versions/4451805bbaa1_remove_double_percents.py", line 98, in upgrade
replace('%%', '%')
File "/usr/local/pyweb/lib64/python3.6/site-packages/apache_superset-0.999.0.dev0-py3.6.egg/superset/migrations/versions/4451805bbaa1_remove_double_percents.py", line 69, in replace
.join(Table)
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2234, in join
from_joinpoint=from_joinpoint,
File "<string>", line 2, in _join
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/base.py", line 220, in generate
fn(self, *args[1:], **kw)
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2413, in _join
left, right, onclause, prop, create_aliases, outerjoin, full
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2436, in _join_left_to_right
) = self._join_determine_implicit_left_side(left, right, onclause)
File "/usr/local/pyweb/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2567, in _join_determine_implicit_left_side
"Can't determine which FROM clause to join "
sqlalchemy.exc.InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Try adding an explicit ON clause to help resolve the ambiguity.
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org