Closed rajrohith closed 7 years ago
Hi Sean, i am trying to migrate from postgresql to MYsql and getting error below
ETLAlchemySource (ERROR) - Failed to create table 'dimingredient' (_mysql_exceptions.OperationalError) (1067, "Invalid default value for 'dr_start'") [SQL: u'\nCREATE TABLE dimingredient (\n\tdr_id INTEGER NOT NULL, \n\tdr_loadtime TIMESTAMP NOT NULL, \n\tdr_start TIMESTAMP NOT NULL, \n\tdr_end TIMESTAMP NOT NULL, \n\tdr_current BOOL NOT NULL, \n\tcasnumber VARCHAR(100) NOT NULL, \n\tingredientname VARCHAR(300), \n\tmatchingstrategy VARCHAR(21), \n\tpercentofconfidence NUMERIC(12, 10), \n\tdisclosurestatus VARCHAR(42), \n\tissand VARCHAR(1), \n\tsandmeshsize VARCHAR(20), \n\tsandquality VARCHAR(20), \n\tisresincoated VARCHAR(1), \n\tisartificial VARCHAR(1), \n\tCHECK (dr_current IN (0, 1))\n)\n\n'] Traceback (most recent call last):
Please guide me in this regards Thanks Raj
Hi Sean, i am trying to migrate from postgresql to MYsql and getting error below
ETLAlchemySource (ERROR) - Failed to create table 'dimingredient' (_mysql_exceptions.OperationalError) (1067, "Invalid default value for 'dr_start'") [SQL: u'\nCREATE TABLE dimingredient (\n\tdr_id INTEGER NOT NULL, \n\tdr_loadtime TIMESTAMP NOT NULL, \n\tdr_start TIMESTAMP NOT NULL, \n\tdr_end TIMESTAMP NOT NULL, \n\tdr_current BOOL NOT NULL, \n\tcasnumber VARCHAR(100) NOT NULL, \n\tingredientname VARCHAR(300), \n\tmatchingstrategy VARCHAR(21), \n\tpercentofconfidence NUMERIC(12, 10), \n\tdisclosurestatus VARCHAR(42), \n\tissand VARCHAR(1), \n\tsandmeshsize VARCHAR(20), \n\tsandquality VARCHAR(20), \n\tisresincoated VARCHAR(1), \n\tisartificial VARCHAR(1), \n\tCHECK (dr_current IN (0, 1))\n)\n\n'] Traceback (most recent call last):
Please guide me in this regards Thanks Raj