Hello, I'm writing to ask for help with generating completion hints for Flink SQL. I'm trying to use the Calcite SqlAdisor with the Flink parser. My problem is that I can get completion working for table names, but not column names.
"select a.mgr from ^stuff a" gives me good results: CATALOG.SALES.EMP, CATALOG.SALES, etc, but "select a.^ from sales.emp a" gives me only "*". See https://github.com/mnuttall/sql-testing/blob/main/src/main/java/test/AdvisorBuilder.java for how I'm constructing my SqlAdvisor and https://github.com/mnuttall/sql-testing/blob/main/src/test/java/test/TestCompletion.java for some simple test code. Should it be possible to get completion for column names in my second example? Can anyone please point me to a working example in test code, or spot what I've done wrong in my test code? Very many thanks in advance for any help anyone can offer. Regards, Mark