Xiang Fu
-Xms24G -Xmx24G -XX:+UseG1GC -XX:MaxGCPauseMillis=20 -XX:+ParallelRefProcEnabled -XX:+DisableExplicitGC -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCApplicationConcurrentTime -Xloggc:/opt/pinot/gc-pinot-server.log
Elon
12/07/2020, 6:14 PMElon
12/07/2020, 6:15 PMElon
12/07/2020, 6:16 PMMayank
Elon
12/07/2020, 6:17 PMJackie
12/07/2020, 6:31 PMmmap
to direct
for realtime off-heap allocation improved the GC?Kishore G
Elon
12/08/2020, 7:25 PMMatt
12/08/2020, 10:58 PMKen Krugler
12/11/2020, 1:24 AMKen Krugler
12/11/2020, 1:26 AMElon
12/11/2020, 6:02 AMKen Krugler
12/16/2020, 3:24 PMKen Krugler
12/29/2020, 3:17 PMKen Krugler
01/07/2021, 9:05 PMKen Krugler
01/20/2021, 3:57 PMLeon Liu
06/30/2021, 12:43 PMMayank
Subbu Subramaniam
11/10/2021, 6:31 PMAnish Nair
07/05/2022, 7:51 AMKartik Khare
09/14/2022, 3:37 PMAbhishek Gupta
09/14/2022, 5:26 PMupstream request timeout
,
when using single month data in filter then it is working. Not sure why error message isn't giving valid reason of failure.
Can you guys suggest the right and necessary table config
SELECT
DISTINCTCOUNT( CASE WHEN data_source = 'web' THEN master_id ELSE 'a' END) as activity_account_count,
DISTINCTCOUNT( CASE WHEN data_source in ('b2bn', 'b2bn_excluded') THEN master_id ELSE 'a' END) as kw_account_count,
DISTINCTCOUNT( CASE WHEN data_source = 'fpm' THEN master_id ELSE 'a' END) as fpm_account_count,
DISTINCTCOUNT( CASE WHEN data_source = 'tpm' THEN master_id ELSE 'a' END) as tpm_account_count,
DISTINCTCOUNT( CASE WHEN data_source = 'crm' THEN master_id ELSE 'a' END) as crm_account_count,
DISTINCTCOUNT( CASE WHEN data_source = 'map' THEN master_id ELSE 'a' END) as map_account_count,
DISTINCTCOUNT( master_id) as all_account_count
FROM
six_sense_dapm
WHERE
dt BETWEEN '2022-01-01' AND '2022-08-30'
AND data_source IN ('web', 'b2bn', 'b2bn_excluded', 'fpm', 'tpm', 'crm', 'map')
AND product='__all__'
table config :
{
"OFFLINE": {
"tableName": "sumologic_dapm_OFFLINE",
"tableType": "OFFLINE",
"segmentsConfig": {
"timeType": "DAYS",
"schemaName": "sumologic_dapm",
"replication": "2",
"segmentPushType": "APPEND",
"timeColumnName": "dt",
"allowNullTimeValue": false
},
"tenants": {
"broker": "DefaultTenant",
"server": "DefaultTenant"
},
"tableIndexConfig": {
"invertedIndexColumns": [
"data_source",
"product",
"source_activity_name"
],
"noDictionaryColumns": [
"external_id",
"master_id",
"secondary_id",
"source_activity_desc",
"source_activity_url",
"source_activity_referrer_url",
"source_activity_desc",
"source_activity_url_r",
"metric_value",
"source_id"
],
"rangeIndexColumns": [
"dt"
],
"optimizeDictionaryForMetrics": true,
"enableDefaultStarTree": true,
"enableDynamicStarTreeCreation": true,
"aggregateMetrics": true,
"nullHandlingEnabled": true,
"rangeIndexVersion": 2,
"autoGeneratedInvertedIndex": false,
"createInvertedIndexDuringSegmentGeneration": false,
"sortedColumn": [
"data_source",
"master_id"
],
"loadMode": "MMAP"
},
"metadata": {},
"isDimTable": false
}
}
Prakhar Pande
11/07/2022, 8:16 PM