Hi All, I am applying pagination on native druid query , Currently using limitspec inbuilt function of DruidGroupBy . I am able to set the liimit but there is no option to set offset so that I can get response of a particular page

DruidGroupByQuery.DruidGroupByQueryBuilder builder = getAQIAggregation();

List<OrderByColumnSpec> orderByColumnSpecs = Collections.singletonList(
        new OrderByColumnSpecMap("deviceID", false, null)
);

DefaultLimitSpec limitSpec=new DefaultLimitSpec(pageSize,orderByColumnSpecs);

String dataSource = "test-dataset";
DruidGroupByQuery query = builder
        .dimensions(Collections.singletonList(new SimpleDimension("deviceID")))
        .dataSource(dataSource)
        .intervals(Collections.singletonList(interval))
        .filter(inFilter)
        .limitSpec(limitSpec)
        .granularity(aggregationGranularity) // Apply the aggregation granularity
        .build();
// Execute the query using Druid HTTP client

how can I achieve the offset thing in the following code

You can use query from deep storage