Yup, makes total sense. Thank you for clarifying!

On Tue, Mar 21, 2017 at 12:31 PM, Nuria Ruiz <nuria@wikimedia.org> wrote:
>Say we we have a script that gets data from WikipediaZeroUsage_14574251, 
>would we need to temporarily change the script to get data from WikipediaZeroUsage_>>14574251_15423246 for like a day and then change it back >to WikipediaZeroUsage_14574251 or would that be a permanent change until another schema revision?

Sorry it was not clear, no. You would have a union in this case. 

For example:

-- renamed table, no more new records from 2017/03/23
select * from WikipediaZeroUsage_14574251_15423246 

UNION

-- new data gets entered here
select * from WikipediaZeroUsage_14574251



Make sense?

On Tue, Mar 21, 2017 at 12:00 PM, Mikhail Popov <mpopov@wikimedia.org> wrote:
On Tue, Mar 21, 2017 at 10:57 AM, Nuria Ruiz <nuria@wikimedia.org> wrote:
As new events are come for 'WikipediaZeroUsage' schema with schema version 14574251 the table WikipediaZeroUsage_14574251 will get recreated again, the only difference is that this new table will have different column length for varchar fields. 

I'm probably misreading this but it seems to contradict "Reportupdater queries that use eventlogging would need to be updated to select from the newly renamed tables"

Say we we have a script that gets data from WikipediaZeroUsage_14574251, would we need to temporarily change the script to get data from WikipediaZeroUsage_14574251_15423246 for like a day and then change it back to WikipediaZeroUsage_14574251 or would that be a permanent change until another schema revision?

I'm confused.

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics



_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics