Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AssertionError: table not found #87

Closed
laughingman7743 opened this issue Jun 18, 2019 · 1 comment
Closed

AssertionError: table not found #87

laughingman7743 opened this issue Jun 18, 2019 · 1 comment

Comments

@laughingman7743
Copy link
Owner

https://travis-ci.org/laughingman7743/PyAthena/jobs/547213920

============================= test session starts ==============================
platform linux -- Python 3.7.1, pytest-4.6.3, py-1.8.0, pluggy-0.12.0
cachedir: .tox/py37/.pytest_cache
rootdir: /home/travis/build/laughingman7743/PyAthena, inifile: setup.cfg
plugins: cov-2.7.1, flake8-1.0.4
collected 146 items
setup.py .                                                               [  0%]
pyathena/__init__.py .                                                   [  1%]
pyathena/async_cursor.py .                                               [  2%]
pyathena/async_pandas_cursor.py .                                        [  2%]
pyathena/common.py .                                                     [  3%]
pyathena/connection.py .                                                 [  4%]
pyathena/converter.py .                                                  [  4%]
pyathena/cursor.py .                                                     [  5%]
pyathena/error.py .                                                      [  6%]
pyathena/formatter.py .                                                  [  6%]
pyathena/model.py .                                                      [  7%]
pyathena/pandas_cursor.py .                                              [  8%]
pyathena/result_set.py .                                                 [  8%]
pyathena/sqlalchemy_athena.py .                                          [  9%]
pyathena/util.py .                                                       [ 10%]
tests/__init__.py .                                                      [ 10%]
tests/conftest.py .                                                      [ 11%]
tests/test_async_cursor.py ...............                               [ 21%]
tests/test_async_pandas_cursor.py ..................                     [ 34%]
tests/test_cursor.py ................................                    [ 56%]
tests/test_formatter.py ......................                           [ 71%]
tests/test_pandas_cursor.py ...................                          [ 84%]
tests/test_result_set.py ...                                             [ 86%]
tests/test_sqlalchemy_athena.py ...........F.......                      [ 99%]
tests/util.py .                                                          [100%]
=================================== FAILURES ===================================
__________________ TestSQLAlchemyAthena.test_reflect_schemas ___________________
self = <tests.test_sqlalchemy_athena.TestSQLAlchemyAthena testMethod=test_reflect_schemas>
engine = Engine(awsathena+rest://athena.[secure].amazonaws.com:443/test_pyathena_qy34ol1req?s3_staging_dir=[secure])
connection = <sqlalchemy.engine.base.Connection object at 0x7fe6c557b208>
    @with_engine
    def test_reflect_schemas(self, engine, connection):
        insp = sqlalchemy.inspect(engine)
        schemas = insp.get_schema_names()
>       self.assertIn(SCHEMA, schemas)
E       AssertionError: 'test_pyathena_qy34ol1req' not found in []
tests/test_sqlalchemy_athena.py:106: AssertionError
=============================== warnings summary ===============================
tests/test_async_cursor.py::TestAsyncCursor::test_arraysize
  /home/travis/build/laughingman7743/PyAthena/.tox/py37/lib/python3.7/site-packages/botocore/vendored/requests/packages/urllib3/_collections.py:1: DeprecationWarning: Using or importing the ABCs from 'collections' instead of from 'collections.abc' is deprecated, and in 3.8 it will stop working
    from collections import Mapping, MutableMapping
tests/test_sqlalchemy_athena.py::TestSQLAlchemyAthena::test_reflect_select
  /home/travis/build/laughingman7743/PyAthena/.tox/py37/lib/python3.7/site-packages/sqlalchemy/sql/sqltypes.py:665: SAWarning: Dialect awsathena+rest does *not* support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage.
    "storage." % (dialect.name, dialect.driver)
-- Docs: https://docs.pytest.org/en/latest/warnings.html
----------- coverage: platform linux, python 3.7.1-final-0 -----------
Name                              Stmts   Miss  Cover
-----------------------------------------------------
pyathena/__init__.py                 33      5    85%
pyathena/async_cursor.py             46      3    93%
pyathena/async_pandas_cursor.py      18      3    83%
pyathena/common.py                  107     12    89%
pyathena/connection.py               69      9    87%
pyathena/converter.py                61     12    80%
pyathena/cursor.py                   45      0   100%
pyathena/error.py                    23      0   100%
pyathena/formatter.py                66      2    97%
pyathena/model.py                    51      4    92%
pyathena/pandas_cursor.py            50      0   100%
pyathena/result_set.py              276     17    94%
pyathena/sqlalchemy_athena.py       102      7    93%
pyathena/util.py                     26      3    88%
-----------------------------------------------------
TOTAL                               973     77    92%
Coverage HTML written to dir htmlcov
============== 1 failed, 145 passed, 2 warnings in 222.30 seconds ==============
ERROR: InvocationError for command /home/travis/build/laughingman7743/PyAthena/.tox/py37/bin/pytest --cov pyathena --cov-report html --cov-report term --flake8 (exited with code 1)
___________________________________ summary ____________________________________
ERROR:   py37: commands failed
The command "tox" exited with 1.
@laughingman7743
Copy link
Owner Author

There seems to be no problem now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant