Skip to content

Instantly share code, notes, and snippets.

@alexey-milovidov
Created May 6, 2018 09:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexey-milovidov/000d340779f9ce0653df97a85887a3a0 to your computer and use it in GitHub Desktop.
Save alexey-milovidov/000d340779f9ce0653df97a85887a3a0 to your computer and use it in GitHub Desktop.
SELECT user_id, arrayReduce('sum',[if(f21<0.287376, if(f2<-1.34168, if(f21<-0.0465033, -0.0411413, -0.0168165), if(f18<0.0541038, -0.0486026, -0.0432873)), if(f2<-1.12007, if(f19<0.514323, -0.00154215, 0.0279125), if(f23<-0.0269176, -0.0391427, -0.0148464))),if(f21<0.287376, if(f2<-1.30474, if(f21<-0.0465033, -0.0407256, -0.0184058), if(f23<-0.0274336, -0.0469912, -0.0290771)), if(f2<-1.157, if(f23<-0.027484, -0.00114219, 0.029407), if(f2<-0.344426, -0.0242555, -0.0423453))),if(f18<0.883746, if(f2<-1.34168, if(f21<-0.00940569, -0.0386349, -0.00968768), if(f23<-0.0274894, -0.0458335, -0.0281316)), if(f2<-1.30474, if(f23<-0.0273632, -0.00346079, 0.0302068), if(f19<0.514323, -0.0340366, -0.00648281))),if(f21<0.250278, if(f2<-1.34168, if(f21<-0.0465033, -0.0383863, -0.0166084), if(f18<0.0541038, -0.0453193, -0.0402171)), if(f2<-1.30474, if(f22<0.233904, 0.00176162, 0.0268355), if(f2<-0.639908, -0.0178382, -0.0385038))),if(f18<0.607199, if(f2<-1.34168, if(f21<-0.00940569, -0.0373913, -0.0101554), if(f23<-0.0274336, -0.0439256, -0.0289171)), if(f2<-1.19394, if(f19<0.514323, -0.00625752, 0.0268741), if(f19<0.514323, -0.0357198, -0.0104513))),if(f21<0.435766, if(f2<-1.34168, if(f21<-0.00940569, -0.035767, -0.0104316), if(f23<-0.0274894, -0.0428682, -0.0229862)), if(f2<-1.0462, if(f23<-0.0273248, 0.00187816, 0.02685), if(f19<1.63821, -0.032482, 0.00204186))),if(f18<0.607199, if(f2<-1.30474, if(f21<-0.0465033, -0.037346, -0.0156485), if(f21<-0.0465033, -0.042783, -0.0388954)), if(f2<-1.30474, if(f23<-0.0274931, -0.00521804, 0.0276861), if(f23<-0.0275324, -0.0332554, -0.00768356))),if(f21<0.250278, if(f2<-1.30474, if(f21<-0.0465033, -0.0354773, -0.015733), if(f18<0.0541038, -0.0418548, -0.0373441)), if(f2<-1.30474, if(f19<0.514323, 0.00189302, 0.0275378), if(f2<-0.824584, -0.0146903, -0.0342196))),if(f21<0.21318, if(f2<-1.30474, if(f21<-0.0465033, -0.0347172, -0.0169444), if(f19<0.514323, -0.04073, -0.0248928)), if(f2<-1.30474, if(f22<0.233904, 8.23854E-4, 0.0253576), if(f23<-0.027183, -0.0319395, -0.00700244))),if(f21<0.287376, if(f2<-1.30474, if(f21<-0.0465033, -0.0343388, -0.014464), if(f23<-0.0268591, -0.0399331, -0.0230654)), if(f2<-1.19394, if(f22<0.233904, -0.00125408, 0.0236391), if(f23<-0.0271985, -0.031504, -0.0054035))),if(f21<0.21318, if(f2<-1.30474, if(f21<-0.00940569, -0.0328916, -0.0128814), if(f23<-0.0274492, -0.0392849, -0.0231176)), if(f2<-1.08313, if(f19<0.514323, -0.00200433, 0.02365), if(f2<-0.307491, -0.0222099, -0.0358909))),if(f18<0.607199, if(f2<-1.34168, if(f21<0.027692, -0.0317689, -0.00479046), if(f23<-0.0274336, -0.0386082, -0.0233539)), if(f2<-1.30474, if(f23<-0.0274876, -0.00522193, 0.0275162), if(f19<0.514323, -0.0297226, -0.00283392))),if(f18<0.607199, if(f2<-1.37861, if(f21<-0.00940569, -0.0310768, -0.00633344), if(f18<0.0541038, -0.0384042, -0.033431)), if(f2<-1.12007, if(f22<0.233904, -0.00648516, 0.0217163), if(f19<0.514323, -0.0309866, -0.00797589))),if(f18<0.607199, if(f2<-1.30474, if(f21<-0.00940569, -0.0317836, -0.00930418), if(f21<-0.0465033, -0.0380014, -0.0341582)), if(f2<-1.157, if(f22<0.233904, -0.00607711, 0.0222084), if(f19<0.514323, -0.0298831, -0.00679007))),if(f18<0.607199, if(f2<-1.30474, if(f21<-0.00940569, -0.0312764, -0.00765295), if(f21<-0.0465033, -0.0374954, -0.0336616)), if(f2<-1.30474, if(f19<0.514323, -0.00339929, 0.025132), if(f23<-0.0275324, -0.0277916, -0.00536361))),if(f18<0.607199, if(f2<-1.37861, if(f21<-0.0465033, -0.0306154, -0.00996313), if(f23<-0.0274894, -0.0363659, -0.0205428)), if(f2<-1.12007, if(f19<0.514323, -0.00647451, 0.0239892), if(f19<1.63821, -0.028755, 0.00906169))),if(f21<0.138985, if(f2<-1.157, if(f18<0.0541038, -0.0311921, -0.0167023), if(f18<0.0541038, -0.0365831, -0.0329484)), if(f2<-1.37861, if(f23<-0.0275224, 0.00278828, 0.0268101), if(f2<-0.639908, -0.0124602, -0.0313422))),if(f21<0.138985, if(f2<-1.37861, if(f21<-0.0465033, -0.0286743, -0.0120908), if(f23<-0.0274794, -0.0354306, -0.0190915)), if(f2<-1.0462, if(f22<0.233904, -0.00441485, 0.0187175), if(f23<-0.026721, -0.0302931, -0.00990793))),if(f21<0.138985, if(f2<-1.12007, if(f23<-0.0275315, -0.0287219, 0.0120843), if(f18<0.0541038, -0.0356779, -0.0321881)), if(f2<-1.26781, if(f23<-0.0273504, -6.72319E-4, 0.0238452), if(f2<-0.602973, -0.0144265, -0.0304927))),if(f21<0.101887, if(f2<-1.30474, if(f18<0.0541038, -0.0294119, -0.0142636), if(f2<-0.676843, -0.0320512, -0.035213)), if(f2<-1.08313, if(f22<0.233904, -0.0050053, 0.0185778), if(f2<-0.0489445, -0.0208435, -0.0326259))),if(f21<0.101887, if(f2<-1.12007, if(f21<-0.0465033, -0.0296804, -0.0166378), if(f23<-0.0274474, -0.0345859, -0.0216888)), if(f2<-1.26781, if(f22<0.233904, -0.00305679, 0.0205645), if(f2<-0.270556, -0.0169205, -0.0314051))),if(f21<0.21318, if(f2<-1.157, if(f21<-0.0465033, -0.0290345, -0.0139274), if(f18<0.0541038, -0.0343114, -0.0300956)), if(f2<-1.0462, if(f23<-0.0274025, -0.00231972, 0.0219966), if(f23<-0.026871, -0.0280293, -0.00744155))),if(f18<0.330651, if(f2<-1.37861, if(f21<-0.00940569, -0.0267404, -0.00563836), if(f2<-0.824584, -0.0304892, -0.0340051)), if(f2<-1.12007, if(f22<0.233904, -0.00695099, 0.0184827), if(f23<-0.0275041, -0.0273197, -0.00706744))),if(f18<0.330651, if(f2<-1.30474, if(f21<-0.0465033, -0.0283736, -0.0114656), if(f21<-0.0465033, -0.0335919, -0.0301803)), if(f2<-1.19394, if(f23<-0.0275324, -0.0056847, 0.0212156), if(f23<-0.0271985, -0.0267871, -0.00349806))),if(f18<0.607199, if(f2<-1.37861, if(f21<-0.0465033, -0.0267457, -0.0066822), if(f21<-0.0465033, -0.0331048, -0.028648)), if(f2<-1.12007, if(f23<-0.0270814, -0.00400424, 0.020147), if(f23<-0.0274565, -0.0254219, -0.0043865))),if(f21<0.0647896, if(f2<-1.30474, if(f16<-0.252381, -0.0281698, -0.0169334), if(f18<0.0541038, -0.0329024, -0.0290634)), if(f2<-1.08313, if(f23<-0.0274867, -0.00479253, 0.0186878), if(f2<-0.270556, -0.017792, -0.029774))),if(f18<0.330651, if(f2<-1.34168, if(f21<-0.0465033, -0.0269778, -0.00866721), if(f2<-0.824584, -0.029273, -0.0326748)), if(f2<-1.12007, if(f23<-0.027484, -0.00552632, 0.018317), if(f23<-0.0274904, -0.0259033, -0.00592927))),if(f18<0.330651, if(f2<-1.30474, if(f21<-0.0465033, -0.0268872, -0.0101706), if(f23<-0.0274364, -0.0319173, -0.0183374)), if(f2<-1.12007, if(f19<0.514323, -0.0064463, 0.0195015), if(f19<0.514323, -0.0256998, -0.00468003))),if(f21<0.176083, if(f2<-1.30474, if(f18<0.0541038, -0.0256026, -0.0108268), if(f18<0.0541038, -0.0318308, -0.0270271)), if(f2<-1.37861, if(f22<0.233904, 0.00221522, 0.0221127), if(f2<-0.307491, -0.010695, -0.027506))),if(f21<0.0647896, if(f2<-1.37861, if(f19<0.514323, -0.021889, 0.0214266), if(f18<0.0541038, -0.0315352, -0.0268925)), if(f2<-1.08313, if(f22<0.233904, -0.00340782, 0.0172627), if(f2<-0.0489445, -0.0175592, -0.02915))),if(f21<0.101887, if(f2<-1.0462, if(f18<0.0541038, -0.0264361, -0.01378), if(f3<1.01952, -0.0315176, -0.0273609)), if(f2<-1.34168, if(f22<0.233904, 1.76803E-4, 0.0191606), if(f2<-0.344426, -0.011713, -0.0270393))),if(f18<0.330651, if(f2<-1.30474, if(f21<-0.0465033, -0.0256311, -0.00864613), if(f2<-0.824584, -0.0273856, -0.0311522)), if(f2<-1.37861, if(f22<0.233904, -6.7716E-4, 0.0203041), if(f19<0.514323, -0.0217005, 1.10617E-4))),if(f21<0.101887, if(f2<-1.30474, if(f17<-0.145753, -0.0257026, -0.0135729), if(f18<0.0541038, -0.0307452, -0.0259101)), if(f2<-1.0462, if(f23<-0.0274025, -0.00314162, 0.0178064), if(f2<-0.0489445, -0.016502, -0.0281161))),if(f18<0.607199, if(f2<-1.30474, if(f21<-0.0465033, -0.0246073, -0.00673528), if(f21<-0.0465033, -0.030584, -0.0260979)), if(f2<-1.0462, if(f19<0.514323, -0.00417125, 0.0196098), if(f2<-0.307491, -0.0127647, -0.0256753))),if(f21<0.0647896, if(f2<-1.12007, if(f21<-0.083601, -0.0263189, -0.0161315), if(f19<0.514323, -0.0302128, -0.0146063)), if(f2<-1.0462, if(f23<-0.0274876, -0.0036788, 0.0171262), if(f23<-0.0273257, -0.0243853, -0.00539893))),if(f18<0.330651, if(f2<-1.34168, if(f21<-0.083601, -0.025844, -0.0115585), if(f23<-0.0274336, -0.0296326, -0.0135145)), if(f2<-1.37861, if(f15<0.313696, -0.0057402, 0.0147234), if(f19<0.514323, -0.0208168, 0.00104059))),if(f21<0.0647896, if(f2<-1.0462, if(f19<0.514323, -0.0229019, 0.0143177), if(f3<1.67772, -0.0299549, -0.0240689)), if(f2<-0.861519, if(f22<0.233904, -0.00472233, 0.0151651), if(f2<0.246537, -0.0193216, -0.0284809))),if(f18<0.330651, if(f2<-1.0462, if(f21<-0.0465033, -0.0251667, -0.0104095), if(f23<-0.027387, -0.0295698, -0.0176517)), if(f2<-1.37861, if(f15<0.213168, -0.0062054, 0.0120493), if(f2<-0.307491, -0.0110783, -0.0265832))),if(f18<0.330651, if(f2<-1.30474, if(f21<-0.0465033, -0.023067, -0.00776957), if(f23<-0.0274364, -0.0289648, -0.0132435)), if(f2<-1.0462, if(f23<-0.0274876, -0.0051898, 0.0171133), if(f2<-0.0489445, -0.0154874, -0.0273422))),if(f21<0.0647896, if(f2<-1.157, if(f15<-0.170228, -0.0246292, -0.013444), if(f3<1.82221, -0.0291237, -0.0217857)), if(f2<-1.0462, if(f22<0.233904, -0.00316204, 0.0154117), if(f2<-0.0489445, -0.0146096, -0.0264161))),if(f21<0.027692, if(f2<-1.34168, if(f17<-0.145753, -0.0235227, -0.0111151), if(f2<-0.492167, -0.0259396, -0.0293583)), if(f2<-1.0462, if(f23<-0.0274775, -0.00389493, 0.0165575), if(f2<-0.0120093, -0.01558, -0.0263846))),if(f21<0.0647896, if(f2<-1.12007, if(f21<-0.083601, -0.0243, -0.0136216), if(f23<-0.0274336, -0.0286324, -0.0145423)), if(f2<-1.0462, if(f22<0.233904, -0.00365398, 0.0153315), if(f19<1.63821, -0.02102, 0.0238225))),if(f18<0.330651, if(f2<-1.34168, if(f21<-0.083601, -0.0236564, -0.00883573), if(f23<-0.0274336, -0.0280848, -0.0111912)), if(f2<-0.639908, if(f22<0.233904, -0.00724257, 0.0137201), if(f19<0.514323, -0.0240014, -0.00753991))),if(f18<0.330651, if(f2<-1.30474, if(f21<-0.0465033, -0.0219351, -0.00640791), if(f23<-0.0274336, -0.0279327, -0.0108776)), if(f2<-1.00926, if(f23<-0.0273632, -0.00480692, 0.0170223), if(f19<0.514323, -0.0213351, -0.00180769))),if(f18<0.0541038, if(f2<-1.37861, if(f21<-0.083601, -0.0235011, -0.00839891), if(f2<-0.824584, -0.0248607, -0.0285964)), if(f2<-0.824584, if(f22<0.233904, -0.00835252, 0.013313), if(f23<-0.027483, -0.0240317, -0.00831159))),if(f21<0.101887, if(f2<-1.30474, if(f23<-0.0275324, -0.0179696, 0.0198129), if(f18<0.0541038, -0.0279481, -0.0223771)), if(f2<-0.861519, if(f23<-0.0275123, -0.00265762, 0.0164488), if(f3<0.762661, -0.0237467, -0.012149))),if(f18<0.330651, if(f2<-1.30474, if(f22<0.233904, -0.018176, 0.0239139), if(f21<-0.0465033, -0.0279311, -0.0229631)), if(f2<-1.41555, if(f15<0.299542, -0.00288596, 0.0146125), if(f23<-0.0275224, -0.0169582, 0.00256922))),if(f18<0.330651, if(f2<-1.37861, if(f21<-0.083601, -0.0217513, -0.00510651), if(f2<-0.861519, -0.0229004, -0.0277311)), if(f2<-1.37861, if(f15<0.234618, -0.00350262, 0.0124725), if(f19<0.514323, -0.0173481, 0.00321393))),if(f21<0.027692, if(f2<-1.0462, if(f19<0.514323, -0.0200238, 0.0171979), if(f3<0.537908, -0.0278782, -0.0234473)), if(f2<-0.824584, if(f22<0.233904, -0.00466097, 0.0136956), if(f23<-0.0267027, -0.0222336, -0.00456571))),if(f18<0.330651, if(f2<-1.12007, if(f21<-0.0465033, -0.0217474, -0.00655849), if(f17<-0.145753, -0.027802, -0.0241527)), if(f2<-1.41555, if(f15<0.281926, -0.0036389, 0.0138522), if(f23<-0.0275013, -0.0164405, 0.00408756))),if(f21<0.0647896, if(f2<-0.861519, if(f17<-0.145753, -0.0231098, -0.0132386), if(f3<0.409478, -0.0278062, -0.024319)), if(f2<-0.639908, if(f23<-0.0275123, -0.00347482, 0.0148896), if(f23<-0.0264447, -0.0229005, -0.00699925))),if(f21<0.0647896, if(f2<-1.0462, if(f21<-0.083601, -0.0223385, -0.0117875), if(f23<-0.0274053, -0.0269585, -0.0107354)), if(f2<-0.676843, if(f22<0.233904, -0.00437809, 0.0123147), if(f2<0.246537, -0.016074, -0.0251167))),if(f21<0.027692, if(f2<-1.12007, if(f15<-0.168179, -0.0218167, -0.0113187), if(f3<0.537908, -0.0271329, -0.0224654)), if(f2<-0.750713, if(f2<-1.45248, 0.00855592, -0.00602348), if(f3<0.762661, -0.0231452, -0.012441))),if(f18<0.330651, if(f2<-1.30474, if(f22<0.233904, -0.016494, 0.020885), if(f21<-0.0465033, -0.0268535, -0.0216955)), if(f2<-0.307491, if(f19<0.514323, -0.00533074, 0.014831), if(f26<0.710185, -0.0237398, -0.011374))),if(f18<0.0541038, if(f2<-1.0462, if(f21<-0.0465033, -0.0219392, -0.00877178), if(f3<1.93458, -0.0269058, -0.019639)), if(f2<-0.824584, if(f22<0.233904, -0.006463, 0.0132258), if(f23<-0.0274583, -0.0218482, -0.0058857))),if(f18<0.0541038, if(f2<-1.30474, if(f21<-0.083601, -0.0221812, -0.00835531), if(f21<-0.083601, -0.0270617, -0.02394)), if(f2<-0.861519, if(f23<-0.0275324, -0.00614818, 0.0131402), if(f19<0.514323, -0.0213672, -0.00407202))),if(f18<0.0541038, if(f2<-1.08313, if(f21<-0.083601, -0.022643, -0.0112676), if(f3<1.5814, -0.026662, -0.019801)), if(f2<-0.824584, if(f22<0.233904, -0.00612593, 0.012263), if(f23<-0.0274904, -0.0211091, -0.00233368))),if(f18<0.0541038, if(f2<-1.37861, if(f16<-0.239137, -0.0188253, -0.00454401), if(f2<-0.529102, -0.0229513, -0.0268195)), if(f2<-0.750713, if(f23<-0.0274602, -0.00614992, 0.0133062), if(f23<-0.0274904, -0.0213171, -0.00412817))),if(f2<-1.37861, if(f15<-0.132811, if(f21<-0.083601, -0.0215924, -0.0104046), if(f22<0.233904, -1.63073E-4, 0.0186905)), if(f18<0.0541038, if(f2<-0.529102, -0.0225168, -0.0266387), if(f2<-0.270556, -0.0105984, -0.022791))),if(f21<0.027692, if(f2<-1.0462, if(f34<1.047, -0.0192164, -0.00521649), if(f17<-0.145753, -0.0265041, -0.0227897)), if(f2<-0.639908, if(f22<0.816064, -0.00288566, 0.0169217), if(f2<0.246537, -0.0140013, -0.0241999))),if(f21<0.027692, if(f2<-1.12007, if(f16<-0.242787, -0.0201259, -0.00808464), if(f3<0.489747, -0.0260157, -0.0207128)), if(f2<-0.639908, if(f23<-0.02744, -0.00261545, 0.0137857), if(f2<0.246537, -0.0140533, -0.0238182))),if(f18<0.0541038, if(f2<-1.37861, if(f21<-0.083601, -0.0195403, -0.00404725), if(f2<-0.529102, -0.0219947, -0.0262583)), if(f2<-0.713778, if(f22<0.233904, -0.00568359, 0.0116884), if(f19<0.514323, -0.0208555, -0.00422516))),if(f21<0.027692, if(f2<-1.0462, if(f17<-0.145753, -0.0203972, -0.00936466), if(f3<1.03557, -0.0257088, -0.0194167)), if(f2<-1.41555, if(f15<-0.155165, -0.00949991, 0.00926443), if(f19<1.63821, -0.0135364, 0.0237607))),if(f18<0.0541038, if(f2<-1.0462, if(f21<-0.083601, -0.0214059, -0.00974331), if(f34<1.047, -0.0259517, -0.0218553)), if(f2<-0.639908, if(f22<0.233904, -0.00613251, 0.0111308), if(f26<0.710185, -0.0201313, -0.0042042))),if(f21<0.027692, if(f2<-1.0462, if(f19<0.514323, -0.0167045, 0.0190794), if(f3<1.82221, -0.0253206, -0.015416)), if(f2<-0.787649, if(f26<0.710185, -0.0020031, 0.0137049), if(f3<0.923198, -0.0198948, -0.00623643))),if(f18<0.0541038, if(f2<-1.00926, if(f21<-0.083601, -0.0208989, -0.00980026), if(f26<0.710185, -0.0255514, -0.0158093)), if(f2<-1.41555, if(f15<-0.0716658, -0.00864246, 0.0105223), if(f19<0.514323, -0.0154378, 0.0036082))),if(f18<0.0541038, if(f2<-1.30474, if(f21<-0.083601, -0.0195886, -0.0053619), if(f2<-0.492167, -0.0215964, -0.025656)), if(f2<-0.639908, if(f23<-0.0274675, -0.00518667, 0.0130081), if(f19<0.514323, -0.020339, -0.00196843))),if(f18<0.0541038, if(f2<-1.0462, if(f21<-0.0465033, -0.0193914, -0.00495019), if(f3<0.923198, -0.0253001, -0.0193561)), if(f2<-0.307491, if(f26<0.710185, -0.00597757, 0.0131438), if(f3<1.93458, -0.0218835, -0.0111724))),if(f18<0.0541038, if(f2<-1.00926, if(f21<-0.083601, -0.0205545, -0.00874528), if(f3<0.45764, -0.0254401, -0.020468)), if(f2<-0.676843, if(f23<-0.0269817, -0.00463787, 0.0118526), if(f19<0.514323, -0.0196463, -0.0033643))),if(f21<-0.00940569, if(f2<-1.0462, if(f16<-0.183071, -0.0182319, -0.00593456), if(f3<1.00347, -0.0249632, -0.0178802)), if(f2<-0.639908, if(f22<0.816064, -0.00216648, 0.0165352), if(f3<1.72588, -0.0198618, -0.00470017))),if(f2<-1.30474, if(f15<-0.0350418, if(f17<-0.145753, -0.0194527, -0.00754973), if(f2<-1.45248, 0.00974402, -0.00370784)), if(f17<0.0725664, if(f21<-0.083601, -0.0252342, -0.0208502), if(f26<0.710185, -0.0154227, 0.00400433))),if(f2<-1.12007, if(f16<-0.143284, if(f26<0.710185, -0.016665, 0.0102993), if(f2<-1.45248, 0.00900462, -0.00428733)), if(f17<0.0725664, if(f21<-0.083601, -0.0253491, -0.0218364), if(f2<-0.0858797, -0.00872561, -0.021065))),if(f2<-1.34168, if(f15<-0.166614, if(f34<1.047, -0.0171183, 1.83299E-4), if(f23<-0.0275324, 3.93818E-4, 0.0172173)), if(f18<0.0541038, if(f2<-0.307491, -0.0207135, -0.0251715), if(f2<-0.270556, -0.00831159, -0.0204629))),if(f18<0.0541038, if(f2<-0.972325, if(f21<-0.083601, -0.0199494, -0.0076944), if(f21<-0.083601, -0.0253032, -0.0217702)), if(f2<-0.824584, if(f19<0.514323, -0.00340969, 0.0127759), if(f3<0.698446, -0.0196187, -0.00866917))),if(f21<-0.0465033, if(f2<-1.12007, if(f17<-0.145753, -0.0191026, -0.00792693), if(f3<1.45297, -0.024387, -0.0164437)), if(f2<-0.307491, if(f22<0.233904, -0.0048814, 0.0107847), if(f3<0.537908, -0.0221644, -0.0126672))),if(f18<0.0541038, if(f2<-1.00926, if(f21<-0.083601, -0.0196866, -0.00709398), if(f3<1.82221, -0.0241956, -0.0138806)), if(f2<-0.270556, if(f22<0.233904, -0.00491912, 0.0104728), if(f22<0.233904, -0.0204759, -0.0072575))),if(f18<0.0541038, if(f2<-1.30474, if(f21<-0.083601, -0.0174593, -0.00393995), if(f2<-0.307491, -0.020062, -0.0246688)), if(f2<-0.344426, if(f26<0.710185, -0.00497864, 0.0118008), if(f2<0.505084, -0.0141397, -0.0221725))),if(f18<0.0541038, if(f2<-1.30474, if(f16<-0.245367, -0.0161712, -0.00174936), if(f2<-0.529102, -0.0195409, -0.0244189)), if(f2<-0.307491, if(f23<-0.0275324, -0.004518, 0.0131041), if(f3<1.24427, -0.0201554, -0.0105987))),if(f2<-1.34168, if(f15<-0.177033, if(f21<-0.083601, -0.018526, -0.00658025), if(f2<-1.52635, 0.0126274, -1.24424E-4)), if(f21<-0.0465033, if(f2<-0.270556, -0.0201174, -0.0245897), if(f2<-0.0858797, -0.00718016, -0.0200779))),if(f21<-0.0465033, if(f2<-1.37861, if(f34<1.047, -0.0132565, 0.00599074), if(f2<-0.233621, -0.0199541, -0.0245505)), if(f2<-0.529102, if(f22<0.233904, -0.00378842, 0.0113068), if(f23<-0.0272891, -0.0185491, -8.05495E-5))),if(f2<-1.12007, if(f15<-0.133338, if(f26<0.710185, -0.0159725, 0.00895056), if(f19<0.514323, -0.00175986, 0.0143625)), if(f18<0.0541038, if(f3<0.794768, -0.0238869, -0.0166527), if(f23<-0.0271473, -0.0148805, 0.00465657))),if(f2<-1.37861, if(f15<-0.305603, if(f34<1.047, -0.0166392, 8.04253E-4), if(f22<0.233904, 0.00102779, 0.0147166)), if(f21<-0.0465033, if(f2<-0.196685, -0.0198235, -0.0244308), if(f2<-0.0858797, -0.00633575, -0.0197276))),if(f21<0.027692, if(f2<-0.824584, if(f34<1.047, -0.0154897, 1.09995E-5), if(f3<0.537908, -0.023856, -0.0169742)), if(f2<-0.0489445, if(f23<-0.0274382, -0.00213962, 0.0120583), if(f2<0.652824, -0.0120128, -0.0217093))),if(f18<0.0541038, if(f2<-1.0462, if(f21<-0.083601, -0.0185361, -0.00543586), if(f3<0.425532, -0.0237221, -0.0179644)), if(f2<-1.157, if(f26<0.710185, -0.00110279, 0.0142181), if(f26<0.710185, -0.0141959, 0.00435486))),if(f2<-0.824584, if(f16<-0.240261, if(f3<-0.634014, -0.018646, -0.00711788), if(f2<-1.45248, 0.0078153, -0.00529678)), if(f3<0.570016, if(f23<-0.0274492, -0.0233382, -0.00799437), if(f2<-0.0120093, -0.00155454, -0.0182674))),if(f2<-0.861519, if(f15<-0.164824, if(f26<0.710185, -0.0162352, 0.00926074), if(f22<0.233904, -0.00328193, 0.0118896)), if(f17<0.0725664, if(f3<0.409478, -0.0238263, -0.0178206), if(f3<0.907144, -0.0167608, -0.00379789))),if(f18<0.0541038, if(f2<-1.0462, if(f21<-0.083601, -0.0179763, -0.00507121), if(f34<1.047, -0.023262, -0.0171798)), if(f2<-0.639908, if(f22<0.233904, -0.00307871, 0.0116669), if(f23<-0.027483, -0.0170409, 0.00106687))),if(f18<0.0541038, if(f2<-1.00926, if(f21<-0.083601, -0.0176822, -0.00545413), if(f23<-0.026721, -0.0228865, 0.00179133)), if(f2<-0.307491, if(f26<0.710185, -0.00381416, 0.0116665), if(f23<-0.027483, -0.0176879, -0.00163059))),if(f21<-0.0465033, if(f2<-0.566037, if(f3<0.409478, -0.0165023, -4.35724E-5), if(f34<1.047, -0.0239759, -0.0183195)), if(f2<-0.0858797, if(f26<0.710185, -0.0034239, 0.0122029), if(f3<0.505801, -0.0209, -0.0107831))),if(f18<0.0541038, if(f2<-1.00926, if(f21<-0.083601, -0.0168921, -0.00534506), if(f3<0.409478, -0.0231026, -0.0170205)), if(f2<-1.41555, if(f15<0.268008, -4.56847E-4, 0.0119898), if(f26<0.710185, -0.0111162, 0.00728028))),if(f21<-0.0465033, if(f2<-1.34168, if(f15<-0.132811, -0.014169, 2.24224E-4), if(f2<-0.15975, -0.0183289, -0.0235258)), if(f2<-0.233621, if(f19<0.514323, -0.00291481, 0.0117074), if(f3<1.91853, -0.0184395, -0.00498329))),if(f2<-1.0462, if(f15<-0.133121, if(f34<1.047, -0.0152215, 0.0023598), if(f2<-1.52635, 0.0141334, -0.00188677)), if(f18<0.0541038, if(f21<-0.083601, -0.0234999, -0.0187824), if(f3<1.88642, -0.0133886, 0.00403473))),if(f2<-0.639908, if(f21<-0.0465033, if(f26<0.710185, -0.0147995, 0.0142646), if(f34<1.047, -0.00268568, 0.0110677)), if(f19<0.514323, if(f3<1.40481, -0.0223846, -0.0103507), if(f3<1.05163, -0.00374449, 0.021081))),if(f18<0.0541038, if(f2<-0.787649, if(f21<-0.083601, -0.0176602, -0.004708), if(f3<0.441586, -0.0230211, -0.0162196)), if(f2<-0.0120093, if(f23<-0.0275123, -0.00332561, 0.011975), if(f3<1.93458, -0.0185655, -0.00613896))),if(f2<-0.676843, if(f21<-0.083601, if(f34<1.047, -0.0169237, -0.00216667), if(f22<0.233904, -0.00338784, 0.0127207)), if(f23<-0.0274904, if(f3<0.698446, -0.0223423, -0.0128593), if(f3<0.842929, -0.00255082, 0.0165798))),if(f2<-0.787649, if(f21<-0.083601, if(f34<1.047, -0.016691, -8.18572E-4), if(f26<0.710185, -0.00249094, 0.0130777)), if(f18<0.0541038, if(f3<0.409478, -0.0229619, -0.0163298), if(f3<0.553962, -0.0159963, -0.00459729))),if(f18<0.0541038, if(f2<-0.824584, if(f21<-0.083601, -0.0166128, -0.00462792), if(f3<1.48508, -0.0223866, -0.0106664)), if(f23<-0.0274876, if(f2<-0.15975, -0.00313598, -0.0170872), if(f19<1.63821, 0.00670165, 0.0220602))),if(f21<-0.0465033, if(f2<-1.30474, if(f34<1.047, -0.0109937, 0.0058486), if(f2<0.0249259, -0.0176718, -0.0234548)), if(f2<-0.0120093, if(f26<0.710185, -0.00252435, 0.0123116), if(f3<2.12723, -0.0185088, -0.00202318))),if(f21<-0.0465033, if(f2<-1.0462, if(f17<-0.145753, -0.0148112, -0.00414264), if(f3<1.59746, -0.0218749, -0.00963986)), if(f2<-0.0120093, if(f22<0.233904, -0.00298143, 0.0107893), if(f3<1.82221, -0.0185665, -0.00438659))),if(f2<-0.529102, if(f16<-0.239778, if(f3<-0.0400262, -0.0159345, -0.00298935), if(f2<-1.45248, 0.00898249, -0.00461608)), if(f17<-0.145753, if(f3<0.409478, -0.023489, -0.0179079), if(f23<-0.027483, -0.016491, 0.00185337)))]) as x, 1-1/(1+exp(x)) as p_clickhouse, probability_small as p_xgboost
FROM model
LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment