.dataSource(CalciteTests.DATASOURCE1) .intervals(new MultipleIntervalSegmentSpec(ImmutableList.of(Filtration.eternity()))) .granularity(Granularities.ALL) .virtualColumns( new ExpressionVirtualColumn( "a4:v", .aggregators(ImmutableList.of( new ApproximateHistogramAggregatorFactory("a0:agg", "m1", null, null, null, null), new ApproximateHistogramAggregatorFactory("a2:agg", "m1", 200, null, null, null), new ApproximateHistogramAggregatorFactory("a8:agg", "cnt", null, null, null, null) )) .postAggregators( new QuantilePostAggregator("a0", "a0:agg", 0.01f), new QuantilePostAggregator("a1", "a0:agg", 0.50f), new QuantilePostAggregator("a8", "a8:agg", 0.50f) .context(ImmutableMap.of("skipEmptyBuckets", true, PlannerContext.CTX_SQL_QUERY_ID, "dummy")) .build(), Iterables.getOnlyElement(queryLogHook.getRecordedQueries()) );
); TimeseriesQuery query = Druids.newTimeseriesQueryBuilder() .dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .filters(andDimFilter) .intervals(QueryRunnerTestHelper.firstToThird) .aggregators(aggregatorFactoryList) .postAggregators(QueryRunnerTestHelper.addRowsIndexConstant) .descending(descending) .build();
public TimeseriesQueryBuilder virtualColumns(VirtualColumn... virtualColumns) { return virtualColumns(VirtualColumns.create(Arrays.asList(virtualColumns))); }
public static TimeseriesQueryBuilder copy(TimeseriesQuery query) { return new TimeseriesQueryBuilder() .dataSource(query.getDataSource()) .intervals(query.getQuerySegmentSpec()) .descending(query.isDescending()) .virtualColumns(query.getVirtualColumns()) .filters(query.getDimensionsFilter()) .granularity(query.getGranularity()) .aggregators(query.getAggregatorSpecs()) .postAggregators(query.getPostAggregatorSpecs()) .limit(query.getLimit()) .context(query.getContext()); }
ImmutableList.of( Druids.newTimeseriesQueryBuilder() .dataSource(CalciteTests.DATASOURCE1) .intervals(QSS(Filtration.eternity())) .granularity(Granularities.ALL) .virtualColumns( EXPRESSION_VIRTUAL_COLUMN("a4:v", "concat(substring(\"dim2\", 0, 1),'x')", ValueType.STRING) .aggregators( AGGS( new LongSumAggregatorFactory("a0", "cnt"), .context(TIMESERIES_CONTEXT_DEFAULT) .build() ), NullHandling.replaceWithDefault() ?
); TimeseriesQuery query = Druids.newTimeseriesQueryBuilder() .dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .filters(andDimFilter) .intervals(QueryRunnerTestHelper.firstToThird) .aggregators(aggregatorFactoryList) .postAggregators(QueryRunnerTestHelper.addRowsIndexConstant) .descending(descending) .build();
.dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .filters(QueryRunnerTestHelper.marketDimension, "total_market") .intervals(QueryRunnerTestHelper.firstToThird) .aggregators( QueryRunnerTestHelper.rowsCount, QueryRunnerTestHelper.indexLongSum, QueryRunnerTestHelper.qualityUniques .postAggregators(QueryRunnerTestHelper.addRowsIndexConstant) .descending(descending) .build();
.dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .filters(QueryRunnerTestHelper.marketDimension, "spot") .intervals(QueryRunnerTestHelper.firstToThird) .aggregators( QueryRunnerTestHelper.rowsCount, QueryRunnerTestHelper.indexLongSum, QueryRunnerTestHelper.qualityUniques .postAggregators(QueryRunnerTestHelper.addRowsIndexConstant) .descending(descending) .build();
.dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .filters("bobby", null) .intervals(QueryRunnerTestHelper.firstToThird) .aggregators(aggregatorFactoryList) .postAggregators(QueryRunnerTestHelper.addRowsIndexConstant) .descending(descending) .build();
.dataSource(DATA_SOURCE) .intervals(SEG_SPEC) .filters(DIM_FILTER) .granularity(PT1H_TZ_GRANULARITY) .aggregators(AGGS) .postAggregators(POST_AGGS) .context(CONTEXT); builder.build(), Intervals.of("2011-11-04/2011-11-08"), makeTimeResults( HashMap<String, List> context = new HashMap<String, List>(); TimeseriesQuery query = builder .intervals("2011-11-04/2011-11-08") .aggregators(RENAMED_AGGS) .postAggregators(RENAMED_POST_AGGS) .build(); TestHelper.assertExpectedResults( makeRenamedTimeResults(
.dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .filters(QueryRunnerTestHelper.marketDimension, "upfront") .intervals(QueryRunnerTestHelper.firstToThird) .aggregators( QueryRunnerTestHelper.rowsCount, QueryRunnerTestHelper.indexLongSum, QueryRunnerTestHelper.qualityUniques .postAggregators(QueryRunnerTestHelper.addRowsIndexConstant) .descending(descending) .build();
.dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .filters(QueryRunnerTestHelper.marketDimension, "spot", "upfront", "total_market") .intervals(QueryRunnerTestHelper.firstToThird) .aggregators( QueryRunnerTestHelper.rowsCount, QueryRunnerTestHelper.indexLongSum, QueryRunnerTestHelper.qualityUniques .postAggregators(QueryRunnerTestHelper.addRowsIndexConstant) .descending(descending) .build();
.dataSource(dataSource) .granularity(allGran) .intervals(fullOnInterval) .filters(marketDimension, "breakstuff") .aggregators( Lists.newArrayList( Iterables.concat( .postAggregators(addRowsIndexConstant) .build(); QueryRunner runner = TestQueryRunners.makeTimeSeriesQueryRunner(segment3); HashMap<String, Object> context = new HashMap<String, Object>();
.dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .intervals(QueryRunnerTestHelper.firstToThird) .aggregators( Arrays.asList( QueryRunnerTestHelper.rowsCount, .descending(descending) .build();
); TimeseriesQuery query = Druids.newTimeseriesQueryBuilder() .dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .filters(andDimFilter) .intervals(QueryRunnerTestHelper.firstToThird) .aggregators(aggregatorFactoryList) .postAggregators(QueryRunnerTestHelper.addRowsIndexConstant) .descending(descending) .build(); Map<String, Object> resultMap = new HashMap<>(); resultMap.put("rows", 0L);
Collections.singletonList( Druids.newTimeseriesQueryBuilder() .dataSource(CalciteTests.DATASOURCE1) .intervals(QSS(Filtration.eternity())) .filters(SELECTOR("dim2", "a", null)) .granularity(Granularities.YEAR) .aggregators( AGGS( new DoubleSumAggregatorFactory("a0", "m1"), .postAggregators( EXPRESSION_POST_AGG("p0", "(\"a0\" + \"a1\")") .descending(true) .context(TIMESERIES_CONTEXT_DEFAULT) .build() ), ImmutableList.of(
.dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .intervals(QueryRunnerTestHelper.firstToThird) .aggregators( Arrays.asList( QueryRunnerTestHelper.rowsCount, .descending(descending) .virtualColumns( new ExpressionVirtualColumn( "expr", .build();
.dataSource(QueryRunnerTestHelper.unionDataSource) .granularity(QueryRunnerTestHelper.dayGran) .intervals(QueryRunnerTestHelper.firstToThird) .aggregators( Arrays.asList( QueryRunnerTestHelper.rowsCount, .descending(descending) .build();
.dataSource(QueryRunnerTestHelper.dataSource) .granularity(QueryRunnerTestHelper.dayGran) .filters(new NotDimFilter(new SelectorDimFilter("bobby", "sally", null))) .intervals(QueryRunnerTestHelper.firstToThird) .aggregators(aggregatorFactoryList) .postAggregators(QueryRunnerTestHelper.addRowsIndexConstant) .descending(descending) .build();
.dataSource("dummy") .intervals("2015-01-01/2015-01-02") .descending(descending) .granularity(Granularities.ALL) .aggregators( ImmutableList.of( new CountAggregatorFactory("metric1"), .build(); .dataSource("dummy") .intervals("2015-01-01/2015-01-02") .descending(descending) .granularity(Granularities.ALL) .aggregators( ImmutableList.of( new LongSumAggregatorFactory("metric0", "metric0"), .build();