Skip to content

from mysql to postgresql create table  #53

Description

@tomfred23

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'

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions