You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Wenchen Fan (Jira)" <ji...@apache.org> on 2020/10/13 13:24:00 UTC
[jira] [Assigned] (SPARK-13860) TPCDS query 39 returns wrong
results compared to TPC official result set
[ https://issues.apache.org/jira/browse/SPARK-13860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan reassigned SPARK-13860:
-----------------------------------
Assignee: Leanken.Lin
> TPCDS query 39 returns wrong results compared to TPC official result set
> -------------------------------------------------------------------------
>
> Key: SPARK-13860
> URL: https://issues.apache.org/jira/browse/SPARK-13860
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.6.0, 2.1.1, 2.2.0
> Reporter: JESSE CHEN
> Assignee: Leanken.Lin
> Priority: Major
> Labels: bulk-closed, tpcds-result-mismatch
>
> Testing Spark SQL using TPC queries. Query 39 returns wrong results compared to official result set. This is at 1GB SF (validation run).
> q39a - 3 extra rows in SparkSQL output (eg. [1,1155,1,184.0,NaN,1,1155,2,343.3333333333333,1.1700233592269733]) ; q39b - 3 extra rows in SparkSQL output (eg. [1,1155,1,184.0,NaN,1,1155,2,343.3333333333333,1.1700233592269733])
> Actual results 39a:
> {noformat}
> [1,265,1,324.75,1.2438391781531353,1,265,2,329.0,1.0151581328149208]
> [1,363,1,499.5,1.031941572270649,1,363,2,321.0,1.1411766752007977]
> [1,679,1,373.75,1.0955498064867504,1,679,2,417.5,1.042970994259454]
> [1,695,1,450.75,1.0835888283564505,1,695,2,368.75,1.1356494125569416]
> [1,789,1,357.25,1.03450938027956,1,789,2,410.0,1.0284221852702604]
> [1,815,1,216.5,1.1702270938111008,1,815,2,150.5,1.3057281471249382]
> [1,827,1,271.75,1.1046890134130438,1,827,2,424.75,1.1653198631238286]
> [1,1041,1,382.5,1.284808399803008,1,1041,2,424.75,1.000577271456812]
> [1,1155,1,184.0,NaN,1,1155,2,343.3333333333333,1.1700233592269733]
> [1,1569,1,212.0,1.630213519639535,1,1569,2,239.25,1.2641513267800557]
> [1,1623,1,338.25,1.1285483279713715,1,1623,2,261.3333333333333,1.2717809002195564]
> [1,2581,1,448.5,1.060429041250449,1,2581,2,476.25,1.0362984739390064]
> [1,2705,1,246.25,1.0120308357959693,1,2705,2,294.6666666666667,1.0742134101583702]
> [1,3131,1,393.75,1.0037613982687346,1,3131,2,480.5,1.0669144981482768]
> [1,3291,1,374.5,1.195189833087008,1,3291,2,265.25,1.572972106948466]
> [1,3687,1,279.75,1.4260909081999698,1,3687,2,157.25,1.4534340882531784]
> [1,4955,1,495.25,1.0318296151625301,1,4955,2,322.5,1.1693842343776149]
> [1,5627,1,282.75,1.5657032366359889,1,5627,2,297.5,1.2084286841430678]
> [1,7017,1,175.5,1.0427454215644427,1,7017,2,321.3333333333333,1.0183356932936254]
> [1,7317,1,366.3333333333333,1.025466403613547,1,7317,2,378.0,1.2172513189920555]
> [1,7569,1,430.5,1.0874396852180854,1,7569,2,360.25,1.047005559314515]
> [1,7999,1,166.25,1.7924231710846223,1,7999,2,375.3333333333333,1.008092263550718]
> [1,8319,1,306.75,1.1615378040478215,1,8319,2,276.0,1.1420996385609428]
> [1,8443,1,327.75,1.256718374192724,1,8443,2,332.5,1.0044167259988928]
> [1,8583,1,319.5,1.024108893111539,1,8583,2,310.25,1.2358813775861328]
> [1,8591,1,398.0,1.1478168692042447,1,8591,2,355.75,1.0024472149348966]
> [1,8611,1,300.5,1.5191545184147954,1,8611,2,243.75,1.2342122780960432]
> [1,9081,1,367.0,1.0878932141280895,1,9081,2,435.0,1.0330530776324107]
> [1,9357,1,351.6666666666667,1.1902922622025887,1,9357,2,427.0,1.0438583026358363]
> [1,9449,1,406.25,1.0183183104803557,1,9449,2,175.0,1.0544779796296408]
> [1,9713,1,242.5,1.1035044355064203,1,9713,2,393.0,1.208474608738988]
> [1,9809,1,479.0,1.0189602512117633,1,9809,2,317.5,1.0614142074924882]
> [1,9993,1,417.75,1.0099832672435247,1,9993,2,204.5,1.552870745350107]
> [1,10127,1,239.75,1.0561770587198123,1,10127,2,359.25,1.1857980403742183]
> [1,11159,1,407.25,1.0785507154337637,1,11159,2,250.0,1.334757905639321]
> [1,11277,1,211.25,1.2615858275316627,1,11277,2,330.75,1.0808767951625093]
> [1,11937,1,344.5,1.085804026843784,1,11937,2,200.33333333333334,1.0638527063883725]
> [1,12373,1,387.75,1.1014904822941258,1,12373,2,306.0,1.0761744390394028]
> [1,12471,1,365.25,1.0607570183728479,1,12471,2,327.25,1.0547560580567852]
> [1,12625,1,279.0,1.3016560542373208,1,12625,2,443.25,1.0604958838068959]
> [1,12751,1,280.75,1.10833057888089,1,12751,2,369.3333333333333,1.3416504398884601]
> [1,12779,1,331.0,1.041690207320035,1,12779,2,359.0,1.028978056175258]
> [1,13077,1,367.6666666666667,1.345523904195734,1,13077,2,358.6666666666667,1.5132429058096555]
> [1,13191,1,260.25,1.063569632291568,1,13191,2,405.0,1.0197999172180061]
> [1,13561,1,335.25,1.2609616961776389,1,13561,2,240.0,1.0513604502245155]
> [1,13935,1,311.75,1.0399289695412326,1,13935,2,275.0,1.0367527180321774]
> [1,14687,1,358.0,1.4369356919381713,1,14687,2,187.0,1.5493631531474956]
> [1,14719,1,209.0,1.0411509639707628,1,14719,2,489.0,1.376616882800804]
> [1,15345,1,148.5,1.5295784035794024,1,15345,2,246.5,1.5087987747231526]
> [1,15427,1,482.75,1.0124238928335043,1,15427,2,333.25,1.2724770126308678]
> [1,15647,1,201.66666666666666,1.2857931876095743,1,15647,2,249.25,1.3648172990142162]
> [1,16079,1,280.5,1.2444757416128578,1,16079,2,361.25,1.0737805704078724]
> [1,16223,1,245.66666666666666,1.0601148956398867,1,16223,2,412.6666666666667,1.0671231071323724]
> [1,16289,1,171.0,1.087263313842661,1,16289,2,316.5,1.3695306694071203]
> [1,16451,1,300.0,1.2516507618459831,1,16451,2,467.5,1.2962363881858208]
> [1,17051,1,349.75,1.1346423819845488,1,17051,2,319.75,1.0379354897438076]
> [2,71,1,221.5,1.563974108334745,2,71,2,309.0,1.4917057895885681]
> [2,833,1,363.3333333333333,1.0422813802180273,2,833,2,158.75,1.2130891736268552]
> [2,969,1,282.0,1.1374340344037195,2,969,2,386.0,1.1371001187232186]
> [2,1401,1,249.0,1.3206237689155225,2,1401,2,296.6666666666667,1.2868121931744592]
> [2,1681,1,337.75,1.052156598827189,2,1681,2,252.75,1.03179106854817]
> [2,1991,1,356.0,1.1336790046919885,2,1991,2,273.25,1.3324196418089087]
> [2,2031,1,407.5,1.0209876826110387,2,2031,2,418.75,1.0053388632912839]
> [2,2481,1,319.75,1.116026660755801,2,2481,2,378.3333333333333,1.0597185274084644]
> [2,2725,1,349.75,1.1148704918064747,2,2725,2,265.6666666666667,1.5462972148471539]
> [2,3073,1,385.0,1.1020845844189129,2,3073,2,231.75,1.0884989063827268]
> [2,3769,1,334.0,1.19542966145639,2,3769,2,335.0,1.049464958250903]
> [2,4085,1,327.75,1.1005413873145125,2,4085,2,281.75,1.0187608064801108]
> [2,4995,1,282.25,1.260418332957406,2,4995,2,248.0,1.2548229018823531]
> [2,5099,1,418.6666666666667,1.0680900887970652,2,5099,2,428.6666666666667,1.035237277800474]
> [2,5211,1,157.0,1.069551742865467,2,5211,2,270.25,1.1940200809618973]
> [2,5429,1,152.0,NaN,2,5429,2,355.25,1.1230959744909077]
> [2,5769,1,341.25,1.2723132696563741,2,5769,2,267.0,1.1815791848719037]
> [2,6103,1,194.33333333333334,1.5160670179307387,2,6103,2,158.5,1.2743698636165062]
> [2,6243,1,168.5,1.0732108100023512,2,6243,2,386.75,1.083290260548026]
> [2,6489,1,268.0,1.6956372368432269,2,6489,2,389.0,1.4105780519299767]
> [2,6585,1,183.75,1.1151937581317735,2,6585,2,353.75,1.09397071467533]
> [2,6767,1,341.0,1.093163984134538,2,6767,2,235.0,1.1399543855818017]
> [2,7411,1,460.0,1.0628293255143475,2,7411,2,297.5,1.000576535072398]
> [2,8489,1,126.75,1.341646295852091,2,8489,2,398.25,1.0041124840252154]
> [2,8633,1,218.5,1.4645189740171023,2,8633,2,230.25,1.3116963014576621]
> [2,8807,1,417.25,1.0258112930013772,2,8807,2,356.25,1.1079730633089233]
> [2,8883,1,249.25,1.1112271782210548,2,8883,2,189.25,1.010075485139798]
> [2,9253,1,413.3333333333333,1.1606659948102405,2,9253,2,465.0,1.0242445824028785]
> [2,9467,1,108.25,1.091122388968745,2,9467,2,107.0,1.0309220361224432]
> [2,9561,1,190.5,1.0303032513373167,2,9561,2,271.0,1.2058349535542998]
> [2,9575,1,452.5,1.0494492226058958,2,9575,2,155.75,1.1534056685643725]
> [2,9903,1,322.75,1.0761080062556017,2,9903,2,387.3333333333333,1.2612406773451965]
> [2,10535,1,324.3333333333333,1.0571104035094094,2,10535,2,310.25,1.0040634995190338]
> [2,10955,1,356.0,1.1582813310955151,2,10955,2,339.0,1.070253213625449]
> [2,12089,1,212.0,1.0827501145734215,2,12089,2,173.33333333333334,1.0739812153327328]
> [2,12633,1,402.75,1.0071362075740695,2,12633,2,367.0,1.1270535638607155]
> [2,12765,1,308.0,1.1188476882701337,2,12765,2,347.0,1.1571744590236304]
> [2,13077,1,277.0,1.2323360849352152,2,13077,2,223.5,1.139400344912951]
> [2,13687,1,361.25,1.0107341657610867,2,13687,2,468.25,1.00984291842181]
> [2,14025,1,371.75,1.0150136083050016,2,14025,2,141.0,1.2543170259746204]
> [2,14117,1,298.5,1.0251238034747268,2,14117,2,220.25,1.4152684465941172]
> [2,14347,1,366.0,1.0327892946261927,2,14347,2,369.75,1.0185739900192863]
> [2,14697,1,397.75,1.008120541714483,2,14697,2,328.75,1.160849558029165]
> [2,14987,1,146.75,1.0290040643611427,2,14987,2,436.5,1.0447681541795646]
> [2,15321,1,527.0,1.2102662554654002,2,15321,2,298.75,1.1309098406792113]
> [2,15347,1,243.0,1.22262397963835,2,15347,2,310.75,1.2036584852655927]
> [2,15533,1,223.0,1.096511132968014,2,15533,2,330.0,1.4967488488790472]
> [2,15839,1,353.0,1.5063684437542906,2,15839,2,255.5,1.2362393182894105]
> [2,16107,1,376.0,1.0133246306103783,2,16107,2,364.75,1.0688677983776653]
> [2,16749,1,200.0,1.0944709528656604,2,16749,2,438.25,1.0360646618074532]
> [2,17329,1,321.3333333333333,1.3093279467658028,2,17329,2,490.25,1.0756580649722338]
> [2,17417,1,321.75,1.1306764803839018,2,17417,2,534.0,1.0010725216798313]
> [3,1049,1,252.5,1.1090641101125922,3,1049,2,457.25,1.023984124924537]
> [3,1415,1,247.5,1.1321617788582448,3,1415,2,369.75,1.095467956288316]
> [3,2199,1,185.75,1.2028125570694115,3,2199,2,300.75,1.0767845064923047]
> [3,2403,1,270.75,1.3258705678179297,3,2403,2,384.0,1.0903987183011015]
> [3,2541,1,364.75,1.079213526102894,3,2541,2,550.5,1.0545588871101828]
> [3,2727,1,303.75,1.030164700291085,3,2727,2,219.25,1.3822091831959378]
> [3,3207,1,383.75,1.0854588026477912,3,3207,2,258.25,1.2113392480929654]
> [3,3373,1,404.5,1.0143374143806878,3,3373,2,171.25,1.2856653974632997]
> [3,3969,1,234.25,1.0422831793090308,3,3969,2,217.25,1.4215490653321186]
> [3,4407,1,438.5,1.0656663545113982,3,4407,2,330.75,1.0244403968428872]
> [3,6051,1,289.75,1.263888088484336,3,6051,2,439.0,1.1045769245192738]
> [3,6521,1,381.0,1.001568291887839,3,6521,2,437.75,1.0365149332658257]
> [3,6691,1,377.0,1.1090737292917523,3,6691,2,380.5,1.0581301250281556]
> [3,6757,1,282.5,1.089500938688411,3,6757,2,345.25,1.2263828747838474]
> [3,6915,1,420.6666666666667,1.0468345634906968,3,6915,2,292.5,1.2506171072716117]
> [3,7207,1,329.6666666666667,1.5954482160720393,3,7207,2,414.5,1.017919707908937]
> [3,7889,1,318.5,1.2879030049985103,3,7889,2,291.3333333333333,1.0042925323922787]
> [3,8559,1,356.25,1.0065193461695627,3,8559,2,393.5,1.0128831652141206]
> [3,8829,1,364.25,1.0792852260446875,3,8829,2,350.25,1.1133912240741104]
> [3,9555,1,377.0,1.1308469328910158,3,9555,2,444.75,1.0171588175042319]
> [3,9623,1,331.3333333333333,1.1551289271934477,3,9623,2,284.6666666666667,1.030372442625732]
> [3,9813,1,343.75,1.0516953753508833,3,9813,2,384.6666666666667,1.0815005906604849]
> [3,9881,1,351.5,1.1788820554157222,3,9881,2,287.75,1.0909386089510784]
> [3,10035,1,378.25,1.0216399511791376,3,10035,2,364.25,1.1567922653398062]
> [3,10509,1,420.25,1.0548626901275737,3,10509,2,368.25,1.1820633359473098]
> [3,10547,1,182.33333333333334,1.5325641514869042,3,10547,2,320.25,1.302441844373152]
> [3,10743,1,233.25,1.2793022354241157,3,10743,2,110.25,1.107204634127507]
> [3,11477,1,264.25,1.0953530000836025,3,11477,2,278.5,1.03279098170704]
> [3,11959,1,358.0,1.0684835251792983,3,11959,2,268.5,1.0089856798911991]
> [3,12043,1,169.25,1.033093808880221,3,12043,2,377.25,1.0161962499718764]
> [3,12157,1,326.3333333333333,1.0022318670551493,3,12157,2,396.3333333333333,1.0287818050404882]
> [3,12433,1,199.75,1.307258924061962,3,12433,2,478.5,1.0164742071947392]
> [3,12867,1,278.25,1.6403800123947352,3,12867,2,350.75,1.2006933321742796]
> [3,13499,1,281.0,1.1431965457521192,3,13499,2,446.75,1.0331520262675382]
> [3,14589,1,266.5,1.1143243921844956,3,14589,2,334.3333333333333,1.1453146816350117]
> [3,15207,1,300.25,1.4844611263753311,3,15207,2,564.0,1.0004808712533066]
> [3,15395,1,258.25,1.0513876898285774,3,15395,2,307.5,1.138225319310722]
> [3,15973,1,477.5,1.203932592889347,3,15973,2,286.0,1.2872294241999072]
> [3,16233,1,260.6666666666667,1.120423550056809,3,16233,2,210.5,1.1788143336685517]
> [3,16267,1,456.0,1.00422634651884,3,16267,2,364.3333333333333,1.4818855428309732]
> [3,16605,1,394.25,1.1137413572906039,3,16605,2,296.25,1.2885892655671596]
> [3,16949,1,155.75,1.1186177285449939,3,16949,2,229.5,1.0289469196724543]
> [3,17319,1,364.75,1.2709364445674023,3,17319,2,359.25,1.1578751434862422]
> [4,947,1,247.5,1.6933181813486973,4,947,2,203.33333333333334,1.205433145161931]
> [4,1895,1,354.75,1.2397341541992284,4,1895,2,383.75,1.0893076992144062]
> [4,3429,1,358.5,1.0665593354923446,4,3429,2,346.0,1.251948930065546]
> [4,4559,1,215.0,1.2432329900432981,4,4559,2,360.75,1.0333545857247315]
> [4,4773,1,328.25,1.0509836592960142,4,4773,2,330.5,1.0062580596877206]
> [4,4885,1,151.0,1.3205570350636184,4,4885,2,377.25,1.0489035237886835]
> [4,4915,1,289.25,1.0863929490514617,4,4915,2,368.0,1.069658554605372]
> [4,5043,1,476.0,1.0155964276489484,4,5043,2,244.25,1.356289369084929]
> [4,5095,1,334.0,1.2258861291353158,4,5095,2,390.25,1.0621788063332436]
> [4,5193,1,263.3333333333333,1.250170954501139,4,5193,2,323.0,1.0979616195802828]
> [4,5975,1,434.0,1.0233614450980864,4,5975,2,359.75,1.1979356900084084]
> [4,6251,1,285.0,1.121538025585264,4,6251,2,335.5,1.1602192523957113]
> [4,6389,1,280.75,1.2049236089487845,4,6389,2,259.3333333333333,1.4816550575659286]
> [4,6487,1,452.75,1.0710626602211524,4,6487,2,350.5,1.17164756896522]
> [4,6619,1,430.0,1.0007262551157654,4,6619,2,226.25,1.548557450713079]
> [4,7191,1,260.75,1.0012666837154778,4,7191,2,195.25,1.5372675520067365]
> [4,7427,1,239.5,1.4183567144406795,4,7427,2,373.25,1.0429791976763843]
> [4,8453,1,314.75,1.0259714909803297,4,8453,2,376.75,1.0099023931660849]
> [4,8781,1,518.5,1.100549995019371,4,8781,2,521.0,1.123770469908755]
> [4,9571,1,314.0,1.216857824298178,4,9571,2,309.0,1.089216738940079]
> [4,9587,1,248.0,1.4981887260612339,4,9587,2,248.0,1.0064987840475923]
> [4,10249,1,240.75,1.6058403557773568,4,10249,2,689.0,NaN]
> [4,10333,1,321.0,1.1486107061789543,4,10333,2,317.0,1.0469226317412668]
> [4,10969,1,186.66666666666666,1.104420616413504,4,10969,2,307.0,1.1094764105733856]
> [4,10993,1,446.0,1.0092376322965588,4,10993,2,206.66666666666666,1.2355333519949105]
> [4,11571,1,342.5,1.142628399354839,4,11571,2,304.6666666666667,1.0319943224652848]
> [4,11979,1,225.33333333333334,1.4670656155247088,4,11979,2,438.25,1.1389926990347663]
> [4,13409,1,312.3333333333333,1.3427502512651466,4,13409,2,336.25,1.1081978302033695]
> [4,13443,1,417.75,1.0217796082231347,4,13443,2,334.0,1.3076430852966527]
> [4,13567,1,271.5,1.0087621621432743,4,13567,2,370.0,1.4557686063410562]
> [4,13683,1,318.75,1.0149827729946173,4,13683,2,363.5,1.0781154578332095]
> [4,14143,1,367.0,1.0441799438931547,4,14143,2,290.0,1.1933060754121454]
> [4,14401,1,342.75,1.1836559036030756,4,14401,2,344.25,1.2067083116272619]
> [4,14693,1,447.25,1.0516674911652102,4,14693,2,498.0,1.3517382644369342]
> [4,14877,1,414.3333333333333,1.1707723877930458,4,14877,2,282.5,1.5830582944346865]
> [4,15063,1,378.25,1.1128192588166839,4,15063,2,444.0,1.0632777688204158]
> [4,15275,1,335.5,1.1536382939175558,4,15275,2,292.6666666666667,1.2978313681037048]
> [4,15509,1,296.3333333333333,1.0246740536582173,4,15509,2,317.6666666666667,1.4470364565078238]
> [4,15969,1,423.0,1.0472875497665224,4,15969,2,342.5,1.2511769371808568]
> [4,16627,1,485.5,1.0151460895716244,4,16627,2,161.25,1.353325272620004]
> [4,16641,1,521.5,1.1050662064564454,4,16641,2,221.5,1.0308590510025117]
> [4,16751,1,549.5,1.082214382125362,4,16751,2,223.33333333333334,1.3377897605859543]
> [5,75,1,333.0,1.2656318762849212,5,75,2,226.0,1.0358078507992579]
> [5,125,1,441.6666666666667,1.095971457377544,5,125,2,331.5,1.0081148286008836]
> [5,431,1,159.0,1.1061794752181042,5,431,2,304.0,1.1224225373103636]
> [5,671,1,403.3333333333333,1.0056014147334147,5,671,2,281.3333333333333,1.3366835222521476]
> [5,745,1,466.75,1.0109065525578562,5,745,2,351.0,1.1147212881684183]
> [5,1701,1,374.0,1.086445817024878,5,1701,2,385.0,1.3306308700750535]
> [5,2521,1,360.75,1.099248234149208,5,2521,2,265.5,1.1724077694006725]
> [5,2855,1,406.0,1.4037637084639343,5,2855,2,183.25,1.0662249910239627]
> [5,3137,1,271.25,1.575453220592864,5,3137,2,380.0,1.0834203388600319]
> [5,3279,1,299.5,1.053669716363755,5,3279,2,276.75,1.4458878093841827]
> [5,3467,1,294.0,1.1477294638716873,5,3467,2,349.6666666666667,1.1674223692818808]
> [5,4463,1,338.0,1.0699320081481432,5,4463,2,273.5,1.2369797321835678]
> [5,4719,1,340.5,1.0571857801805542,5,4719,2,423.6666666666667,1.0255000206713487]
> [5,4739,1,281.3333333333333,1.0242971514325028,5,4739,2,383.5,1.0334337390189823]
> [5,4839,1,310.25,1.035903440911969,5,4839,2,232.0,1.2954193820330193]
> [5,4979,1,359.5,1.1046408074063157,5,4979,2,323.75,1.1704250950730493]
> [5,5401,1,219.25,1.2773870241916032,5,5401,2,203.0,1.0915675205208268]
> [5,5635,1,370.0,1.0227054644459215,5,5635,2,351.6666666666667,1.3777664464428738]
> [5,5797,1,403.0,1.0234882286709048,5,5797,2,457.5,1.003704010389515]
> [5,5901,1,360.25,1.125963126923387,5,5901,2,376.0,1.0095038425625151]
> [5,6129,1,419.25,1.0169180165631466,5,6129,2,359.5,1.0478889386811094]
> [5,6213,1,351.6666666666667,1.2056212536733542,5,6213,2,361.5,1.116840805855076]
> [5,6479,1,301.3333333333333,1.2780010449304997,5,6479,2,395.75,1.1779743547973778]
> [5,7333,1,227.0,1.4611346002650127,5,7333,2,243.75,1.1789162497808614]
> [5,7923,1,358.0,1.1046770912449826,5,7923,2,342.3333333333333,1.1607781125264065]
> [5,8737,1,217.25,1.074213640090777,5,8737,2,403.5,1.044208050277477]
> [5,8945,1,344.25,1.1414837656266814,5,8945,2,298.0,1.0008366993492595]
> [5,8993,1,399.0,1.1873722892104934,5,8993,2,371.75,1.131635380135078]
> [5,10667,1,288.0,1.3453640177579367,5,10667,2,289.5,1.0952238011728228]
> [5,10771,1,394.75,1.048068013117441,5,10771,2,323.25,1.2377348818060852]
> [5,10949,1,383.0,1.1125677373995029,5,10949,2,378.25,1.125540609959554]
> [5,11107,1,446.5,1.2653489768601378,5,11107,2,258.5,1.553612564193816]
> [5,11795,1,395.5,1.0104473172545645,5,11795,2,430.75,1.131062588545398]
> [5,12017,1,347.75,1.1682379397902218,5,12017,2,308.0,1.1593227968413717]
> [5,12027,1,456.25,1.0262940073409625,5,12027,2,390.3333333333333,1.1142770095355214]
> [5,13583,1,430.3333333333333,1.0423839290527277,5,13583,2,256.25,1.541034827728967]
> [5,13651,1,272.3333333333333,1.169523124191674,5,13651,2,330.5,1.1901873530915061]
> [5,13783,1,419.5,1.0584699696320432,5,13783,2,339.5,1.0680909505443135]
> [5,13859,1,318.0,1.1422239044797105,5,13859,2,380.25,1.0564496237557859]
> [5,14537,1,206.0,1.2283439997338772,5,14537,2,357.75,1.0387982680964687]
> [5,15309,1,276.3333333333333,1.2987590579253725,5,15309,2,409.0,1.0102406245856923]
> [5,15883,1,385.3333333333333,1.0124777526338786,5,15883,2,173.25,1.3562238248195932]
> [5,15935,1,293.5,1.0187659410172984,5,15935,2,271.25,1.4000947515083553]
> [5,15949,1,241.5,1.148665986924513,5,15949,2,235.0,1.4072887931753781]
> [5,16037,1,327.25,1.1307617323781536,5,16037,2,412.6666666666667,1.1830200153757018]
> [5,16291,1,380.5,1.0549595028454235,5,16291,2,411.6666666666667,1.034921399084621]
> [5,16459,1,370.0,1.275649908122718,5,16459,2,265.75,1.2988191692443933]
> [5,16901,1,305.25,1.1043010533964068,5,16901,2,186.5,1.0231269284283626]
> [5,17199,1,376.5,1.1038969766440296,5,17199,2,374.0,1.0873031171988548]
> [5,17387,1,298.3333333333333,1.3848741714581234,5,17387,2,327.6666666666667,1.3670875783476784]
> [5,17717,1,283.75,1.1557156567771052,5,17717,2,235.25,1.1416239351288795]
> [5,17927,1,217.5,1.3549964301320125,5,17927,2,250.75,1.070921305926391]
> [5,17943,1,209.75,1.3717071339917375,5,17943,2,428.0,1.1090799349168265]
> {noformat}
> Expected 39a:
> {noformat}
> +----------------+-----------+-------+-----------+---------+----------------+-----------+-------+-----------+---------+
> | W_WAREHOUSE_SK | I_ITEM_SK | D_MOY | MEAN | COV | W_WAREHOUSE_SK | I_ITEM_SK | D_MOY | MEAN | COV |
> +----------------+-----------+-------+-----------+---------+----------------+-----------+-------+-----------+---------+
> | 1 | 265 | 1 | 324.75000 | 1.24384 | 1 | 265 | 2 | 329.00000 | 1.01516 |
> | 1 | 363 | 1 | 499.50000 | 1.03194 | 1 | 363 | 2 | 321.00000 | 1.14118 |
> | 1 | 679 | 1 | 373.75000 | 1.09555 | 1 | 679 | 2 | 417.50000 | 1.04297 |
> | 1 | 695 | 1 | 450.75000 | 1.08359 | 1 | 695 | 2 | 368.75000 | 1.13565 |
> | 1 | 789 | 1 | 357.25000 | 1.03451 | 1 | 789 | 2 | 410.00000 | 1.02842 |
> | 1 | 815 | 1 | 216.50000 | 1.17023 | 1 | 815 | 2 | 150.50000 | 1.30573 |
> | 1 | 827 | 1 | 271.75000 | 1.10469 | 1 | 827 | 2 | 424.75000 | 1.16532 |
> | 1 | 1041 | 1 | 382.50000 | 1.28481 | 1 | 1041 | 2 | 424.75000 | 1.00058 |
> | 1 | 1569 | 1 | 212.00000 | 1.63021 | 1 | 1569 | 2 | 239.25000 | 1.26415 |
> | 1 | 1623 | 1 | 338.25000 | 1.12855 | 1 | 1623 | 2 | 261.33333 | 1.27178 |
> | 1 | 2581 | 1 | 448.50000 | 1.06043 | 1 | 2581 | 2 | 476.25000 | 1.03630 |
> | 1 | 2705 | 1 | 246.25000 | 1.01203 | 1 | 2705 | 2 | 294.66667 | 1.07421 |
> | 1 | 3131 | 1 | 393.75000 | 1.00376 | 1 | 3131 | 2 | 480.50000 | 1.06691 |
> | 1 | 3291 | 1 | 374.50000 | 1.19519 | 1 | 3291 | 2 | 265.25000 | 1.57297 |
> | 1 | 3687 | 1 | 279.75000 | 1.42609 | 1 | 3687 | 2 | 157.25000 | 1.45343 |
> | 1 | 4955 | 1 | 495.25000 | 1.03183 | 1 | 4955 | 2 | 322.50000 | 1.16938 |
> | 1 | 5627 | 1 | 282.75000 | 1.56570 | 1 | 5627 | 2 | 297.50000 | 1.20843 |
> | 1 | 7017 | 1 | 175.50000 | 1.04275 | 1 | 7017 | 2 | 321.33333 | 1.01834 |
> | 1 | 7317 | 1 | 366.33333 | 1.02547 | 1 | 7317 | 2 | 378.00000 | 1.21725 |
> | 1 | 7569 | 1 | 430.50000 | 1.08744 | 1 | 7569 | 2 | 360.25000 | 1.04701 |
> | 1 | 7999 | 1 | 166.25000 | 1.79242 | 1 | 7999 | 2 | 375.33333 | 1.00809 |
> | 1 | 8319 | 1 | 306.75000 | 1.16154 | 1 | 8319 | 2 | 276.00000 | 1.14210 |
> | 1 | 8443 | 1 | 327.75000 | 1.25672 | 1 | 8443 | 2 | 332.50000 | 1.00442 |
> | 1 | 8583 | 1 | 319.50000 | 1.02411 | 1 | 8583 | 2 | 310.25000 | 1.23588 |
> | 1 | 8591 | 1 | 398.00000 | 1.14782 | 1 | 8591 | 2 | 355.75000 | 1.00245 |
> | 1 | 8611 | 1 | 300.50000 | 1.51915 | 1 | 8611 | 2 | 243.75000 | 1.23421 |
> | 1 | 9081 | 1 | 367.00000 | 1.08789 | 1 | 9081 | 2 | 435.00000 | 1.03305 |
> | 1 | 9357 | 1 | 351.66667 | 1.19029 | 1 | 9357 | 2 | 427.00000 | 1.04386 |
> | 1 | 9449 | 1 | 406.25000 | 1.01832 | 1 | 9449 | 2 | 175.00000 | 1.05448 |
> | 1 | 9713 | 1 | 242.50000 | 1.10350 | 1 | 9713 | 2 | 393.00000 | 1.20847 |
> | 1 | 9809 | 1 | 479.00000 | 1.01896 | 1 | 9809 | 2 | 317.50000 | 1.06141 |
> | 1 | 9993 | 1 | 417.75000 | 1.00998 | 1 | 9993 | 2 | 204.50000 | 1.55287 |
> | 1 | 10127 | 1 | 239.75000 | 1.05618 | 1 | 10127 | 2 | 359.25000 | 1.18580 |
> | 1 | 11159 | 1 | 407.25000 | 1.07855 | 1 | 11159 | 2 | 250.00000 | 1.33476 |
> | 1 | 11277 | 1 | 211.25000 | 1.26159 | 1 | 11277 | 2 | 330.75000 | 1.08088 |
> | 1 | 11937 | 1 | 344.50000 | 1.08580 | 1 | 11937 | 2 | 200.33333 | 1.06385 |
> | 1 | 12373 | 1 | 387.75000 | 1.10149 | 1 | 12373 | 2 | 306.00000 | 1.07617 |
> | 1 | 12471 | 1 | 365.25000 | 1.06076 | 1 | 12471 | 2 | 327.25000 | 1.05476 |
> | 1 | 12625 | 1 | 279.00000 | 1.30166 | 1 | 12625 | 2 | 443.25000 | 1.06050 |
> | 1 | 12751 | 1 | 280.75000 | 1.10833 | 1 | 12751 | 2 | 369.33333 | 1.34165 |
> | 1 | 12779 | 1 | 331.00000 | 1.04169 | 1 | 12779 | 2 | 359.00000 | 1.02898 |
> | 1 | 13077 | 1 | 367.66667 | 1.34552 | 1 | 13077 | 2 | 358.66667 | 1.51324 |
> | 1 | 13191 | 1 | 260.25000 | 1.06357 | 1 | 13191 | 2 | 405.00000 | 1.01980 |
> | 1 | 13561 | 1 | 335.25000 | 1.26096 | 1 | 13561 | 2 | 240.00000 | 1.05136 |
> | 1 | 13935 | 1 | 311.75000 | 1.03993 | 1 | 13935 | 2 | 275.00000 | 1.03675 |
> | 1 | 14687 | 1 | 358.00000 | 1.43694 | 1 | 14687 | 2 | 187.00000 | 1.54936 |
> | 1 | 14719 | 1 | 209.00000 | 1.04115 | 1 | 14719 | 2 | 489.00000 | 1.37662 |
> | 1 | 15345 | 1 | 148.50000 | 1.52958 | 1 | 15345 | 2 | 246.50000 | 1.50880 |
> | 1 | 15427 | 1 | 482.75000 | 1.01242 | 1 | 15427 | 2 | 333.25000 | 1.27248 |
> | 1 | 15647 | 1 | 201.66667 | 1.28579 | 1 | 15647 | 2 | 249.25000 | 1.36482 |
> | 1 | 16079 | 1 | 280.50000 | 1.24448 | 1 | 16079 | 2 | 361.25000 | 1.07378 |
> | 1 | 16223 | 1 | 245.66667 | 1.06011 | 1 | 16223 | 2 | 412.66667 | 1.06712 |
> | 1 | 16289 | 1 | 171.00000 | 1.08726 | 1 | 16289 | 2 | 316.50000 | 1.36953 |
> | 1 | 16451 | 1 | 300.00000 | 1.25165 | 1 | 16451 | 2 | 467.50000 | 1.29624 |
> | 1 | 17051 | 1 | 349.75000 | 1.13464 | 1 | 17051 | 2 | 319.75000 | 1.03794 |
> | 2 | 71 | 1 | 221.50000 | 1.56397 | 2 | 71 | 2 | 309.00000 | 1.49171 |
> | 2 | 833 | 1 | 363.33333 | 1.04228 | 2 | 833 | 2 | 158.75000 | 1.21309 |
> | 2 | 969 | 1 | 282.00000 | 1.13743 | 2 | 969 | 2 | 386.00000 | 1.13710 |
> | 2 | 1401 | 1 | 249.00000 | 1.32062 | 2 | 1401 | 2 | 296.66667 | 1.28681 |
> | 2 | 1681 | 1 | 337.75000 | 1.05216 | 2 | 1681 | 2 | 252.75000 | 1.03179 |
> | 2 | 1991 | 1 | 356.00000 | 1.13368 | 2 | 1991 | 2 | 273.25000 | 1.33242 |
> | 2 | 2031 | 1 | 407.50000 | 1.02099 | 2 | 2031 | 2 | 418.75000 | 1.00534 |
> | 2 | 2481 | 1 | 319.75000 | 1.11603 | 2 | 2481 | 2 | 378.33333 | 1.05972 |
> | 2 | 2725 | 1 | 349.75000 | 1.11487 | 2 | 2725 | 2 | 265.66667 | 1.54630 |
> | 2 | 3073 | 1 | 385.00000 | 1.10208 | 2 | 3073 | 2 | 231.75000 | 1.08850 |
> | 2 | 3769 | 1 | 334.00000 | 1.19543 | 2 | 3769 | 2 | 335.00000 | 1.04946 |
> | 2 | 4085 | 1 | 327.75000 | 1.10054 | 2 | 4085 | 2 | 281.75000 | 1.01876 |
> | 2 | 4995 | 1 | 282.25000 | 1.26042 | 2 | 4995 | 2 | 248.00000 | 1.25482 |
> | 2 | 5099 | 1 | 418.66667 | 1.06809 | 2 | 5099 | 2 | 428.66667 | 1.03524 |
> | 2 | 5211 | 1 | 157.00000 | 1.06955 | 2 | 5211 | 2 | 270.25000 | 1.19402 |
> | 2 | 5769 | 1 | 341.25000 | 1.27231 | 2 | 5769 | 2 | 267.00000 | 1.18158 |
> | 2 | 6103 | 1 | 194.33333 | 1.51607 | 2 | 6103 | 2 | 158.50000 | 1.27437 |
> | 2 | 6243 | 1 | 168.50000 | 1.07321 | 2 | 6243 | 2 | 386.75000 | 1.08329 |
> | 2 | 6489 | 1 | 268.00000 | 1.69564 | 2 | 6489 | 2 | 389.00000 | 1.41058 |
> | 2 | 6585 | 1 | 183.75000 | 1.11519 | 2 | 6585 | 2 | 353.75000 | 1.09397 |
> | 2 | 6767 | 1 | 341.00000 | 1.09316 | 2 | 6767 | 2 | 235.00000 | 1.13995 |
> | 2 | 7411 | 1 | 460.00000 | 1.06283 | 2 | 7411 | 2 | 297.50000 | 1.00058 |
> | 2 | 8489 | 1 | 126.75000 | 1.34165 | 2 | 8489 | 2 | 398.25000 | 1.00411 |
> | 2 | 8633 | 1 | 218.50000 | 1.46452 | 2 | 8633 | 2 | 230.25000 | 1.31170 |
> | 2 | 8807 | 1 | 417.25000 | 1.02581 | 2 | 8807 | 2 | 356.25000 | 1.10797 |
> | 2 | 8883 | 1 | 249.25000 | 1.11123 | 2 | 8883 | 2 | 189.25000 | 1.01008 |
> | 2 | 9253 | 1 | 413.33333 | 1.16067 | 2 | 9253 | 2 | 465.00000 | 1.02424 |
> | 2 | 9467 | 1 | 108.25000 | 1.09112 | 2 | 9467 | 2 | 107.00000 | 1.03092 |
> | 2 | 9561 | 1 | 190.50000 | 1.03030 | 2 | 9561 | 2 | 271.00000 | 1.20583 |
> | 2 | 9575 | 1 | 452.50000 | 1.04945 | 2 | 9575 | 2 | 155.75000 | 1.15341 |
> | 2 | 9903 | 1 | 322.75000 | 1.07611 | 2 | 9903 | 2 | 387.33333 | 1.26124 |
> | 2 | 10535 | 1 | 324.33333 | 1.05711 | 2 | 10535 | 2 | 310.25000 | 1.00406 |
> | 2 | 10955 | 1 | 356.00000 | 1.15828 | 2 | 10955 | 2 | 339.00000 | 1.07025 |
> | 2 | 12089 | 1 | 212.00000 | 1.08275 | 2 | 12089 | 2 | 173.33333 | 1.07398 |
> | 2 | 12633 | 1 | 402.75000 | 1.00714 | 2 | 12633 | 2 | 367.00000 | 1.12705 |
> | 2 | 12765 | 1 | 308.00000 | 1.11885 | 2 | 12765 | 2 | 347.00000 | 1.15717 |
> | 2 | 13077 | 1 | 277.00000 | 1.23234 | 2 | 13077 | 2 | 223.50000 | 1.13940 |
> | 2 | 13687 | 1 | 361.25000 | 1.01073 | 2 | 13687 | 2 | 468.25000 | 1.00984 |
> | 2 | 14025 | 1 | 371.75000 | 1.01501 | 2 | 14025 | 2 | 141.00000 | 1.25432 |
> | 2 | 14117 | 1 | 298.50000 | 1.02512 | 2 | 14117 | 2 | 220.25000 | 1.41527 |
> | 2 | 14347 | 1 | 366.00000 | 1.03279 | 2 | 14347 | 2 | 369.75000 | 1.01857 |
> | 2 | 14697 | 1 | 397.75000 | 1.00812 | 2 | 14697 | 2 | 328.75000 | 1.16085 |
> | 2 | 14987 | 1 | 146.75000 | 1.02900 | 2 | 14987 | 2 | 436.50000 | 1.04477 |
> | 2 | 15321 | 1 | 527.00000 | 1.21027 | 2 | 15321 | 2 | 298.75000 | 1.13091 |
> | 2 | 15347 | 1 | 243.00000 | 1.22262 | 2 | 15347 | 2 | 310.75000 | 1.20366 |
> | 2 | 15533 | 1 | 223.00000 | 1.09651 | 2 | 15533 | 2 | 330.00000 | 1.49675 |
> | 2 | 15839 | 1 | 353.00000 | 1.50637 | 2 | 15839 | 2 | 255.50000 | 1.23624 |
> | 2 | 16107 | 1 | 376.00000 | 1.01332 | 2 | 16107 | 2 | 364.75000 | 1.06887 |
> | 2 | 16749 | 1 | 200.00000 | 1.09447 | 2 | 16749 | 2 | 438.25000 | 1.03606 |
> | 2 | 17329 | 1 | 321.33333 | 1.30933 | 2 | 17329 | 2 | 490.25000 | 1.07566 |
> | 2 | 17417 | 1 | 321.75000 | 1.13068 | 2 | 17417 | 2 | 534.00000 | 1.00107 |
> | 3 | 1049 | 1 | 252.50000 | 1.10906 | 3 | 1049 | 2 | 457.25000 | 1.02398 |
> | 3 | 1415 | 1 | 247.50000 | 1.13216 | 3 | 1415 | 2 | 369.75000 | 1.09547 |
> | 3 | 2199 | 1 | 185.75000 | 1.20281 | 3 | 2199 | 2 | 300.75000 | 1.07678 |
> | 3 | 2403 | 1 | 270.75000 | 1.32587 | 3 | 2403 | 2 | 384.00000 | 1.09040 |
> | 3 | 2541 | 1 | 364.75000 | 1.07921 | 3 | 2541 | 2 | 550.50000 | 1.05456 |
> | 3 | 2727 | 1 | 303.75000 | 1.03016 | 3 | 2727 | 2 | 219.25000 | 1.38221 |
> | 3 | 3207 | 1 | 383.75000 | 1.08546 | 3 | 3207 | 2 | 258.25000 | 1.21134 |
> | 3 | 3373 | 1 | 404.50000 | 1.01434 | 3 | 3373 | 2 | 171.25000 | 1.28567 |
> | 3 | 3969 | 1 | 234.25000 | 1.04228 | 3 | 3969 | 2 | 217.25000 | 1.42155 |
> | 3 | 4407 | 1 | 438.50000 | 1.06567 | 3 | 4407 | 2 | 330.75000 | 1.02444 |
> | 3 | 6051 | 1 | 289.75000 | 1.26389 | 3 | 6051 | 2 | 439.00000 | 1.10458 |
> | 3 | 6521 | 1 | 381.00000 | 1.00157 | 3 | 6521 | 2 | 437.75000 | 1.03651 |
> | 3 | 6691 | 1 | 377.00000 | 1.10907 | 3 | 6691 | 2 | 380.50000 | 1.05813 |
> | 3 | 6757 | 1 | 282.50000 | 1.08950 | 3 | 6757 | 2 | 345.25000 | 1.22638 |
> | 3 | 6915 | 1 | 420.66667 | 1.04683 | 3 | 6915 | 2 | 292.50000 | 1.25062 |
> | 3 | 7207 | 1 | 329.66667 | 1.59545 | 3 | 7207 | 2 | 414.50000 | 1.01792 |
> | 3 | 7889 | 1 | 318.50000 | 1.28790 | 3 | 7889 | 2 | 291.33333 | 1.00429 |
> | 3 | 8559 | 1 | 356.25000 | 1.00652 | 3 | 8559 | 2 | 393.50000 | 1.01288 |
> | 3 | 8829 | 1 | 364.25000 | 1.07929 | 3 | 8829 | 2 | 350.25000 | 1.11339 |
> | 3 | 9555 | 1 | 377.00000 | 1.13085 | 3 | 9555 | 2 | 444.75000 | 1.01716 |
> | 3 | 9623 | 1 | 331.33333 | 1.15513 | 3 | 9623 | 2 | 284.66667 | 1.03037 |
> | 3 | 9813 | 1 | 343.75000 | 1.05170 | 3 | 9813 | 2 | 384.66667 | 1.08150 |
> | 3 | 9881 | 1 | 351.50000 | 1.17888 | 3 | 9881 | 2 | 287.75000 | 1.09094 |
> | 3 | 10035 | 1 | 378.25000 | 1.02164 | 3 | 10035 | 2 | 364.25000 | 1.15679 |
> | 3 | 10509 | 1 | 420.25000 | 1.05486 | 3 | 10509 | 2 | 368.25000 | 1.18206 |
> | 3 | 10547 | 1 | 182.33333 | 1.53256 | 3 | 10547 | 2 | 320.25000 | 1.30244 |
> | 3 | 10743 | 1 | 233.25000 | 1.27930 | 3 | 10743 | 2 | 110.25000 | 1.10720 |
> | 3 | 11477 | 1 | 264.25000 | 1.09535 | 3 | 11477 | 2 | 278.50000 | 1.03279 |
> | 3 | 11959 | 1 | 358.00000 | 1.06848 | 3 | 11959 | 2 | 268.50000 | 1.00899 |
> | 3 | 12043 | 1 | 169.25000 | 1.03309 | 3 | 12043 | 2 | 377.25000 | 1.01620 |
> | 3 | 12157 | 1 | 326.33333 | 1.00223 | 3 | 12157 | 2 | 396.33333 | 1.02878 |
> | 3 | 12433 | 1 | 199.75000 | 1.30726 | 3 | 12433 | 2 | 478.50000 | 1.01647 |
> | 3 | 12867 | 1 | 278.25000 | 1.64038 | 3 | 12867 | 2 | 350.75000 | 1.20069 |
> | 3 | 13499 | 1 | 281.00000 | 1.14320 | 3 | 13499 | 2 | 446.75000 | 1.03315 |
> | 3 | 14589 | 1 | 266.50000 | 1.11432 | 3 | 14589 | 2 | 334.33333 | 1.14531 |
> | 3 | 15207 | 1 | 300.25000 | 1.48446 | 3 | 15207 | 2 | 564.00000 | 1.00048 |
> | 3 | 15395 | 1 | 258.25000 | 1.05139 | 3 | 15395 | 2 | 307.50000 | 1.13823 |
> | 3 | 15973 | 1 | 477.50000 | 1.20393 | 3 | 15973 | 2 | 286.00000 | 1.28723 |
> | 3 | 16233 | 1 | 260.66667 | 1.12042 | 3 | 16233 | 2 | 210.50000 | 1.17881 |
> | 3 | 16267 | 1 | 456.00000 | 1.00423 | 3 | 16267 | 2 | 364.33333 | 1.48189 |
> | 3 | 16605 | 1 | 394.25000 | 1.11374 | 3 | 16605 | 2 | 296.25000 | 1.28859 |
> | 3 | 16949 | 1 | 155.75000 | 1.11862 | 3 | 16949 | 2 | 229.50000 | 1.02895 |
> | 3 | 17319 | 1 | 364.75000 | 1.27094 | 3 | 17319 | 2 | 359.25000 | 1.15788 |
> | 4 | 947 | 1 | 247.50000 | 1.69332 | 4 | 947 | 2 | 203.33333 | 1.20543 |
> | 4 | 1895 | 1 | 354.75000 | 1.23973 | 4 | 1895 | 2 | 383.75000 | 1.08931 |
> | 4 | 3429 | 1 | 358.50000 | 1.06656 | 4 | 3429 | 2 | 346.00000 | 1.25195 |
> | 4 | 4559 | 1 | 215.00000 | 1.24323 | 4 | 4559 | 2 | 360.75000 | 1.03335 |
> | 4 | 4773 | 1 | 328.25000 | 1.05098 | 4 | 4773 | 2 | 330.50000 | 1.00626 |
> | 4 | 4885 | 1 | 151.00000 | 1.32056 | 4 | 4885 | 2 | 377.25000 | 1.04890 |
> | 4 | 4915 | 1 | 289.25000 | 1.08639 | 4 | 4915 | 2 | 368.00000 | 1.06966 |
> | 4 | 5043 | 1 | 476.00000 | 1.01560 | 4 | 5043 | 2 | 244.25000 | 1.35629 |
> | 4 | 5095 | 1 | 334.00000 | 1.22589 | 4 | 5095 | 2 | 390.25000 | 1.06218 |
> | 4 | 5193 | 1 | 263.33333 | 1.25017 | 4 | 5193 | 2 | 323.00000 | 1.09796 |
> | 4 | 5975 | 1 | 434.00000 | 1.02336 | 4 | 5975 | 2 | 359.75000 | 1.19794 |
> | 4 | 6251 | 1 | 285.00000 | 1.12154 | 4 | 6251 | 2 | 335.50000 | 1.16022 |
> | 4 | 6389 | 1 | 280.75000 | 1.20492 | 4 | 6389 | 2 | 259.33333 | 1.48166 |
> | 4 | 6487 | 1 | 452.75000 | 1.07106 | 4 | 6487 | 2 | 350.50000 | 1.17165 |
> | 4 | 6619 | 1 | 430.00000 | 1.00073 | 4 | 6619 | 2 | 226.25000 | 1.54856 |
> | 4 | 7191 | 1 | 260.75000 | 1.00127 | 4 | 7191 | 2 | 195.25000 | 1.53727 |
> | 4 | 7427 | 1 | 239.50000 | 1.41836 | 4 | 7427 | 2 | 373.25000 | 1.04298 |
> | 4 | 8453 | 1 | 314.75000 | 1.02597 | 4 | 8453 | 2 | 376.75000 | 1.00990 |
> | 4 | 8781 | 1 | 518.50000 | 1.10055 | 4 | 8781 | 2 | 521.00000 | 1.12377 |
> | 4 | 9571 | 1 | 314.00000 | 1.21686 | 4 | 9571 | 2 | 309.00000 | 1.08922 |
> | 4 | 9587 | 1 | 248.00000 | 1.49819 | 4 | 9587 | 2 | 248.00000 | 1.00650 |
> | 4 | 10333 | 1 | 321.00000 | 1.14861 | 4 | 10333 | 2 | 317.00000 | 1.04692 |
> | 4 | 10969 | 1 | 186.66667 | 1.10442 | 4 | 10969 | 2 | 307.00000 | 1.10948 |
> | 4 | 10993 | 1 | 446.00000 | 1.00924 | 4 | 10993 | 2 | 206.66667 | 1.23553 |
> | 4 | 11571 | 1 | 342.50000 | 1.14263 | 4 | 11571 | 2 | 304.66667 | 1.03199 |
> | 4 | 11979 | 1 | 225.33333 | 1.46707 | 4 | 11979 | 2 | 438.25000 | 1.13899 |
> | 4 | 13409 | 1 | 312.33333 | 1.34275 | 4 | 13409 | 2 | 336.25000 | 1.10820 |
> | 4 | 13443 | 1 | 417.75000 | 1.02178 | 4 | 13443 | 2 | 334.00000 | 1.30764 |
> | 4 | 13567 | 1 | 271.50000 | 1.00876 | 4 | 13567 | 2 | 370.00000 | 1.45577 |
> | 4 | 13683 | 1 | 318.75000 | 1.01498 | 4 | 13683 | 2 | 363.50000 | 1.07812 |
> | 4 | 14143 | 1 | 367.00000 | 1.04418 | 4 | 14143 | 2 | 290.00000 | 1.19331 |
> | 4 | 14401 | 1 | 342.75000 | 1.18366 | 4 | 14401 | 2 | 344.25000 | 1.20671 |
> | 4 | 14693 | 1 | 447.25000 | 1.05167 | 4 | 14693 | 2 | 498.00000 | 1.35174 |
> | 4 | 14877 | 1 | 414.33333 | 1.17077 | 4 | 14877 | 2 | 282.50000 | 1.58306 |
> | 4 | 15063 | 1 | 378.25000 | 1.11282 | 4 | 15063 | 2 | 444.00000 | 1.06328 |
> | 4 | 15275 | 1 | 335.50000 | 1.15364 | 4 | 15275 | 2 | 292.66667 | 1.29783 |
> | 4 | 15509 | 1 | 296.33333 | 1.02467 | 4 | 15509 | 2 | 317.66667 | 1.44704 |
> | 4 | 15969 | 1 | 423.00000 | 1.04729 | 4 | 15969 | 2 | 342.50000 | 1.25118 |
> | 4 | 16627 | 1 | 485.50000 | 1.01515 | 4 | 16627 | 2 | 161.25000 | 1.35333 |
> | 4 | 16641 | 1 | 521.50000 | 1.10507 | 4 | 16641 | 2 | 221.50000 | 1.03086 |
> | 4 | 16751 | 1 | 549.50000 | 1.08221 | 4 | 16751 | 2 | 223.33333 | 1.33779 |
> | 5 | 75 | 1 | 333.00000 | 1.26563 | 5 | 75 | 2 | 226.00000 | 1.03581 |
> | 5 | 125 | 1 | 441.66667 | 1.09597 | 5 | 125 | 2 | 331.50000 | 1.00811 |
> | 5 | 431 | 1 | 159.00000 | 1.10618 | 5 | 431 | 2 | 304.00000 | 1.12242 |
> | 5 | 671 | 1 | 403.33333 | 1.00560 | 5 | 671 | 2 | 281.33333 | 1.33668 |
> | 5 | 745 | 1 | 466.75000 | 1.01091 | 5 | 745 | 2 | 351.00000 | 1.11472 |
> | 5 | 1701 | 1 | 374.00000 | 1.08645 | 5 | 1701 | 2 | 385.00000 | 1.33063 |
> | 5 | 2521 | 1 | 360.75000 | 1.09925 | 5 | 2521 | 2 | 265.50000 | 1.17241 |
> | 5 | 2855 | 1 | 406.00000 | 1.40376 | 5 | 2855 | 2 | 183.25000 | 1.06622 |
> | 5 | 3137 | 1 | 271.25000 | 1.57545 | 5 | 3137 | 2 | 380.00000 | 1.08342 |
> | 5 | 3279 | 1 | 299.50000 | 1.05367 | 5 | 3279 | 2 | 276.75000 | 1.44589 |
> | 5 | 3467 | 1 | 294.00000 | 1.14773 | 5 | 3467 | 2 | 349.66667 | 1.16742 |
> | 5 | 4463 | 1 | 338.00000 | 1.06993 | 5 | 4463 | 2 | 273.50000 | 1.23698 |
> | 5 | 4719 | 1 | 340.50000 | 1.05719 | 5 | 4719 | 2 | 423.66667 | 1.02550 |
> | 5 | 4739 | 1 | 281.33333 | 1.02430 | 5 | 4739 | 2 | 383.50000 | 1.03343 |
> | 5 | 4839 | 1 | 310.25000 | 1.03590 | 5 | 4839 | 2 | 232.00000 | 1.29542 |
> | 5 | 4979 | 1 | 359.50000 | 1.10464 | 5 | 4979 | 2 | 323.75000 | 1.17043 |
> | 5 | 5401 | 1 | 219.25000 | 1.27739 | 5 | 5401 | 2 | 203.00000 | 1.09157 |
> | 5 | 5635 | 1 | 370.00000 | 1.02271 | 5 | 5635 | 2 | 351.66667 | 1.37777 |
> | 5 | 5797 | 1 | 403.00000 | 1.02349 | 5 | 5797 | 2 | 457.50000 | 1.00370 |
> | 5 | 5901 | 1 | 360.25000 | 1.12596 | 5 | 5901 | 2 | 376.00000 | 1.00950 |
> | 5 | 6129 | 1 | 419.25000 | 1.01692 | 5 | 6129 | 2 | 359.50000 | 1.04789 |
> | 5 | 6213 | 1 | 351.66667 | 1.20562 | 5 | 6213 | 2 | 361.50000 | 1.11684 |
> | 5 | 6479 | 1 | 301.33333 | 1.27800 | 5 | 6479 | 2 | 395.75000 | 1.17797 |
> | 5 | 7333 | 1 | 227.00000 | 1.46113 | 5 | 7333 | 2 | 243.75000 | 1.17892 |
> | 5 | 7923 | 1 | 358.00000 | 1.10468 | 5 | 7923 | 2 | 342.33333 | 1.16078 |
> | 5 | 8737 | 1 | 217.25000 | 1.07421 | 5 | 8737 | 2 | 403.50000 | 1.04421 |
> | 5 | 8945 | 1 | 344.25000 | 1.14148 | 5 | 8945 | 2 | 298.00000 | 1.00084 |
> | 5 | 8993 | 1 | 399.00000 | 1.18737 | 5 | 8993 | 2 | 371.75000 | 1.13164 |
> | 5 | 10667 | 1 | 288.00000 | 1.34536 | 5 | 10667 | 2 | 289.50000 | 1.09522 |
> | 5 | 10771 | 1 | 394.75000 | 1.04807 | 5 | 10771 | 2 | 323.25000 | 1.23773 |
> | 5 | 10949 | 1 | 383.00000 | 1.11257 | 5 | 10949 | 2 | 378.25000 | 1.12554 |
> | 5 | 11107 | 1 | 446.50000 | 1.26535 | 5 | 11107 | 2 | 258.50000 | 1.55361 |
> | 5 | 11795 | 1 | 395.50000 | 1.01045 | 5 | 11795 | 2 | 430.75000 | 1.13106 |
> | 5 | 12017 | 1 | 347.75000 | 1.16824 | 5 | 12017 | 2 | 308.00000 | 1.15932 |
> | 5 | 12027 | 1 | 456.25000 | 1.02629 | 5 | 12027 | 2 | 390.33333 | 1.11428 |
> | 5 | 13583 | 1 | 430.33333 | 1.04238 | 5 | 13583 | 2 | 256.25000 | 1.54103 |
> | 5 | 13651 | 1 | 272.33333 | 1.16952 | 5 | 13651 | 2 | 330.50000 | 1.19019 |
> | 5 | 13783 | 1 | 419.50000 | 1.05847 | 5 | 13783 | 2 | 339.50000 | 1.06809 |
> | 5 | 13859 | 1 | 318.00000 | 1.14222 | 5 | 13859 | 2 | 380.25000 | 1.05645 |
> | 5 | 14537 | 1 | 206.00000 | 1.22834 | 5 | 14537 | 2 | 357.75000 | 1.03880 |
> | 5 | 15309 | 1 | 276.33333 | 1.29876 | 5 | 15309 | 2 | 409.00000 | 1.01024 |
> | 5 | 15883 | 1 | 385.33333 | 1.01248 | 5 | 15883 | 2 | 173.25000 | 1.35622 |
> | 5 | 15935 | 1 | 293.50000 | 1.01877 | 5 | 15935 | 2 | 271.25000 | 1.40009 |
> | 5 | 15949 | 1 | 241.50000 | 1.14867 | 5 | 15949 | 2 | 235.00000 | 1.40729 |
> | 5 | 16037 | 1 | 327.25000 | 1.13076 | 5 | 16037 | 2 | 412.66667 | 1.18302 |
> | 5 | 16291 | 1 | 380.50000 | 1.05496 | 5 | 16291 | 2 | 411.66667 | 1.03492 |
> | 5 | 16459 | 1 | 370.00000 | 1.27565 | 5 | 16459 | 2 | 265.75000 | 1.29882 |
> | 5 | 16901 | 1 | 305.25000 | 1.10430 | 5 | 16901 | 2 | 186.50000 | 1.02313 |
> | 5 | 17199 | 1 | 376.50000 | 1.10390 | 5 | 17199 | 2 | 374.00000 | 1.08730 |
> | 5 | 17387 | 1 | 298.33333 | 1.38487 | 5 | 17387 | 2 | 327.66667 | 1.36709 |
> | 5 | 17717 | 1 | 283.75000 | 1.15572 | 5 | 17717 | 2 | 235.25000 | 1.14162 |
> | 5 | 17927 | 1 | 217.50000 | 1.35500 | 5 | 17927 | 2 | 250.75000 | 1.07092 |
> | 5 | 17943 | 1 | 209.75000 | 1.37171 | 5 | 17943 | 2 | 428.00000 | 1.10908 |
> +----------------+-----------+-------+-----------+---------+----------------+-----------+-------+-----------+---------+
> {noformat}
> Actual results 39b:
> {noformat}
> [1,1155,1,184.0,NaN,1,1155,2,343.3333333333333,1.1700233592269733]
> [1,1569,1,212.0,1.630213519639535,1,1569,2,239.25,1.2641513267800557]
> [1,5627,1,282.75,1.5657032366359889,1,5627,2,297.5,1.2084286841430678]
> [1,7999,1,166.25,1.7924231710846223,1,7999,2,375.3333333333333,1.008092263550718]
> [1,8611,1,300.5,1.5191545184147954,1,8611,2,243.75,1.2342122780960432]
> [1,15345,1,148.5,1.5295784035794024,1,15345,2,246.5,1.5087987747231526]
> [2,71,1,221.5,1.563974108334745,2,71,2,309.0,1.4917057895885681]
> [2,5429,1,152.0,NaN,2,5429,2,355.25,1.1230959744909077]
> [2,6103,1,194.33333333333334,1.5160670179307387,2,6103,2,158.5,1.2743698636165062]
> [2,6489,1,268.0,1.6956372368432269,2,6489,2,389.0,1.4105780519299767]
> [2,15839,1,353.0,1.5063684437542906,2,15839,2,255.5,1.2362393182894105]
> [3,7207,1,329.6666666666667,1.5954482160720393,3,7207,2,414.5,1.017919707908937]
> [3,10547,1,182.33333333333334,1.5325641514869042,3,10547,2,320.25,1.302441844373152]
> [3,12867,1,278.25,1.6403800123947352,3,12867,2,350.75,1.2006933321742796]
> [4,947,1,247.5,1.6933181813486973,4,947,2,203.33333333333334,1.205433145161931]
> [4,10249,1,240.75,1.6058403557773568,4,10249,2,689.0,NaN]
> [5,3137,1,271.25,1.575453220592864,5,3137,2,380.0,1.0834203388600319]
> {noformat}
> Expected results 39b:
> {noformat}
> +----------------+-----------+-------+-----------+---------+----------------+-----------+-------+-----------+---------+
> | W_WAREHOUSE_SK | I_ITEM_SK | D_MOY | MEAN | COV | W_WAREHOUSE_SK | I_ITEM_SK | D_MOY | MEAN | COV |
> +----------------+-----------+-------+-----------+---------+----------------+-----------+-------+-----------+---------+
> | 1 | 1569 | 1 | 212.00000 | 1.63021 | 1 | 1569 | 2 | 239.25000 | 1.26415 |
> | 1 | 5627 | 1 | 282.75000 | 1.56570 | 1 | 5627 | 2 | 297.50000 | 1.20843 |
> | 1 | 7999 | 1 | 166.25000 | 1.79242 | 1 | 7999 | 2 | 375.33333 | 1.00809 |
> | 1 | 8611 | 1 | 300.50000 | 1.51915 | 1 | 8611 | 2 | 243.75000 | 1.23421 |
> | 1 | 15345 | 1 | 148.50000 | 1.52958 | 1 | 15345 | 2 | 246.50000 | 1.50880 |
> | 2 | 71 | 1 | 221.50000 | 1.56397 | 2 | 71 | 2 | 309.00000 | 1.49171 |
> | 2 | 6103 | 1 | 194.33333 | 1.51607 | 2 | 6103 | 2 | 158.50000 | 1.27437 |
> | 2 | 6489 | 1 | 268.00000 | 1.69564 | 2 | 6489 | 2 | 389.00000 | 1.41058 |
> | 2 | 15839 | 1 | 353.00000 | 1.50637 | 2 | 15839 | 2 | 255.50000 | 1.23624 |
> | 3 | 7207 | 1 | 329.66667 | 1.59545 | 3 | 7207 | 2 | 414.50000 | 1.01792 |
> | 3 | 10547 | 1 | 182.33333 | 1.53256 | 3 | 10547 | 2 | 320.25000 | 1.30244 |
> | 3 | 12867 | 1 | 278.25000 | 1.64038 | 3 | 12867 | 2 | 350.75000 | 1.20069 |
> | 4 | 947 | 1 | 247.50000 | 1.69332 | 4 | 947 | 2 | 203.33333 | 1.20543 |
> | 5 | 3137 | 1 | 271.25000 | 1.57545 | 5 | 3137 | 2 | 380.00000 | 1.08342 |
> +----------------+-----------+-------+-----------+---------+----------------+-----------+-------+-----------+---------+
> {noformat}
> Queries used:
> {noformat}
> -- start query 39 in stream 0 using template query39.tpl and seed QUALIFICATION
> with inv as
> (select w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy
> ,stdev,mean, case mean when 0 then null else stdev/mean end cov
> from(select w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy
> ,stddev_samp(inv_quantity_on_hand) stdev,avg(inv_quantity_on_hand) mean
> from inventory
> ,item
> ,warehouse
> ,date_dim
> where inv_item_sk = i_item_sk
> and inv_warehouse_sk = w_warehouse_sk
> and inv_date_sk = d_date_sk
> and d_year =2001
> group by w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy) foo
> where case mean when 0 then 0 else stdev/mean end > 1)
> select inv1.w_warehouse_sk,inv1.i_item_sk,inv1.d_moy,inv1.mean, inv1.cov
> ,inv2.w_warehouse_sk,inv2.i_item_sk,inv2.d_moy,inv2.mean, inv2.cov
> from inv inv1,inv inv2
> where inv1.i_item_sk = inv2.i_item_sk
> and inv1.w_warehouse_sk = inv2.w_warehouse_sk
> and inv1.d_moy=1
> and inv2.d_moy=1+1
> order by inv1.w_warehouse_sk,inv1.i_item_sk,inv1.d_moy,inv1.mean,inv1.cov
> ,inv2.d_moy,inv2.mean, inv2.cov
> ;
> -- end query 39 in stream 0 using template query39.tpl
> {noformat}
> 39b
> {noformat}
> with inv as
> (select w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy
> ,stdev,mean, case mean when 0 then null else stdev/mean end cov
> from(select w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy
> ,stddev_samp(inv_quantity_on_hand) stdev,avg(inv_quantity_on_hand) mean
> from inventory
> ,item
> ,warehouse
> ,date_dim
> where inv_item_sk = i_item_sk
> and inv_warehouse_sk = w_warehouse_sk
> and inv_date_sk = d_date_sk
> and d_year =2001
> group by w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy) foo
> where case mean when 0 then 0 else stdev/mean end > 1)
> select inv1.w_warehouse_sk,inv1.i_item_sk,inv1.d_moy,inv1.mean, inv1.cov
> ,inv2.w_warehouse_sk,inv2.i_item_sk,inv2.d_moy,inv2.mean, inv2.cov
> from inv inv1,inv inv2
> where inv1.i_item_sk = inv2.i_item_sk
> and inv1.w_warehouse_sk = inv2.w_warehouse_sk
> and inv1.d_moy=1
> and inv2.d_moy=1+1
> and inv1.cov > 1.5
> order by inv1.w_warehouse_sk,inv1.i_item_sk,inv1.d_moy,inv1.mean,inv1.cov
> ,inv2.d_moy,inv2.mean, inv2.cov
> ;
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org