search

snowplow-archive / schema-guru

JSONs -> JSON Schema
http://snowplowanalytics.com
150 stars 20 forks source link

Support REVISION migration for properties becoming nullable #147

Closed alexanderdean closed 7 years ago

alexanderdean commented 8 years ago

This is a revision. I want to prioritize this one from #140 to check there aren't any issues around column placement

ALTER TABLE ADD COLUMN customer_id_new string null;
INSERT INTO customer_id_new SELECT from customer_id;
ALTER TABLE DROP COLUMN customer_id;
ALTER TABLE RENAME COLUMN customer_id_new TO customer_id
END TRANSACTION;
alexanderdean commented 7 years ago

@chuwy - this is in the wrong repo now - can you migrate over to https://github.com/snowplow/iglu please?

Could you also spend 30 mins and move over anything else which is no longer relevant?

chuwy commented 7 years ago

Migrated to https://github.com/snowplow/iglu/issues/238