iodone commented on PR #2678:
URL: 
https://github.com/apache/incubator-kyuubi/pull/2678#issuecomment-1128623569

   > > Supports FETCH_NEXT mode only, consistent with Trino Server's 
capabilities
   > 
   > IIRC, it may break HUE export data functionality. Can we support both?
   
   IMO, trino is designed to return results based on the pipeline model and 
does not have the capability of other fetch order types. If we want to support 
it, need to cache the trino results on the Server side, but Kyuubi Server is 
not suitable for caching results as the Gateway, because it may lead to OOM.
   
   
![image](https://user-images.githubusercontent.com/5451385/168775313-ffb2eee3-849a-4aa9-9560-9132d969dd72.png)
   
https://trino.io/docs/current/sql/select.html?highlight=fetch#limit-or-fetch-first-clause
 
   
   It was found that Trino SQL originally supported these order modes.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to