Comments (7)
What indices to add?
from clickbench.
I have found that people from Pinot tried to add a benchmark version with indices but did not submit it:
main...gortiz:ClickBench:main
from clickbench.
If you can take these changes and make them ready for a pull request, it will be helpful.
from clickbench.
@alexey-milovidov https://docs.pinot.apache.org/basics/indexing
Can you please bump up the pinot version to 0.12.1?
from clickbench.
Yes, ClickBench can install any version; please edit this file: https://github.com/ClickHouse/ClickBench/blob/main/pinot/benchmark.sh
Then you can send the results, or we can run it.
from clickbench.
okay.. Let me take a stab it. I am not a pinot expert. I am trying to evaluate Pinot vs clickhouse for my use case with my own data. This benchmark is a good start.
As per this blog 'https://startree.ai/blog/a-tale-of-three-real-time-olap-databases', pinot performs better than clickhouse. Nevertheless, let me read about pinot indexes before I come up with suggestions.
from clickbench.
We stumbled upon this article and found many factual errors and misrepresentations.
We did not find any reproducible scenario where Pinot can be faster than ClickHouse.
Moreover, Pinot is much inferior in usability - you will find obstacles starting with installation and data loading.
from clickbench.
Related Issues (20)
- Databend benchmark is not valid the the latest Databend versions HOT 3
- Does the skipping index have more advantages for test dataset HOT 1
- Why is the perf of cold scan much worse than ever in the last commit of m5d.24xlarge. HOT 1
- Add YTsaurus support
- Can we get a larger dataset? HOT 1
- Add BoilingData to ClickBench HOT 14
- Doris vs Clickhouse for TPC-H HOT 1
- Update DataFusion & results
- AlloyDB benchmark results for 8 vCPU not clear
- Any plan for adding queries with window function? HOT 1
- InfluxDB benchmarks
- Add Cloudberry HOT 1
- Add rank to table?
- Elasticsearch benchmarks flush the cache between queries HOT 6
- ClickHouse appears to run into an overflow on Q3 HOT 2
- Add YDB for comparing HOT 1
- Inaccurate table size calculation of Mysql HOT 1
- Add Quickwit support HOT 5
- feat: add Github Actions to auto generate index.html HOT 1
- Syntax error for postgresql CREATE TABLE HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from clickbench.