Hi all, Currently in SQL Client we can use the "SET 'key'='value'" command to set a value to a config property key for the session. We can also list all config properties by just calling "SET". It would be convenient to show the value of a specific config property given its key(s). Without this, users will need to eyeball the very one config from all config properties which may need scrolling the screen.
I do not find a standard SQL syntax for this. - Some use the syntax "SET 'key'" to show the value, for e.g. Spark SQL and Hive. - Some use the "SHOW" keyword to show session properties, for e.g. CockroachDB. Trino and MySqL support a key pattern in the "SHOW SESSION" statement. I filed FLINK-30459 to track this. I also attached initial PR #21535 that uses the "SET 'key'" syntax. I chose that because I previously used this syntax. It seems simpler to just use one keyword to interact with session configs. When using Hive dialect, Flink SQL also supports that. However, it's not straightforward enough and one probably needs to check the doc first. As Martijn suggested, before improving the code, it's better to get it discussed here first. So, is it a good idea to add this support? Which syntax is preferred by our community, and are there other better ways of supporting this? Thanks,
