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

from mysql to postgresql create table #53

Open
tomfred23 opened this issue Apr 19, 2020 · 0 comments
Open

from mysql to postgresql create table #53

tomfred23 opened this issue Apr 19, 2020 · 0 comments

Comments

@tomfred23
Copy link

migrate from mysql to postgresql,errors as below
ETLAlchemySource (INFO) - --> Creating table 'cust_work'
*************************** column cust_work.id VARCHAR(32) <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x7f87861657b8>
*************************** column cust_work.apply_no VARCHAR(120) <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x7f87861657b8>
*************************** column cust_work.customerid VARCHAR(120) <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x7f87861657b8>
*************************** column cust_work.department VARCHAR(120) <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x7f87861657b8>
*************************** column cust_work.occupation VARCHAR(27) <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x7f87861657b8>
*************************** column cust_work.headship VARCHAR(120) <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x7f87861657b8>
*************************** column cust_work.posion_level VARCHAR(120) <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x7f87861657b8>
*************************** column cust_work.work_begin_date _NumericType(precision=5, scale=2) <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x7f87861657b8>
ETLAlchemySource (ERROR) - Failed to create table 'cust_work'

'_NumericType' object has no attribute 'dialect_impl'

File "/root/anaconda3/envs/etl/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py", line 1819, in get_column_specification
impl_type = column.type.dialect_impl(self.dialect)
AttributeError: '_NumericType' object has no attribute 'dialect_impl'

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