jdbc catalog 统计信息 analyze 支持自动收集吗?

Viewed 34

doris版本:2.1.6
问题描述:doris 全局+catalog 都开启enable_auto_analyze,统计任务一直没执行
是不支持自动收集,还是哪里设置有遗漏,辛苦大佬指教

mysql> show variables like '%enable_auto_analyze%';
+---------------------+-------+---------------+---------+
| Variable_name | Value | Default_Value | Changed |
+---------------------+-------+---------------+---------+
| enable_auto_analyze | true | true | 0 |
+---------------------+-------+---------------+---------+
1 row in set (0.00 sec)

mysql> show variables like '%auto_analyze_start_time%';
+-------------------------+----------+---------------+---------+
| Variable_name | Value | Default_Value | Changed |
+-------------------------+----------+---------------+---------+
| auto_analyze_start_time | 00:00:00 | 00:00:00 | 0 |
+-------------------------+----------+---------------+---------+
1 row in set (0.00 sec)

mysql> show variables like '%auto_analyze_end_time%';
+-----------------------+----------+---------------+---------+
| Variable_name | Value | Default_Value | Changed |
+-----------------------+----------+---------------+---------+
| auto_analyze_end_time | 23:59:59 | 23:59:59 | 0 |
+-----------------------+----------+---------------+---------+
1 row in set (0.00 sec)

mysql> show catalog awhtest214;
+---------------------+------------------------------------------+
| Key | Value |
+---------------------+------------------------------------------+
| user | *** |
| use_meta_cache | false |
| type | jdbc |
| password | *XXX |
| jdbc_url | *** |
| enable.auto.analyze | true |
| driver_url | ojdbc8-19.3.0.0.jar |
| driver_class | oracle.jdbc.driver.OracleDriver |
| create_time | 2024-11-22 11:35:52.491 |
| checksum | *** |
+---------------------+------------------------------------------+

1 Answers

JDBC 外表目前只支持手动全量收集
image.png