If you use collections such as a map<text,text> you could get by with just upserts. A collection in a column gives you the ability to have “flexible” schema for your “documents” as in mongo while the regular fields can act as “records” as in a more Traditional table.
Rahul Singh Chief Executive Officer m 202.905.2818 Anant Corporation 1010 Wisconsin Ave NW, Suite 250 Washington, D.C. 20007 We build and manage digital business technology platforms. On Dec 17, 2018, 4:45 PM -0500, Mark Furlong <mfurl...@ancestry.com>, wrote: > Why would I want to use alter table vs upserts with the new document format? > > Mark Furlong > Sr. Database Administrator > mfurl...@ancestry.com > M: 801-859-7427 > O: 801-705-7115 > 1300 W Traverse Pkwy > Lehi, UT 84043 > > > > >
