{"record":{"id":"dbefdf19358f9b66","repo":"prestodb/presto","slug":"not-supported-dbefdf","errorCode":"NOT_SUPPORTED","errorMessage":"Only predicates that can be pushed down are supported in the SHOW STATS WHERE clause","messagePattern":"Only predicates that can be pushed down are supported in the SHOW STATS WHERE clause","errorType":"error_code","errorClass":"SemanticException","httpStatus":null,"severity":"error","filePath":"presto-main-base/src/main/java/com/facebook/presto/sql/rewrite/ShowStatsRewrite.java","lineNumber":242,"sourceCode":"                    .map(ColumnMetadata::getName)\n                    .map(columnHandles::get)\n                    .filter(Objects::nonNull)\n                    .collect(Collectors.toList()));\n            TableStatistics tableStatistics = metadata.getTableStatistics(session, tableHandle, nonHiddenColumns, constraint);\n            List<String> statsColumnNames = buildColumnsNames();\n            List<SelectItem> selectItems = buildSelectItems(statsColumnNames);\n            List<Expression> resultRows = buildStatisticsRows(tableMetadata, columnHandles, tableStatistics);\n\n            return simpleQuery(selectAll(selectItems),\n                    aliased(new Values(resultRows),\n                            \"table_stats_for_\" + table.getName(),\n                            statsColumnNames));\n        }\n\n        private static void check(boolean condition, ShowStats node, String message)\n        {\n            if (!condition) {\n                throw new SemanticException(NOT_SUPPORTED, node, message);\n            }\n        }\n\n        @Override\n        protected Node visitNode(Node node, Void context)\n        {\n            return node;\n        }\n\n        private Constraint<ColumnHandle> getConstraint(Plan plan)\n        {\n            Optional<TableScanNode> scanNode = searchFrom(plan.getRoot())\n                    .where(TableScanNode.class::isInstance)\n                    .findSingle();\n\n            if (!scanNode.isPresent()) {\n                return Constraint.alwaysFalse();\n            }","sourceCodeStart":224,"sourceCodeEnd":260,"githubUrl":"https://github.com/prestodb/presto/blob/55bb57d202de3b926896fa966c2c4a44c779634e/presto-main-base/src/main/java/com/facebook/presto/sql/rewrite/ShowStatsRewrite.java#L224-L260","documentation":"Show-stats rewrite error: the WHERE clause of SHOW STATS FOR ... WHERE contains a predicate that cannot be pushed down to the connector as a TupleDomain. Only simple pushdown-able predicates on the stats columns are supported; complex expressions are rejected by this guard in the rewrite.","triggerScenarios":"Thrown at presto-main-base/src/main/java/com/facebook/presto/sql/rewrite/ShowStatsRewrite.java:242 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Simplify the WHERE clause to basic comparisons on stats columns","Move complex filtering to a wrapper query over SHOW STATS output","Reference only supported stats columns (e.g. column_name, data_size)"],"exampleFix":null,"handlingStrategy":"validation","validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"55bb57d202de3b926896fa966c2c4a44c779634e","analyzedAt":"2026-09-04T12:50:26.162Z","contentChangedAt":"2026-09-04T12:50:26.162Z","schemaVersion":2},"datasetVersion":"2026-09-11T21:17:09.523Z"}