This was fixed in 1.18.0 (see CALCITE-2651). You can always manually set LIMIT.
ES returns by default 10 records. Now calcite uses scrolling to fetch whole index. On Mon, Nov 4, 2019 at 2:43 PM James James <[email protected]> wrote: > Dear > > Recently I ticked in to a problem that use jdbc:calcite method get > connection and execute query mysql and elasticssearch storage. the results > only return 10 records. checked calcite codes and not found the problems. > hope get help to fixed my problems > > calcite version is 1.17.0 > > Thank in advance >
