make recipe
inverted index
"invertedIndexColumns": [ "country", "browserType", "deviceBrand" ],
startree index
"starTreeIndexConfigs": [ { "dimensionsSplitOrder": [ "country", "browserType", "deviceBrand" ], "skipStarNodeCreationForDimensions": [], "functionColumnPairs": [ "COUNT__*", "SUM__timeSpent", "AVG__timeSpent" ], "maxLeafRecords": 10000 } ],
select browserType, count(*) from webtraffic WHERE country = 'Uruguay' GROUP BY browserType limit 10
select country, sum(timeSpent) AS totalTime from webtraffic group by country order by totalTime DESC limit 10
select count(*), sum(timeSpent) AS totalTime from webtraffic where country = 'United Kingdom' order by totalTime DESC limit 10
select browserType, count(*) from webtraffic WHERE country IN ('Germany', 'United Kingdom', 'Spain') GROUP BY browserType limit 10
FROM webtraffic
FROM webtraffic_inverted
FROM webtraffic_stree
make clean
docker system prune
Was this page helpful?