Omega359 commented on issue #16252:
URL: https://github.com/apache/datafusion/issues/16252#issuecomment-3702912857
This now seems to work ... extremely slowly though
```sql
$ datafusion-cli
DataFusion CLI v51.0.0
> CREATE EXTERNAL TABLE bigdata STORED AS CSV LOCATION
'benchmarks/data/bigdata.csv' OPTIONS ('has_header' 'true');
0 row(s) fetched.
Elapsed 0.005 seconds.
> CREATE EXTERNAL TABLE find STORED AS CSV LOCATION
'benchmarks/data/find.csv' OPTIONS ('has_header' 'true');
0 row(s) fetched.
Elapsed 0.001 seconds.
> select count(1) from bigdata;
+-----------------+
| count(Int64(1)) |
+-----------------+
| 2278791 |
+-----------------+
1 row(s) fetched.
Elapsed 0.019 seconds.
> select count(1) from find;
+-----------------+
| count(Int64(1)) |
+-----------------+
| 27 |
+-----------------+
1 row(s) fetched.
Elapsed 0.003 seconds.
> select * from bigdata join find ON bigdata.a ~* find.regex;
+---------+------------+----+--------------------------------------------------------------+
| id | a | id | regex
|
+---------+------------+----+--------------------------------------------------------------+
| 2186283 | 3<_C:_g7lm | 4 | 3(.+)c(.+)
|
| 2186288 | bB[60FsIB2 | 7 | 6(.+)f(.+)
|
| 2186293 | o2^98R^BmX | 3 | 2(.+)b(.+)
|
| 2186296 | `4ruUpFgdc | 5 | 4(.+)d(.+)
|
| 2186305 | 5RtP\eofPf | 6 | 5(.+)e(.+)
|
| 2186306 | 7^8jhQy]fO | 8 | 7(.+)f(.+)
|
| 2186306 | 7^8jhQy]fO | 9 | 8(.+)f(.+)
|
| 2186341 | W3TX5dEd4B | 6 | 5(.+)e(.+)
|
| 2186350 | bt1WHsAxp< | 2 | 1(.+)a(.+)
|
| 2186364 | 4DrDXt5]0w | 5 | 4(.+)d(.+)
|
| 2186391 | EH\432=_C6 | 4 | 3(.+)c(.+)
|
| 2186399 | e7^c?f;Xnu | 8 | 7(.+)f(.+)
|
| 2186408 | 2tKSBj5g7> | 3 | 2(.+)b(.+)
|
| 2186410 | SM6iGFAj;_ | 7 | 6(.+)f(.+)
|
| 2186424 | Q54tDfJ[Wv | 5 | 4(.+)d(.+)
|
| 2186459 | @:1TOntmAG | 2 | 1(.+)a(.+)
|
| 2186485 | UEVn?S2wB? | 3 | 2(.+)b(.+)
|
| 2186498 | Q5X?jteTsZ | 6 | 5(.+)e(.+)
|
| 2186506 | I5RhE7^2Dd | 6 | 5(.+)e(.+)
|
| 2186518 | 7^05F``Gd3 | 8 | 7(.+)f(.+)
|
| 2186551 | :3<cOqgFIe | 4 | 3(.+)c(.+)
|
| 2186566 | 2bv6cm9jFx | 7 | 6(.+)f(.+)
|
| 2186576 | fu3R\eJSCl | 4 | 3(.+)c(.+)
|
| 2186580 | 4p7Ij@:aFk | 8 | 7(.+)f(.+)
|
| 2186602 | S73RC<;?WV | 4 | 3(.+)c(.+)
|
| 2186604 | <:7yfXM:]7 | 8 | 7(.+)f(.+)
|
| 2186612 | <5S4y2ylDP | 5 | 4(.+)d(.+)
|
| 2186616 | o5CnDH8eGy | 6 | 5(.+)e(.+)
|
| 2186629 | 1UVAY5EN\> | 2 | 1(.+)a(.+)
|
| 2186651 | I`\16KSKFF | 7 | 6(.+)f(.+)
|
| 2186663 | B[2e3GHc0D | 4 | 3(.+)c(.+)
|
| 2186665 | d5me<KJdG] | 6 | 5(.+)e(.+)
|
| 2186668 | 8Dul4xfY4c | 9 | 8(.+)f(.+)
|
| 2186672 | R5LtE4hyKQ | 6 | 5(.+)e(.+)
|
| 2186681 | cp61[jpaix | 2 | 1(.+)a(.+)
|
| 2186700 | 1FaFrmqrt< | 2 | 1(.+)a(.+)
|
| 2186704 | B7687iqfpg | 7 | 6(.+)f(.+)
|
| 2186704 | B7687iqfpg | 8 | 7(.+)f(.+)
|
| 2186704 | B7687iqfpg | 9 | 8(.+)f(.+)
|
| 2186704 | B7687iqfpg | 25 |
([A-Z]{1})(0[0-9]{4}|[1-6][0-9]{4}|7[0-8][0-9]{3}|7[0-9]{3}) |
| .
|
| .
|
| .
|
+---------+------------+----+--------------------------------------------------------------+
189560 row(s) fetched. (First 40 displayed. Use --maxrows to adjust)
Elapsed 3180.419 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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
