public void Execute()
{
var response = DruidClient.TimeBoundary(q => q
.Filter(new SelectorFilter(Wikiticker.Dimensions.IsAnonymous, "true"))
.DataSource(Wikiticker.DataSource)
);
_results = response.Data.ToList();
}
public void Execute()
{
var response = DruidClient.SegmentMetadata(q => q
.DataSource(Wikipedia.DataSource)
.Interval(FromDate, ToDate)
);
_results = response.Data.ToList();
}
public void Execute()
{
var response = DruidClient.Scan <QueryResult>(q => q
.Filter(new SelectorFilter(Wikiticker.Dimensions.CountryCode, "US"))
.DataSource(Wikiticker.DataSource)
.Interval(FromDate, ToDate)
.Limit(3)
);
_results = response.Data.SelectMany(x => x.Events).ToList();
}
public void Execute()
{
var response = DruidClient.Search(q => q
.DataSource(Wikipedia.DataSource)
.Granularity(Granularities.All)
.SearchDimensions(Wikipedia.Dimensions.Page)
.Query(new ContainsSearchQuery("Dragon"))
.Limit(5)
.Interval(FromDate, ToDate)
);
_results = response.Data.SelectMany(x => x.Result).ToList();
}
public void Execute()
{
var response = DruidClient.Select <QueryResult>(q => q
.Dimensions(Wikiticker.Dimensions.CountryName, Wikiticker.Dimensions.CityName, Wikiticker.Dimensions.Page)
.Metrics(Wikiticker.Metrics.Added, Wikiticker.Metrics.Deleted)
.Paging(new PagingSpec(10))
.Filter(new SelectorFilter(Wikiticker.Dimensions.IsAnonymous, "true"))
.DataSource(Wikiticker.DataSource)
.Interval(FromDate, ToDate)
);
_results = response.Data.SelectMany(x => x.Result.Events).Select(x => x.Event).ToList();
}
public void Execute()
{
var response = DruidClient.GroupBy <QueryResult>(q => q
.Dimensions(Wikiticker.Dimensions.CountryName)
.Aggregations(new LongSumAggregator("totalCount", Wikiticker.Metrics.Count))
.DataSource(Wikiticker.DataSource)
.Filter(new NotFilter(new SelectorFilter(Wikiticker.Dimensions.CountryName, string.Empty)))
.Interval(FromDate, ToDate)
.Granularity(Granularities.All)
);
_results = response.Data.Select(x => x.Event).ToList();
}
public void Execute()
{
var response = DruidClient.Timeseries <QueryResult>(q => q
.Descending(true)
.Aggregations(new LongSumAggregator("totalAdded", Wikiticker.Metrics.Added))
.Filter(new SelectorFilter(Wikiticker.Dimensions.CountryCode, "US"))
.DataSource(Wikiticker.DataSource)
.Interval(FromDate, ToDate)
.Granularity(Granularities.Hour)
);
_results = response.Data;
}
public void Execute()
{
var response = DruidClient.TopN <QueryResult>(q => q
.Dimension(Wikipedia.Dimensions.Page)
.Threshold(10)
.Aggregations(new LongSumAggregator("totalCount", Wikipedia.Metrics.Count))
.Metric("totalCount")
.DataSource(Wikipedia.DataSource)
.Interval(FromDate, ToDate)
.Granularity(Granularities.All)
);
_results = response.Data.SelectMany(x => x.Result).ToList();
}
public void Execute()
{
var response = DruidClient.GroupBy <QueryResult>(q => q
.Dimensions(Wikipedia.Dimensions.CountryName)
.Aggregations(new LongSumAggregator("totalCount", Wikipedia.Metrics.Count))
.DataSource(Wikipedia.DataSource)
.Interval(FromDate, ToDate)
.Granularity(Granularities.All)
.Limit(new DefaultLimitSpec(10, 10,
new OrderByColumnSpec(Wikipedia.Dimensions.CountryName, OrderByDirection.descending))
)
);
_results = response.Data.Select(x => x.Event).ToList();
}
public void Execute()
{
var response = DruidClient.TopN <QueryResult>(q => q
.Metric("totalCount")
.Dimension(Wikiticker.Dimensions.Page)
.Threshold(5)
.Aggregations(new LongSumAggregator("totalCount", Wikiticker.Metrics.Count))
.Filter(new AndFilter(
new SelectorFilter(Wikiticker.Dimensions.IsAnonymous, "true"),
new SelectorFilter(Wikiticker.Dimensions.CountryCode, "US")
))
.DataSource(Wikiticker.DataSource)
.Interval(FromDate, ToDate)
.Granularity(Granularities.All)
);
_results = response.Data.SelectMany(x => x.Result).ToList();
}
public void Execute()
{
var response = DruidClient.Scan <QueryResult>(q => q
.VirtualColumns(new [] {
new ExpressionVirtualColumn(
VirtualColumnName,
"concat(" + Wikipedia.Dimensions.CityName + " + ', ' + " + Wikipedia.Dimensions.CountryName + ")",
ExpressionOutputType.STRING
)
})
.Filter(new SelectorFilter(Wikipedia.Dimensions.CountryCode, "US"))
.DataSource(Wikipedia.DataSource)
.Interval(FromDate, ToDate)
.Limit(3)
);
_results = response.Data.SelectMany(x => x.Events).ToList();
}
