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