Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

benchmark result #1

Open
liukun4515 opened this issue Jan 18, 2022 · 0 comments
Open

benchmark result #1

liukun4515 opened this issue Jan 18, 2022 · 0 comments
Labels
enhancement New feature or request

Comments

@liukun4515
Copy link
Owner

parameters

Run test on my Mac laptop

CPU: 2.9 GHz Quad-Core Intel Core i7

Memory: 16 GB 2133 MHz LPDDR3

Disk : Macintosh HD

All tests are run with 1 thread except for DataFusion.

DataFusion by default read parquet files in async thread. Code was modified to run with 1 thread in sync model.

files

Files:

orders.parquet 67531831

customer.parquet 13016018

region.parquet 649

nation.parquet 943

partsupp.parquet 45663875

supplier.parquet 815498

part.parquet 8904786

lineitem.parquet 301410196

result

TPCH-SQL arrow-rs-async-read-parquest file arrow-rs-sync-read-parquest file arrow2-async-read-parquest file arrow2-sync-read-parquest file duckdb
1 679.9 ms 1283.5 ms 599.6 ms 1003.7 ms 1114 ms
3 579.6 ms 924.1 ms 314.4 ms 572.0 ms 629 ms
5 902.7 ms 1237.5 ms 700.0 ms 1033.6 ms 638 ms
6 366.6 ms 582.1 ms 213.8 ms 356.0 ms 470 ms
7 2968.5 ms 3526.5 ms 2852.4 ms 957 ms
10 1364.7 ms 1481.8 ms 833.3 ms 857 ms
12 589.0 ms 892.6 ms 783 ms
@liukun4515 liukun4515 added the enhancement New feature or request label Jan 18, 2022
liukun4515 pushed a commit that referenced this issue Sep 1, 2022
…#3228)

* Fix propagation of optimized predicates on nested projections

* Add SQL integration tests

* Alternative implementation on `issue_filters` (#1)
liukun4515 pushed a commit that referenced this issue May 28, 2024
…aTypes) (apache#8985)

* ScalarValue return types from argument values

* change file name

* try using ?Sized

* use Ok

* move method default impl outside trait

* Use type trait for ExprSchemable

* fix nit

* Proposed Return Type from Expr suggestions (#1)

* Improve return_type_from_args

* Rework example

* Update datafusion/core/tests/user_defined/user_defined_scalar_functions.rs

---------

Co-authored-by: Junhao Liu <[email protected]>

* Apply suggestions from code review

Co-authored-by: Alex Huang <[email protected]>

* Fix tests + clippy

* rework types to use dyn trait

* fmt

* docs

* Apply suggestions from code review

Co-authored-by: Jeffrey Vo <[email protected]>

* Add docs explaining what happens when both `return_type` and `return_type_from_exprs` are called

* clippy

* fix doc -- comedy of errors

---------

Co-authored-by: Andrew Lamb <[email protected]>
Co-authored-by: Alex Huang <[email protected]>
Co-authored-by: Jeffrey Vo <[email protected]>
liukun4515 pushed a commit that referenced this issue May 28, 2024
* refactor `TreeNode::rewrite()`

* use handle_tree_recursion in `Expr`

* use macro for transform recursions

* fix api

* minor fixes

* fix

* don't trust `t.transformed` coming from transformation closures, keep the old way of detecting if changes were made

* rephrase todo comment, always propagate up `t.transformed` from the transformation closure, fix projection pushdown closure

* Fix `TreeNodeRecursion` docs

* extend Skip (Prune) functionality to Jump as it is defined in https://synnada.notion.site/synnada/TreeNode-Design-Proposal-bceac27d18504a2085145550e267c4c1

* fix Jump and add tests

* jump test fixes

* fix clippy

* unify "transform" traversals using macros, fix "visit" traversal jumps, add visit jump tests, ensure consistent naming `f` instead of `op`, `f_down` instead of `pre_visit` and `f_up` instead of `post_visit`

* fix macro rewrite

* minor fixes

* minor fix

* refactor tests

* add transform tests

* add apply, transform_down and transform_up tests

* refactor tests

* test jump on both a and e nodes in both top-down and bottom-up traversals

* better transform/rewrite tests

* minor fix

* simplify tests

* add stop tests, reorganize tests

* fix previous merges and remove leftover file

* Review TreeNode Refactor (#1)

* Minor changes

* Jump doesn't ignore f_up

* update test

* Update rewriter

* LogicalPlan visit update and propagate from children flags

* Update tree_node.rs

* Update map_children's

---------

Co-authored-by: Mustafa Akur <[email protected]>

* fix

* minor fixes

* fix f_up call when f_down returns jump

* simplify code

* minor fix

* revert unnecessary changes

* fix `DynTreeNode` and `ConcreteTreeNode` `transformed` and `tnr` propagation

* introduce TransformedResult helper

* fix docs

* restore transform as alias to trassform_up

* restore transform as alias to trassform_up 2

* Simplifications and comment improvements (#2)

---------

Co-authored-by: Berkay Şahin <[email protected]>
Co-authored-by: Mustafa Akur <[email protected]>
Co-authored-by: Mehmet Ozan Kabak <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant