[ 
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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to