Diogo Baeder
04/17/2022, 9:34 PMSaumya Upadhyay
04/18/2022, 3:54 AMSaumya Upadhyay
04/18/2022, 6:35 AMKISHORE B R
04/18/2022, 8:46 AMLuis Fernandez
04/18/2022, 8:09 PM- name: ZK_PURGE_INTERVAL
value: "1"
- name: ZK_SNAP_RETAIN_COUNT
value: "3"
in the logs i can see things getting set:
2022-04-15 16:14:35,914 [myid:1] - INFO [main:DatadirCleanupManager@78] - autopurge.snapRetainCount set to 3
2022-04-15 16:14:35,915 [myid:1] - INFO [main:DatadirCleanupManager@79] - autopurge.purgeInterval set to 1
2022-04-15 16:14:35,979 [myid:1] - INFO [PurgeTask:DatadirCleanupManager$PurgeTask@138] - Purge task started.
2022-04-15 16:14:35,980 [myid:1] - INFO [main:ManagedUtil@46] - Log4j found with jmx enabled.
2022-04-15 16:14:35,988 [myid:1] - INFO [PurgeTask:DatadirCleanupManager$PurgeTask@144] - Purge task completed.
however i don’t see any more logs of clean up logs after, is there a reason for this? also, i can see that the space is being chugged by the logs does anyone know why things may not get cleaned up? Thank you would appreciate your help.Prashant Pandey
04/19/2022, 10:49 AMSrini Kadamati
04/19/2022, 5:13 PMYeongju Kang
04/20/2022, 1:08 PMDiogo Baeder
04/20/2022, 2:57 PMAbhijeet Kushe
04/20/2022, 7:24 PMselect taskName, taskResult, distinctcount(personId) from events where accountId = 1100609261882 AND workId = '40d9652e-c543-4bd2-aa4d-a11c7b23a6df' group by taskName, taskResult order by mode(createdOn) asc limit 10000
but this throws an exception
select taskName, taskResult, distinctcount(personId) from events where accountId = 1100609261882 AND workId = '40d9652e-c543-4bd2-aa4d-a11c7b23a6df' group by taskName, taskResult order by createdOn asc limit 10000
[
{
"message": "QueryExecutionError:\nProcessingException(errorCode:450, message:InternalError:\njava.lang.NullPointerException\n\tat org.apache.pinot.core.operator.combine.GroupByOrderByCombineOperator.mergeResults(GroupByOrderByCombineOperator.java:230)\n\tat org.apache.pinot.core.operator.combine.BaseCombineOperator.getNextBlock(BaseCombineOperator.java:120)\n\tat org.apache.pinot.core.operator.combine.BaseCombineOperator.getNextBlock(BaseCombineOperator.java:50)",
"errorCode": 200
}
]
mode(createdOn) asc
is the difference
what makes it work ..is this a bug ?Slackbot
04/21/2022, 2:45 AMkaushal aggarwal
04/21/2022, 10:27 AMGrace Lu
04/21/2022, 3:52 PMselect uuid, count(*) from table group by 1
I get very inaccurate aggregation result, for example, uuid a
will show it only has 3 records in count() here, but if I only query specifically for this uuid, like `select uuid, count() from table where uuid='a' group by 1` , it will show the correct result which is 100. Can someone help me understand what is going on here?🙏Xiang Fu
Saumya Upadhyay
04/22/2022, 7:54 AMLuis Fernandez
04/22/2022, 3:56 PMDiogo Baeder
04/22/2022, 9:28 PMDiogo Baeder
04/22/2022, 9:29 PMDiogo Baeder
04/24/2022, 2:56 PMDiogo Baeder
04/25/2022, 12:25 AMCannot read single-value from Collection:
. More on this thread.yelim yu
04/25/2022, 1:32 AMLars-Kristian Svenøy
04/25/2022, 11:00 AMHarish Bohara
04/25/2022, 11:48 AMSaumya Upadhyay
04/26/2022, 9:31 AMcontroller:
...
service:
annotations:
"<http://prometheus.io/scrape|prometheus.io/scrape>": "true"
"<http://prometheus.io/port|prometheus.io/port>": "8008"
...
podAnnotations:
"<http://prometheus.io/scrape|prometheus.io/scrape>": "true"
"<http://prometheus.io/port|prometheus.io/port>": "8008"
Lars-Kristian Svenøy
04/26/2022, 2:29 PMAli Atıl
04/27/2022, 7:23 AMRohit Sivakumar
04/27/2022, 1:55 PM_id
a reserved name in Pinot?
Will attach screenshots with both with _id and id as column names in this thread.Pavel Stejskal
04/27/2022, 3:18 PMLars-Kristian Svenøy
04/28/2022, 8:49 AMtroywinter
04/28/2022, 5:20 PM