Polars can run them for sure. Do you want a contribution?

Implementation for Pandas for 22 queries: <a href="https://gist.github.com/UranusS

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

The rest of the queries? about tpch HOT 5 OPEN

pola-rs commented on August 27, 2024

The rest of the queries?

from tpch.

Comments (5)

ghuls commented on August 27, 2024 1

Implementation for Pandas for 22 queries:
https://gist.github.com/UranusSeven/55817bf0f304cc24f5eb63b2f1c3e2cd

from tpch.

ritchie46 commented on August 27, 2024

That would be great!

from tpch.

marsupialtail commented on August 27, 2024

@ritchie46 I have started but ran into a problem. Here is how I wrote query 13:

ref_customer = polars.read_csv("/home/ziheng/tpc-h/customer.tbl", sep="|")
ref_orders = polars.read_csv("/home/ziheng/tpc-h/orders.tbl", sep="|").\
    filter( ~(polars.col("o_comment").str.contains('special') & polars.col("o_comment").str.contains('requests')))
ref = ref_customer.join(ref_orders, left_on="c_custkey", right_on="o_custkey", how="left")\
    .with_column(polars.col("o_orderkey").is_not_null().alias("o_orderkey_1")).groupby("c_custkey").agg([polars.col("o_orderkey_1").sum()])\
    .groupby("o_orderkey_1").count().sort('count',reverse = True)
    #.sort('o_orderkey_1',reverse = True)

However this give wrong results. Any suggestions?

from tpch.

marsupialtail commented on August 27, 2024

NVM i know what the problem is. I need to make sure "special" comes before "requests". Have to use regex.....

from tpch.