Brice Lin
09/09/2022, 5:59 PMtilak chowdary
09/09/2022, 6:00 PMJelena Zanko
09/09/2022, 6:56 PMCalvin Beloy
09/09/2022, 8:30 PM{
"queryType": "timeseries",
"dataSource": "ny_taxi_tipping",
"granularity": "ALL",
"descending": "true",
"filter":{
"type": "bound",
"dimension": "tip_amount",
"ordering": "numeric",
"lower": 1,
"upper": 20
},
"aggregations": [
{
"type" : "quantilesDoublesSketch",
"name" : "tip_amount_count",
"fieldName" : "tip_amount"
}
],
"postAggregations":[
{
"type": "quantilesDoublesSketchToHistogram",
"name": "hist_tip_amount",
"field": {"type":"fieldAccess", "fieldName":"tip_amount_count"},
"numBins":5
}
],
"intervals": [ "2018-01-01T000000.000/2020-01-03T000000.000" ]
}
The reponse looks like this:
[
{
"timestamp": "2020-01-02T000000.000Z",
"result": {
"tip_amount_count": 71372689,
"hist_tip_amount": [
6.186116E7,
6166399.999999999,
2787503.0,
557609.0,
17.0
]
}
}
]
Its returns the count distribution but is missing the bins. Ideally it should return a map of bin -> count.
Any idea how to use the histogram query to be useful? Thanks.Kaushik
09/11/2022, 3:43 PMCory Johannsen
09/12/2022, 8:58 PMThomas
09/13/2022, 12:03 PMMark Herrera
09/13/2022, 8:06 PMThe traceroute data is getting stored in JSON format and the flow data is in v9 format.The question is on the forum, and I'm not finding anything too useful, particularly in connection with the v9 format.
Jelena Zanko
09/14/2022, 4:00 PMRishi Rana
09/14/2022, 5:18 PMWEI-NUNG CHAO
09/14/2022, 9:24 PMdruid.query.scheduler.laning.strategy=hilo
druid.query.scheduler.laning.maxLowPercent=20
But I can’t tell the difference if the high/low laning strategy is on or not. The broker log is only showing the context config i had setup(priority: -1) but didn’t say which lanes it goes to when I do the query. Is there a way that i can see which lane the queries go?
Thank youtilak chowdary
09/14/2022, 9:44 PMRachel Pedreschi
09/14/2022, 10:50 PMtilak chowdary
09/15/2022, 8:32 PMKrzysztof Klimonda
09/16/2022, 7:45 AMvictor regalado
09/16/2022, 3:22 PMSELECT
-- APPROX_COUNT_DISTINCT_DS_THETA(THETA_SKETCH_UNION("ad_users", "ad_free_users"))
*
FROM (
SELECT
DS_THETA("unique_users", 16384) as "ad_users",
DS_THETA('null') as "ad_free_users"
FROM
"unified_ad_event"
WHERE "__time" >= CURRENT_TIMESTAMP - INTERVAL '1' DAY AND "event_name" = 'impression' AND "ad_event_type" = 'sponsored'
UNION ALL
SELECT
DS_THETA('null') as "ad_users",
DS_THETA("unique_users", 16384) as "ad_free_users"
FROM
"users"
WHERE "__time" >= CURRENT_TIMESTAMP - INTERVAL '1' DAY AND "ad_free" = 'true'
)
Abhishek Agarwal
09/16/2022, 4:47 PMtilak chowdary
09/16/2022, 9:30 PMSELECT if(array_length(ids) = 0, null, array_to_string(ids, ',')) from view
No match found for function signature if(<BOOLEAN>, <NULL>, <CHARACTER>)
tilak chowdary
09/17/2022, 12:40 AMSelect id, max(value)
From view
Group by Id
Order by Id
above query is 20x slower than below one
Select id, max(value)
From view
Group by Id
Order by max(value)
eddie n
09/19/2022, 2:54 PMKrzysztof Klimonda
09/19/2022, 3:32 PMFelipe Gonzalez
09/19/2022, 3:44 PMJelena Zanko
09/19/2022, 4:41 PMJohn Jeffers
09/19/2022, 8:47 PM0.23.0
to 24.0.0
? This seems like a pretty major change in how Druid is versioned, but I can't find any announcement about it.Larry Rosenman
09/19/2022, 11:26 PMMBM
09/20/2022, 5:31 AMJelena Zanko
09/20/2022, 3:19 PMSlackbot
09/21/2022, 5:52 AMJelena Zanko
09/21/2022, 3:05 PM