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'
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'