[Feature] Support querying system tables by dynamic options

[xiangyuf]

Search before asking

• I searched in the issues and found nothing similar.

Motivation

Currently, if user want to query a system table, the SQL would be like

SELECT * FROM data_table$system_table

The system table and data table is separated by $. This is not convenient to extend for different query engines. For example, some query engine may throw syntax error for $ character, some may have extra check and require data_table$system_table exists in metastore.

It would be better if system tables can be queried by dynamic options. It's easier to extend for different query engine.

Solution

No response

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!