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 "Steve Carlin (Jira)" <ji...@apache.org> on 2026/04/20 16:06:00 UTC
[jira] [Updated] (IMPALA-14337) Calcite Planner: Support queries against virtual columns
[ https://issues.apache.org/jira/browse/IMPALA-14337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steve Carlin updated IMPALA-14337:
----------------------------------
Parent: (was: IMPALA-12871)
Issue Type: Improvement (was: Sub-task)
> Calcite Planner: Support queries against virtual columns
> --------------------------------------------------------
>
> Key: IMPALA-14337
> URL: https://issues.apache.org/jira/browse/IMPALA-14337
> Project: IMPALA
> Issue Type: Improvement
> Reporter: Fang-Yu Rao
> Assignee: Fang-Yu Rao
> Priority: Major
>
> Currently the Calcite planner in Impala does not support queries against virtual columns. We should consider adding the support for this.
> For instance, we should support the following query like Impala's classic frontend does.
> {code}
> [localhost:21050] default> select INPUT__FILE__NAME, id from functional.alltypestiny;
> Query: select INPUT__FILE__NAME, id from functional.alltypestiny
> Query submitted at: 2025-08-21 11:45:30 (Coordinator: http://fangyu:25000)
> Query state can be monitored at: http://fangyu:25000/query_plan?query_id=b447a77bcf99aac2:e471990900000000
> +---------------------------------------------------------------------------------+----+
> | input__file__name | id |
> +---------------------------------------------------------------------------------+----+
> | hdfs://localhost:20500/test-warehouse/alltypestiny/year=2009/month=4/090401.txt | 6 |
> | hdfs://localhost:20500/test-warehouse/alltypestiny/year=2009/month=4/090401.txt | 7 |
> | hdfs://localhost:20500/test-warehouse/alltypestiny/year=2009/month=1/090101.txt | 0 |
> | hdfs://localhost:20500/test-warehouse/alltypestiny/year=2009/month=1/090101.txt | 1 |
> | hdfs://localhost:20500/test-warehouse/alltypestiny/year=2009/month=3/090301.txt | 4 |
> | hdfs://localhost:20500/test-warehouse/alltypestiny/year=2009/month=3/090301.txt | 5 |
> | hdfs://localhost:20500/test-warehouse/alltypestiny/year=2009/month=2/090201.txt | 2 |
> | hdfs://localhost:20500/test-warehouse/alltypestiny/year=2009/month=2/090201.txt | 3 |
> +---------------------------------------------------------------------------------+----+
> Fetched 8 row(s) in 1.72s
> {code}
--
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