ritchie46
commented
2 years ago The queries did run successful at the time of the benchmarks. We have asserted the correct output for every query.
I think we might have introduced a bug upstream.
Closed riya-verma-23 closed 7 months ago
ritchie46
commented
2 years ago The queries did run successful at the time of the benchmarks. We have asserted the correct output for every query.
I think we might have introduced a bug upstream.
ritchie46
commented
2 years ago How are you running the query? For me it runs correctly:
shape: (100, 8)
┌───────────┬────────────────────┬────────────────┬───────────┬────────────────┬─────────────────────────────────────┬─────────────────┬─────────────────────────────────────┐
│ s_acctbal ┆ s_name ┆ n_name ┆ p_partkey ┆ p_mfgr ┆ s_address ┆ s_phone ┆ s_comment │
│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │
│ f64 ┆ str ┆ str ┆ i64 ┆ str ┆ str ┆ str ┆ str │
╞═══════════╪════════════════════╪════════════════╪═══════════╪════════════════╪═════════════════════════════════════╪═════════════════╪═════════════════════════════════════╡
│ 9938.53 ┆ Supplier#000005359 ┆ UNITED KINGDOM ┆ 185358 ┆ Manufacturer#4 ┆ QKuHYh,vZGiwu2FWEJoLDx04 ┆ 33-429-790-6131 ┆ uriously regular requests hag │
├╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 9937.84 ┆ Supplier#000005969 ┆ ROMANIA ┆ 108438 ┆ Manufacturer#1 ┆ ANDENSOSmk,miq23Xfb5RWt6dvUcvt6Q... ┆ 29-520-692-3537 ┆ efully express instructions. reg... │
├╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 9936.22 ┆ Supplier#000005250 ┆ UNITED KINGDOM ┆ 249 ┆ Manufacturer#4 ┆ B3rqp0xbSEim4Mpy2RH J ┆ 33-320-228-2957 ┆ etect about the furiously final ... │
├╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 9923.77 ┆ Supplier#000002324 ┆ GERMANY ┆ 29821 ┆ Manufacturer#4 ┆ y3OD9UywSTOk ┆ 17-779-299-1839 ┆ ackages boost blithely. blithely... │
├╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ ... ┆ ... ┆ ... ┆ ... ┆ ... ┆ ... ┆ ... ┆ ... │
├╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 7871.5 ┆ Supplier#000007206 ┆ RUSSIA ┆ 104695 ┆ Manufacturer#1 ┆ 3w fNCnrVmvJjE95sgWZzvW ┆ 32-432-452-7731 ┆ ironic requests. furiously final... │
├╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 7852.45 ┆ Supplier#000005864 ┆ RUSSIA ┆ 8363 ┆ Manufacturer#4 ┆ WCNfBPZeSXh3h,c ┆ 32-454-883-3821 ┆ usly unusual pinto beans. brave ... │
├╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 7850.66 ┆ Supplier#000001518 ┆ UNITED KINGDOM ┆ 86501 ┆ Manufacturer#1 ┆ ONda3YJiHKJOC ┆ 33-730-383-3892 ┆ ifts haggle fluffily pending pai │
├╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 7843.52 ┆ Supplier#000006683 ┆ FRANCE ┆ 11680 ┆ Manufacturer#4 ┆ 2Z0JGkiv01Y00oCFwUGfviIbhzCdy ┆ 16-464-517-8943 ┆ express, final pinto beans x-ray... │
└───────────┴────────────────────┴────────────────┴───────────┴────────────────┴─────────────────────────────────────┴─────────────────┴─────────────────────────────────────┘
Code block 'Get result of polars Query 2' took: 0.01207 s
Code block 'Testing result of polars Query 2' took: 0.00393 s
Code block 'Overall execution of polars Query 2' took: 0.01607 s
When running query number 2 separately from other queries, it outputs the error that it is unable to find the column s_acctbal. I believe the error lies in the order of joining the result table in the final query which causes loss of the desired columns in the final output. I think this is the reason why query #2 times are much lower compared to other queries, because the query isn't executed completely as it throws an error.