Fabian Hueske created FLINK-7217:
------------------------------------

             Summary: Give hints about unsupported SQL / Table API features.
                 Key: FLINK-7217
                 URL: https://issues.apache.org/jira/browse/FLINK-7217
             Project: Flink
          Issue Type: Improvement
          Components: Table API & SQL
            Reporter: Fabian Hueske


The Table API and SQL do not support every type of query. While being valid 
SQL, we cannot translate certain queries into execution plans. Especially, the 
supported syntax of streaming queries is limited and will probably always be 
limited.

Therefore it is important to explain a user why a query could not be 
translated. The problem here is that we need to wait for the optimizer to 
explore the full search space and apply all transformation rules before we can 
tell the user that the query could not be translated. Hence, we cannot simply 
throw an exception if a rule cannot be applied, because another rule might 
succeed. If we throw an exception in the optimizer, we would kill the 
exploration and miss a valid plan. However, after the optimizer failed, we are 
missing the complete context and cannot provide valuable feedback beyond "query 
uses an unsupported feature".

We should try to improve the situation and provide better feedback to users. 
One approach would be that rules collect possible reasons why they could not be 
applied and these reasons are returned to the user when the translation fails.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to