[IGNITE-16192] Calcite. Support hidden columns

• Type: New Feature
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Vladimir Ermakov
• Reporter: Iurii Gerzhedovich
• Created: 22/Dec/21 14:04
• Updated: 11/Feb/22 11:04

Description

We should have ability to hide some columns. At first glance it's _key column. It really important for autogenerated PK.
Such columns couldn't be accessed for 'select * ' query, but available for explicit use in select statement.
Another example of hidden column is Oracle rownum.
Also another databases (Oracle, SQLSERVER, MySQL) have support hidden (invisible) columns which could be created user explicitly and amend the visibility through ALTER statement. Maybe we should consider possible extension it for future to support one.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #580