Tanmay Movva
03/22/2021, 2:46 AM{
"event_name": "abcd",
"event_type": "",
"version": "v1",
"write_key": "",
"properties": {
"status_code": "some_code",
"status": "some_status",
"mode": "some_mode"
},
"event_timestamp": 1616157914,
"mode": "live"
}
And my schema looks like this
"mode": "string",
"request_failure": "INT"
troywinter
03/22/2021, 2:47 PMElon
03/22/2021, 10:26 PMCharles
03/23/2021, 7:28 AMMatt
03/24/2021, 12:03 AMTanmay Movva
03/24/2021, 11:48 AMlatest
tag and we observe that few metrics related to query response time have been coming as 0
. We didn’t change any config on pinot or the grafana query, so wanted to know if there was any breaking change merged recently? Here is a screen shot of the dashboard.Charles
03/24/2021, 1:36 PMJosh Highley
03/24/2021, 5:53 PMJosh Highley
03/24/2021, 8:34 PMMohamed Sultan
03/25/2021, 7:27 AMCharles
03/25/2021, 8:21 AMeywek
03/25/2021, 10:36 AMjava.lang.NullPointerException
:
Mar 25 09:50:52 pinot-hosts-3 bash[11610]: 2021/03/25 09:50:52.405 ERROR [LLRealtimeSegmentDataManager_datasource_605b02ec0eb00003003bfc41__0__18__20210325T0855Z] [datasource_605b02ec0eb00003003bfc41__0__18__20210325T0855Z] Exception while in work
Mar 25 09:50:52 pinot-hosts-3 bash[11610]: java.lang.NullPointerException: null
Mar 25 09:50:52 pinot-hosts-3 bash[11610]: at org.apache.pinot.core.data.manager.realtime.SegmentBuildTimeLeaseExtender.addSegment(SegmentBuildTimeLeaseExtender.java:100) ~[pinot-all-0.7.0-jar-with-dependencies.jar:0.7.0-695ca390a8080409b3b76f250f2315b81b86b362]
Mar 25 09:50:52 pinot-hosts-3 bash[11610]: at org.apache.pinot.core.data.manager.realtime.LLRealtimeSegmentDataManager.buildSegmentForCommit(LLRealtimeSegmentDataManager.java:698) ~[pinot-all-0.7.0-jar-with-dependencies.jar:0.7.0-695ca390a8080409b3b76f250f2315b81b86b362]
Mar 25 09:50:52 pinot-hosts-3 bash[11610]: at org.apache.pinot.core.data.manager.realtime.LLRealtimeSegmentDataManager$PartitionConsumer.run(LLRealtimeSegmentDataManager.java:610) [pinot-all-0.7.0-jar-with-dependencies.jar:0.7.0-695ca390a8080409b3b76f250f2315b81b86b362]
Mar 25 09:50:52 pinot-hosts-3 bash[11610]: at java.lang.Thread.run(Thread.java:748) [?:1.8.0_275]
Do you have any idea on why this is happening? Thank youLaxman Ch
03/25/2021, 3:57 PMHarold Lim
03/25/2021, 8:55 PMCharles
03/26/2021, 3:26 AMMohamed Sultan
03/29/2021, 10:32 AMMayank
webConferenceId
?Charles
03/31/2021, 12:31 AMElon
03/31/2021, 4:53 AMselect foo from table
where
and case bar when 1,2,3 then 4 when 4,5,6 then 5 when 7 then 6 when 8 then 7 else 17 end = 6
limit 10
khush
03/31/2021, 5:39 AMRavikumar Maddi
03/31/2021, 2:17 PMselect exp from my_table WHERE JSON_MATCH(colunm1, 'att1=''Lab''')
But I am getting error
[
{
"errorCode": 200,
"message": "QueryExecutionError:\njava.lang.IllegalStateException: Cannot apply JSON_MATCH on column: column1 without json index\n\tat shaded.com.google.common.base.Preconditions.checkState(Preconditions.java:518)\n\tat org.apache.pinot.core.plan.FilterPlanNode.constructPhysicalOperator(FilterPlanNode.java:206)\n\tat org.apache.pinot.core.plan.FilterPlanNode.run(FilterPlanNode.java:80)\n\tat org.apache.pinot.core.plan.DocIdSetPlanNode.run(DocIdSetPlanNode.java:41)\n\tat org.apache.pinot.core.plan.ProjectionPlanNode.run(ProjectionPlanNode.java:52)\n\tat org.apache.pinot.core.plan.TransformPlanNode.run(TransformPlanNode.java:52)\n\tat org.apache.pinot.core.plan.SelectionPlanNode.run(SelectionPlanNode.java:83)\n\tat org.apache.pinot.core.plan.CombinePlanNode.run(CombinePlanNode.java:100)\n\tat org.apache.pinot.core.plan.InstanceResponsePlanNode.run(InstanceResponsePlanNode.java:33)\n\tat org.apache.pinot.core.plan.GlobalPlanImplV0.execute(GlobalPlanImplV0.java:45)\n\tat org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:294)\n\tat org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:215)\n\tat org.apache.pinot.core.query.executor.QueryExecutor.processQuery(QueryExecutor.java:60)\n\tat org.apache.pinot.core.query.scheduler.QueryScheduler.processQueryAndSerialize(QueryScheduler.java:157)"
}
]
My Table config appears like this:
.
.
"tableIndexConfig": {
"loadMode": "MMAP",
},
"jsonIndexColumns": [
"colunm1",
"column2",
"column3"
],
"metadata": {
"customConfigs": {}
}
}
I fallowed quick start project, there, it declared like below way, and I tried that to but this time not even see data in my table in query console,
.
.
"tableIndexConfig": {
"loadMode": "MMAP",
"jsonIndexColumns": [
"colunm1",
"column2",
"column3"
]
},
"metadata": {
"customConfigs": {}
}
}
Schema:
.
.
.
"dimensionFieldSpecs": [
{
"name": "colunm1",
"dataType": "STRING",
"maxLength": 2147483647
},
{
"name": "colunm2",
"dataType": "STRING",
"maxLength": 2147483647
},
{
"name": "colunm3",
"dataType": "STRING",
"maxLength": 2147483647
},
.
.
.
Need your help please 😇😇Kishore G
Alexander Vivas
03/31/2021, 2:28 PMJonathan Meyer
03/31/2021, 3:30 PMElon
03/31/2021, 7:04 PMJonathan Meyer
04/01/2021, 2:43 PM/opt/pinot/conf/pinot-controller-log4j2.xml
for logging configuration ? (without override from JAVA_OPTS)
Thanks !Ravikumar Maddi
04/01/2021, 3:19 PMKen Krugler
04/02/2021, 6:15 PMCan't load plugin: sqlalchemy.dialects:http
, which makes me think my install is borked. And yes, I know Docker is the preferred solution here 🙂Lakshmanan Velusamy
04/05/2021, 11:01 PMMatt
04/09/2021, 4:45 AM