[
https://issues.apache.org/jira/browse/SPARK-31385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wenchen Fan updated SPARK-31385:
--------------------------------
Parent: SPARK-31404
Issue Type: Sub-task (was: Bug)
> Results of Julian-Gregorian rebasing don't match to Gregorian-Julian rebasing
> -----------------------------------------------------------------------------
>
> Key: SPARK-31385
> URL: https://issues.apache.org/jira/browse/SPARK-31385
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Maxim Gekk
> Priority: Major
>
> Microseconds rebasing from the hybrid calendar (Julian + Gregorian) to
> Proleptic Gregorian calendar is not symmetric to opposite conversion for the
> following time zones:
> # Asia/Tehran
> # Iran
> # Africa/Casablanca
> # Africa/El_Aaiun
> Here is the results from the https://github.com/apache/spark/pull/28119:
> Julian -> Gregorian:
> {code:json}
> , {
> "tz" : "Asia/Tehran",
> "switches" : [ -62135782200, -59006460600, -55850700600, -52694940600,
> -46383420600, -43227660600, -40071900600, -33760380600, -30604620600,
> -27448860600, -21137340600, -17981580600, -14825820600, -12219305400,
> -2208988800, 2547315000, 2547401400 ],
> "diffs" : [ 173056, 86656, 256, -86144, -172544, -258944, -345344, -431744,
> -518144, -604544, -690944, -777344, -863744, 256, 0, -3600, 0 ]
> }, {
> "tz" : "Iran",
> "switches" : [ -62135782200, -59006460600, -55850700600, -52694940600,
> -46383420600, -43227660600, -40071900600, -33760380600, -30604620600,
> -27448860600, -21137340600, -17981580600, -14825820600, -12219305400,
> -2208988800, 2547315000, 2547401400 ],
> "diffs" : [ 173056, 86656, 256, -86144, -172544, -258944, -345344, -431744,
> -518144, -604544, -690944, -777344, -863744, 256, 0, -3600, 0 ]
> }, {
> "tz" : "Africa/Casablanca",
> "switches" : [ -62135769600, -59006448000, -55850688000, -52694928000,
> -46383408000, -43227648000, -40071888000, -33760368000, -30604608000,
> -27448848000, -21137328000, -17981568000, -14825808000, -12219292800,
> -2208988800, 2141866800, 2169079200, 2172106800, 2199924000, 2202951600,
> 2230164000, 2233796400, 2261008800, 2264036400, 2291248800, 2294881200,
> 2322093600, 2325121200, 2352938400, 2355966000, 2383178400, 2386810800,
> 2414023200, 2417050800, 2444868000, 2447895600, 2475108000, 2478740400,
> 2505952800, 2508980400, 2536192800, 2539825200, 2567037600, 2570065200,
> 2597882400, 2600910000, 2628122400, 2631754800, 2658967200, 2661994800,
> 2689812000, 2692839600, 2720052000, 2723684400, 2750896800, 2753924400,
> 2781136800, 2784769200, 2811981600, 2815009200, 2842826400, 2845854000,
> 2873066400, 2876698800, 2903911200, 2906938800, 2934756000, 2937783600,
> 2964996000, 2968023600, 2995840800, 2998868400, 3026080800, 3029713200,
> 3056925600, 3059953200, 3087770400, 3090798000, 3118010400, 3121642800,
> 3148855200, 3151882800, 3179700000, 3182727600, 3209940000, 3212967600,
> 3240784800, 3243812400, 3271024800, 3274657200, 3301869600, 3304897200,
> 3332714400, 3335742000, 3362954400, 3366586800, 3393799200, 3396826800,
> 3424644000, 3427671600, 3454884000, 3457911600, 3485728800, 3488756400,
> 3515968800, 3519601200, 3546813600, 3549841200, 3577658400, 3580686000,
> 3607898400, 3611530800, 3638743200, 3641770800, 3669588000, 3672615600,
> 3699828000, 3702855600 ],
> "diffs" : [ 174620, 88220, 1820, -84580, -170980, -257380, -343780,
> -430180, -516580, -602980, -689380, -775780, -862180, 1820, 0, -3600, 0,
> -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600,
> 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0,
> -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600,
> 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0,
> -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600,
> 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0,
> -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600 ]
> }, {
> "tz" : "Africa/El_Aaiun",
> "switches" : [ -62135769600, -59006448000, -55850688000, -52694928000,
> -46383408000, -43227648000, -40071888000, -33760368000, -30604608000,
> -27448848000, -21137328000, -17981568000, -14825808000, -12219292800,
> -2208988800, 2141866800, 2169079200, 2172106800, 2199924000, 2202951600,
> 2230164000, 2233796400, 2261008800, 2264036400, 2291248800, 2294881200,
> 2322093600, 2325121200, 2352938400, 2355966000, 2383178400, 2386810800,
> 2414023200, 2417050800, 2444868000, 2447895600, 2475108000, 2478740400,
> 2505952800, 2508980400, 2536192800, 2539825200, 2567037600, 2570065200,
> 2597882400, 2600910000, 2628122400, 2631754800, 2658967200, 2661994800,
> 2689812000, 2692839600, 2720052000, 2723684400, 2750896800, 2753924400,
> 2781136800, 2784769200, 2811981600, 2815009200, 2842826400, 2845854000,
> 2873066400, 2876698800, 2903911200, 2906938800, 2934756000, 2937783600,
> 2964996000, 2968023600, 2995840800, 2998868400, 3026080800, 3029713200,
> 3056925600, 3059953200, 3087770400, 3090798000, 3118010400, 3121642800,
> 3148855200, 3151882800, 3179700000, 3182727600, 3209940000, 3212967600,
> 3240784800, 3243812400, 3271024800, 3274657200, 3301869600, 3304897200,
> 3332714400, 3335742000, 3362954400, 3366586800, 3393799200, 3396826800,
> 3424644000, 3427671600, 3454884000, 3457911600, 3485728800, 3488756400,
> 3515968800, 3519601200, 3546813600, 3549841200, 3577658400, 3580686000,
> 3607898400, 3611530800, 3638743200, 3641770800, 3669588000, 3672615600,
> 3699828000, 3702855600 ],
> "diffs" : [ 175968, 89568, 3168, -83232, -169632, -256032, -342432,
> -428832, -515232, -601632, -688032, -774432, -860832, 3168, 0, -3600, 0,
> -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600,
> 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0,
> -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600,
> 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0,
> -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600,
> 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0,
> -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600, 0, -3600 ]
> }, {
> {code}
> Gregorian -> Julian
> {code:json}
> }, {
> "tz" : "Asia/Tehran",
> "switches" : [ -62135609144, -59006373944, -55850700344, -52695026744,
> -46383593144, -43227919544, -40072245944, -33760812344, -30605138744,
> -27449465144, -21138031544, -17982357944, -14826684344, -12219305144,
> -2208988800 ],
> "diffs" : [ -173056, -86656, -256, 86144, 172544, 258944, 345344, 431744,
> 518144, 604544, 690944, 777344, 863744, -256, 0 ]
> }, {
> "tz" : "Iran",
> "switches" : [ -62135609144, -59006373944, -55850700344, -52695026744,
> -46383593144, -43227919544, -40072245944, -33760812344, -30605138744,
> -27449465144, -21138031544, -17982357944, -14826684344, -12219305144,
> -2208988800 ],
> "diffs" : [ -173056, -86656, -256, 86144, 172544, 258944, 345344, 431744,
> 518144, 604544, 690944, 777344, 863744, -256, 0 ]
> }, {
> "tz" : "Africa/Casablanca",
> "switches" : [ -62135594980, -59006359780, -55850686180, -52695012580,
> -46383578980, -43227905380, -40072231780, -33760798180, -30605124580,
> -27449450980, -21138017380, -17982343780, -14826670180, -12219290980,
> -2208988800 ],
> "diffs" : [ -174620, -88220, -1820, 84580, 170980, 257380, 343780, 430180,
> 516580, 602980, 689380, 775780, 862180, -1820, 0 ]
> }, {
> "tz" : "Africa/El_Aaiun",
> "switches" : [ -62135593632, -59006358432, -55850684832, -52695011232,
> -46383577632, -43227904032, -40072230432, -33760796832, -30605123232,
> -27449449632, -21138016032, -17982342432, -14826668832, -12219289632,
> -2208988800 ],
> "diffs" : [ -175968, -89568, -3168, 83232, 169632, 256032, 342432, 428832,
> 515232, 601632, 688032, 774432, 860832, -3168, 0 ]
> }, {
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
