.dimensionSpecs(dimSpecs) .metrics(Arrays.asList(ColumnHolder.TIME_COLUMN_NAME, "index")) .intervals(I_0112_0114_SPEC) .build();
.dataSource(DATA_SOURCE) .intervals(SEG_SPEC) .filters(DIM_FILTER) .granularity(GRANULARITY) .dimensions(Collections.singletonList("a")) .metrics(Collections.singletonList("rows")) .pagingSpec(new PagingSpec(null, 3)) .context(CONTEXT); builder.build(), Intervals.of("2011-01-01/2011-01-02"), makeSelectResults(dimensions, metrics, DateTimes.of("2011-01-01"), ImmutableMap.of("a", "b", "rows", 1)), DateTimes.of("2011-01-09T01"), ImmutableMap.of("a", "h", "rows", 9) ), runner.run(QueryPlus.wrap(builder.intervals("2011-01-01/2011-01-10").build()), context) ); .intervals("2011-01-01/2011-01-10") .dimensionSpecs(Collections.singletonList(new DefaultDimensionSpec("a", "a2"))) .build(); TestHelper.assertExpectedResults( makeSelectResults(
SelectQuery query = Druids .newSelectQueryBuilder() .dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .intervals(QueryRunnerTestHelper.fullOnIntervalSpec) .descending(true) .pagingSpec(PagingSpec.newSpec(1)) .build();
public SelectQuery withPagingSpec(PagingSpec pagingSpec) { return Druids.SelectQueryBuilder.copy(this).pagingSpec(pagingSpec).build(); }
@Override public Query<Result<SelectResultValue>> withDataSource(DataSource dataSource) { return Druids.SelectQueryBuilder.copy(this).dataSource(dataSource).build(); }
public static SelectQueryBuilder copy(SelectQuery query) { return new SelectQueryBuilder() .dataSource(query.getDataSource()) .intervals(query.getQuerySegmentSpec()) .descending(query.isDescending()) .filters(query.getFilter()) .granularity(query.getGranularity()) .dimensionSpecs(query.getDimensions()) .metrics(query.getMetrics()) .virtualColumns(query.getVirtualColumns()) .pagingSpec(query.getPagingSpec()) .context(query.getContext()); }
.dimensionSpecs( Arrays.asList( new DefaultDimensionSpec(QueryRunnerTestHelper.marketDimension, "mar"), .build();
.dimensionSpecs(dimSpecs) .metrics(Arrays.asList(ColumnHolder.TIME_COLUMN_NAME, "index")) .intervals(I_0112_0114_SPEC) .build();
queryBuilder.pagingSpec(PagingSpec.newSpec(pagingThreshold)); query = queryBuilder.build();
.intervals(I_0112_0114_SPEC) .filters(new SelectorDimFilter(QueryRunnerTestHelper.marketDimension, "spot", null)) .granularity(QueryRunnerTestHelper.dayGran) .dimensionSpecs(DefaultDimensionSpec.toSpec(QueryRunnerTestHelper.qualityDimension)) .metrics(Collections.singletonList(QueryRunnerTestHelper.indexMetric)) .pagingSpec(new PagingSpec(toPagingIdentifier(param[0], descending), param[1])) .build();
.dataSource(DATA_SOURCE) .intervals(SEG_SPEC) .filters(DIM_FILTER) .granularity(GRANULARITY) .dimensions(Collections.singletonList("a")) .metrics(Collections.singletonList("rows")) .pagingSpec(new PagingSpec(null, 3)) .context(CONTEXT); builder.build(), Intervals.of("2011-01-01/2011-01-02"), makeSelectResults(dimensions, metrics, DateTimes.of("2011-01-01"), ImmutableMap.of("a", "b", "rows", 1)), DateTimes.of("2011-01-09T01"), ImmutableMap.of("a", "h", "rows", 9) ), runner.run(QueryPlus.wrap(builder.intervals("2011-01-01/2011-01-10").build()), context) );
LookupExtractionFn lookupExtractionFn = new LookupExtractionFn(mapLookupExtractor, false, null, true, true); SelectQuery query = newTestQuery() .intervals(I_0112_0114_SPEC) .filters(new SelectorDimFilter(QueryRunnerTestHelper.marketDimension, "replaced", lookupExtractionFn)) .granularity(QueryRunnerTestHelper.dayGran) .dimensionSpecs(DefaultDimensionSpec.toSpec(QueryRunnerTestHelper.qualityDimension)) .metrics(Collections.singletonList(QueryRunnerTestHelper.indexMetric)) .build();
.intervals(new LegacySegmentSpec(interval)) .filters( new AndDimFilter( Arrays.asList( .granularity(QueryRunnerTestHelper.allGran) .dimensionSpecs(DefaultDimensionSpec.toSpec(QueryRunnerTestHelper.qualityDimension)) .metrics(Collections.singletonList(QueryRunnerTestHelper.indexMetric)) .pagingSpec(new PagingSpec(null, 10, true)) .virtualColumns( new ExpressionVirtualColumn("expr", "index / 10.0", ValueType.FLOAT, TestExprMacroTable.INSTANCE) .build();
ImmutableList.of( Druids.newSelectQueryBuilder() .dataSource(CalciteTests.DATASOURCE1) .intervals(QSS(Filtration.eternity())) .granularity(Granularities.ALL) .dimensions(ImmutableList.of("dummy")) .metrics(ImmutableList.of("__time", "cnt", "dim1", "dim2", "dim3", "m1", "m2", "unique_dim1")) .descending(false) .pagingSpec(FIRST_PAGING_SPEC) .context(QUERY_CONTEXT_DEFAULT) .build(), Druids.newSelectQueryBuilder() .dataSource(CalciteTests.DATASOURCE1) .intervals(QSS(Filtration.eternity())) .granularity(Granularities.ALL) .dimensions(ImmutableList.of("dummy")) .metrics(ImmutableList.of("__time", "cnt", "dim1", "dim2", "dim3", "m1", "m2", "unique_dim1")) .descending(false) .pagingSpec( new PagingSpec( ImmutableMap.of("foo_1970-01-01T00:00:00.000Z_2001-01-03T00:00:00.001Z_1", 5), .context(QUERY_CONTEXT_DEFAULT) .build() ), ImmutableList.of(
.intervals(I_0112_0114_SPEC) .dimensionSpecs(DefaultDimensionSpec.toSpec(QueryRunnerTestHelper.marketDimension)) .metrics(Collections.singletonList(QueryRunnerTestHelper.indexMetric)) .build();