Description
When executing an aggregation query without a GROUP BY clause (i.e., a global aggregation), a synthetic bucket_root column is added to the result set with no value. This column does not provide meaningful information and can be confusing for users and downstream tools.
Example
SELECT COUNT(*) FROM ecommerce
Current result set:
Expected Behaviour
The bucket_root column should not appear in the result set for global aggregations:
Impact
- Confuses users analyzing query results
- Causes issues with tools that auto-detect column types (empty column)
- Breaks schema expectations in Arrow Flight SQL clients and JDBC consumers
Description
When executing an aggregation query without a
GROUP BYclause (i.e., a global aggregation), a syntheticbucket_rootcolumn is added to the result set with no value. This column does not provide meaningful information and can be confusing for users and downstream tools.Example
Current result set:
Expected Behaviour
The
bucket_rootcolumn should not appear in the result set for global aggregations:Impact