Yup, makes total sense. Thank you for clarifying!

On Tue, Mar 21, 2017 at 12:31 PM, Nuria Ruiz <[email protected]> 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 <[email protected]>
> wrote:
>
>> On Tue, Mar 21, 2017 at 10:57 AM, Nuria Ruiz <[email protected]> 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
>> [email protected]
>> https://lists.wikimedia.org/mailman/listinfo/analytics
>>
>>
>
> _______________________________________________
> Analytics mailing list
> [email protected]
> https://lists.wikimedia.org/mailman/listinfo/analytics
>
>
_______________________________________________
Analytics mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/analytics

Reply via email to