[jira] [Created] (CALCITE-2915) Add RelToSqlConverter support for EnumerableLimit

["Anupam Aggarwal (JIRA)" <ji...@apache.org>]

Anupam Aggarwal created CALCITE-2915:
----------------------------------------

             Summary: Add RelToSqlConverter support for EnumerableLimit
                 Key: CALCITE-2915
                 URL: https://issues.apache.org/jira/browse/CALCITE-2915
             Project: Calcite
          Issue Type: Improvement
    Affects Versions: 1.18.0
            Reporter: Anupam Aggarwal


Enhancing RelToSqlConverter to handle certain physical relNodes.
  --------------------------------------------------------------------------------------------


 Currently a query like this 
  
 _Select * from foo.bar where limit 10 ;_ 
  
 Results in the following (physical) plan (after a MV rewrite to a different table) using volcano
  
 _EnumerableLimit(fetch=[1]): rowcount = 1.0, cumulative cost = \{1.0 rows, 2.0 cpu, 0.0 io}, id = 303_
    _EnumerableTableScan(table=[[viewSchema, barView]]): rowcount = 1.0, cumulative cost = \{0.0 rows, 1.0 cpu, 0.0 io}, id = 176_
  
 While converting the relNode to sql using RelToSqlConverter we get an exception saying 

 

_Caused by: java.lang.reflect.InvocationTargetException_

_Caused by: java.lang.AssertionError: Need to implement org.apache.calcite.adapter.enumerable.EnumerableLimit_
  __  

RelToSqlConverter does not handle EnumerableLimit currently.



More context  :-

http://mail-archives.apache.org/mod_mbox/calcite-dev/201903.mbox/browser

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)