You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@auron.apache.org by "Iskander14yo (via GitHub)" <gi...@apache.org> on 2025/09/08 20:03:28 UTC

[I] Adding Auron to ClickBench [auron]

Iskander14yo opened a new issue, #1287:
URL: https://github.com/apache/auron/issues/1287

   Hi!
   
   I've just opened a https://github.com/ClickHouse/ClickBench/pull/614 to add Apache Auron to [ClickBench](https://benchmark.clickhouse.com/) - one of the popular benchmarks for analytical workloads.
   
   I thought it might be useful to let Auron community know about this PR. Additionally, this issue may be used to track progress on ClickBench.
   
   And while results yet to be measured I'd also appreciate any feedback on whether my configuration and setup are correct 🙂 
   
   


-- 
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: commits-unsubscribe@auron.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Adding Auron to ClickBench [auron]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #1287: Adding Auron to ClickBench
URL: https://github.com/apache/auron/issues/1287


-- 
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: commits-unsubscribe@auron.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Adding Auron to ClickBench [auron]

Posted by "Iskander14yo (via GitHub)" <gi...@apache.org>.
Iskander14yo commented on issue #1287:
URL: https://github.com/apache/auron/issues/1287#issuecomment-3387217519

   When debugging bench, I noticed following:
   
   Auron may panic
   ```
   thread 'blaze-native-stage-1-part-0' panicked at native-engine/datafusion-ext-plans/src/common/execution_context.rs:432:35:
   output_with_sender: send error: channel closed
   note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
   
   thread 'blaze-native-stage-1-part-0' panicked at native-engine/datafusion-ext-plans/src/common/execution_context.rs:346:21:
   output_with_sender[Project] canceled due to task finished/killed
   ```
   when running query
   ```sql
   SELECT REGEXP_REPLACE(Referer, '^https?://(?:www.)?([^/]+)/.*$', '$1') FROM hits WHERE Referer <> '';
   ```
   
   In addition,
   - Enhanced original query doesn't fail;
   ```sql
   SELECT REGEXP_REPLACE(Referer, '^https?://(?:www\.)?([^/]+)/.*$', '$1') AS k, AVG(length(Referer)) AS l, COUNT(*) AS c, MIN(Referer) FROM hits WHERE Referer <> '' GROUP BY k HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;
   ```
   ```
   +-----------+-----------------+------+-------------------+                      
   |          k|                l|     c|       min(Referer)|
   +-----------+-----------------+------+-------------------+
   |svpressa.ru|283.7283855401811|242465|http://svpressa.ru/|
   +-----------+-----------------+------+-------------------+
   ```
   - Even with panic Auron showed some result and may or may not hang REPL;
   ```
   +--------------------------------------------------------------+
   |regexp_replace(Referer, ^https?://(?:www.)?([^/]+)/.*$, $1, 1)|
   +--------------------------------------------------------------+
   |                                                       go.mail|
   +--------------------------------------------------------------+
   only showing top 1 row
   ```
   
   Hardware & OS: 32GB RAM, i5-10400F, WSL. Resources for Auron: 3GB heap, 6GB memoryOverhead.


-- 
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: commits-unsubscribe@auron.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Adding Auron to ClickBench [auron]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #1287:
URL: https://github.com/apache/auron/issues/1287#issuecomment-3514673610

   This issue is stale because it has been open for 30 days with no activity.


-- 
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: commits-unsubscribe@auron.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Adding Auron to ClickBench [auron]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #1287:
URL: https://github.com/apache/auron/issues/1287#issuecomment-3383782881

   This issue is stale because it has been open for 30 days with no activity.


-- 
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: commits-unsubscribe@auron.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Adding Auron to ClickBench [auron]

Posted by "Iskander14yo (via GitHub)" <gi...@apache.org>.
Iskander14yo commented on issue #1287:
URL: https://github.com/apache/auron/issues/1287#issuecomment-3387246375

   In fact, original query hangs also with
   ```
   thread 'blaze-native-stage-5-part-108' panicked at native-engine/datafusion-ext-plans/src/memmgr/mod.rs:233:17:
   assertion failed: mm_status.mem_spillables >= consumer_status.mem_used
   note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
   
   thread 'blaze-native-stage-5-part-108' panicked at native-engine/datafusion-ext-plans/src/memmgr/mod.rs:115:9:
   assertion failed: mm_status.total_used >= consumer_status.mem_used
   ```
   if I replace `$1` with `\1`. Can attach log file with `RUST_BACKTRACE=1` if it will help.


-- 
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: commits-unsubscribe@auron.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Adding Auron to ClickBench [auron]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #1287:
URL: https://github.com/apache/auron/issues/1287#issuecomment-3573492319

   This issue was closed because it has been inactive for 14 days since being marked as stale.


-- 
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: commits-unsubscribe@auron.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org