Fang-Yu Rao created IMPALA-14337:
------------------------------------
Summary: Calcite Planner: Support queries against virtual columns
Key: IMPALA-14337
URL: https://issues.apache.org/jira/browse/IMPALA-14337
Project: IMPALA
Issue Type: Sub-task
Reporter: Fang-Yu Rao
Assignee: Fang-Yu Rao
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]
