You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2021/05/10 10:16:05 UTC
[GitHub] [arrow-datafusion] Jimexist edited a comment on pull request #303: add random SQL function
Jimexist edited a comment on pull request #303:
URL: https://github.com/apache/arrow-datafusion/pull/303#issuecomment-836311947
## singular case
```
> select random() r, random() r2 union all select random() r, random() r2;
+--------------------+--------------------+
| r | r2 |
+--------------------+--------------------+
| 0.570782163304485 | 0.7122336302240444 |
| 0.4344519217750207 | 0.256188733362102 |
+--------------------+--------------------+
2 row in set. Query took 0 seconds.
```
## tabular align case
```
> select c1, random() r1, random() r2 from test;
+----+-----------------------+-----------------------+
| c1 | r1 | r2 |
+----+-----------------------+-----------------------+
| c | 0.8858248695161692 | 0.6143187156567651 |
| d | 0.6852840904479431 | 0.2709251169769842 |
| b | 0.630098981690546 | 0.6077598267065687 |
| a | 0.16307864728987242 | 0.8227547597140914 |
| b | 0.008702150304241929 | 0.38766493311897166 |
| b | 0.9450226561353341 | 0.16156125141103117 |
| e | 0.6926494011573385 | 0.653725968146263 |
| a | 0.4099823846109887 | 0.07170807057149098 |
| d | 0.15579483001397176 | 0.3098832344415323 |
| a | 0.8059293634597469 | 0.7994994516372975 |
| d | 0.6593555317339335 | 0.19312486980857102 |
| a | 0.9086155399677391 | 0.7665270701938516 |
| e | 0.4044800758190923 | 0.05197052666680535 |
| d | 0.0025795018740371045 | 0.46326292155346094 |
| b | 0.2587391359273177 | 0.9162104619942888 |
| c | 0.13645516508526523 | 0.15752850692883258 |
| e | 0.3877465007257497 | 0.5699901097930642 |
| d | 0.47780316828309766 | 0.7885763689480612 |
| d | 0.22794474273876175 | 0.6095793437463859 |
| e | 0.5455296223081574 | 0.4289355617327004 |
| e | 0.2133157137081647 | 0.4184730286437153 |
| d | 0.8158975348529787 | 0.394255938540677 |
| a | 0.656112907355159 | 0.4385685299440685 |
| e | 0.7187571688285945 | 0.4932180835725457 |
| c | 0.4460089214506695 | 0.3288857238339975 |
| a | 0.7659867073691242 | 0.7338590718453064 |
| c | 0.8312317998888263 | 0.713249790823179 |
| a | 0.5034689184624486 | 0.3564531411596683 |
| a | 0.49555953754158066 | 0.5288964005078611 |
| b | 0.488574157540709 | 0.34840668143906095 |
| e | 0.962322293398729 | 0.0017991571576252419 |
| c | 0.405323557632822 | 0.13801508069882895 |
| e | 0.44810564754006976 | 0.32609793459010716 |
| b | 0.0481996264470097 | 0.5624886587309861 |
| a | 0.6856284932837569 | 0.30189559597954085 |
| c | 0.4392762780370185 | 0.22778780763979856 |
| d | 0.01862005761513874 | 0.9484007330304798 |
| c | 0.5493861573252898 | 0.6787226076159059 |
| c | 0.6804506222983264 | 0.40012929715726475 |
| c | 0.17031205277616834 | 0.28969160031465124 |
| b | 0.5516607121077097 | 0.32765665335953154 |
| d | 0.7902397504137304 | 0.8047820664058987 |
| d | 0.6235135313619369 | 0.8611740902370557 |
| a | 0.4089158775121935 | 0.7632865452823412 |
| e | 0.6479818623367095 | 0.3303923993061251 |
| b | 0.8405383629477621 | 0.5761157012684217 |
| b | 0.16013306898301072 | 0.18377799688319274 |
| c | 0.5237107246024528 | 0.18702870828721596 |
| a | 0.4267698184654345 | 0.6080320114682305 |
| d | 0.6752001786973243 | 0.18744579948119555 |
| b | 0.06394198453121214 | 0.8697468928632974 |
| c | 0.5533880608032804 | 0.410087636982861 |
| d | 0.17195857936051007 | 0.9642347754732317 |
| d | 0.24714036094951686 | 0.2087533372695889 |
| b | 0.38223418402701226 | 0.44797491855182825 |
| d | 0.354147713947109 | 0.1583774861902576 |
| e | 0.8978738349376183 | 0.6870679270888751 |
| b | 0.0962990269141899 | 0.9251103720761726 |
| a | 0.08754479049780262 | 0.3061691178397379 |
| b | 0.8347877947374489 | 0.10492831402932445 |
| c | 0.6772625649184507 | 0.5267610906406157 |
| b | 0.6956531376927251 | 0.9243742506850876 |
| c | 0.6096066968750522 | 0.15500300961880753 |
| e | 0.8991012695527614 | 0.014652679069998786 |
| e | 0.4048500168573612 | 0.7288386405759564 |
| d | 0.8738661862341139 | 0.5736561149057426 |
| e | 0.79628104001088 | 0.10359057613551692 |
| c | 0.6015511737143195 | 0.4246275983489023 |
| d | 0.5976422825371586 | 0.7110161517521416 |
| e | 0.13607511799429672 | 0.5692416938012763 |
| e | 0.7050104248345099 | 0.48394357812924893 |
| a | 0.3794121594380737 | 0.2762570292624906 |
| a | 0.3756937524394046 | 0.8349592211879893 |
| e | 0.6780514311786121 | 0.06202299343125328 |
| a | 0.9916898758023276 | 0.25480434620940917 |
| b | 0.11861101237985605 | 0.36793787570512615 |
| e | 0.9779069828477198 | 0.706631326575605 |
| c | 0.05169106965696968 | 0.757319676986232 |
| e | 0.5008578861141886 | 0.5542545101873164 |
| c | 0.3080413824916599 | 0.6461181444579944 |
| a | 0.3499918991104509 | 0.3738674842979186 |
| c | 0.49266139042465706 | 0.44786989508250286 |
| b | 0.8294106157763355 | 0.8250357289976049 |
| a | 0.8145941535102705 | 0.010227803378715983 |
| a | 0.19432122069500224 | 0.500087727457039 |
| c | 0.5228722683904334 | 0.19655375516418694 |
| a | 0.7264844525200564 | 0.7118351314074298 |
| c | 0.1526188214350377 | 0.2543946368251362 |
| c | 0.33950854157702826 | 0.960977006313132 |
| c | 0.6350990913317207 | 0.7731276647898677 |
| b | 0.24010294541852772 | 0.8652139521697786 |
| a | 0.0883054439477311 | 0.4627145656673548 |
| a | 0.540637100589954 | 0.8545095562126641 |
| b | 0.8328479394485582 | 0.5200373050323923 |
| d | 0.527288611622466 | 0.8929364305158876 |
| e | 0.20030569328547343 | 0.5677935767953404 |
| e | 0.7779991255911018 | 0.9255994347346632 |
| d | 0.8406514575091932 | 0.4562466008463426 |
| b | 0.7545561897792099 | 0.47341049730312923 |
| e | 0.2561046134849507 | 0.28863618306585237 |
+----+-----------------------+-----------------------+
100 row in set. Query took 0 seconds.
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org