You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Noémi Pap-Takács (Jira)" <ji...@apache.org> on 2025/06/03 12:19:00 UTC
[jira] [Created] (IMPALA-14117) Select files only once for COMPUTE STATS with TABLESAMPLE clause
Noémi Pap-Takács created IMPALA-14117:
-----------------------------------------
Summary: Select files only once for COMPUTE STATS with TABLESAMPLE clause
Key: IMPALA-14117
URL: https://issues.apache.org/jira/browse/IMPALA-14117
Project: IMPALA
Issue Type: Improvement
Components: Frontend
Reporter: Noémi Pap-Takács
In case of COMPUTE STATS, selecting the files to sample is done twice: first during analysis, then in the SCAN plan nodes. The first is necessary, because COMPUTE STATS needs to calculate the sampling to set the value of 'effectiveSamplePerc_' which is used in stats extrapolation to get more precise stats.
We could probably improve this, to always calculate the file samples once, during analysis, and then reuse the result in the SCAN plan node.
In other cases, e.g. SELECT * FROM t TABLESAMPLE SYSTEM(10); we only calculate the sampling in the SCAN plan nodes.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org