#general
@saurabh.dwivedy: @saurabh.dwivedy has joined the channel
@abdelwahab.touil: @abdelwahab.touil has joined the channel
@contact: Hey, question question: Is there any target date / milestone for the 0.7.0 release ? Thanks
@g.kishore: We are starting on the release this week. First week of March tentative eta
@contact: thanks for the answer :slightly_smiling_face:
@ana: @ana has joined the channel
@rakovilya: @rakovilya has joined the channel
@shayl: @shayl has joined the channel
@harshal: @harshal has joined the channel
@xiangyu.peng: Hi, I’m trying to build a query for data within 7 days, but pinot is throwing error for `DATETRUNC('hour', second(now()), 'SECONDS')`, is this expected?
@xiangyu.peng: This is the error message:
@xiangyu.peng: ``` { "message": "QueryExecutionError:\norg.apache.pinot.core.query.exception.BadQueryRequestException: Caught exception while initializing transform function: datetrunc\n\tat org.apache.pinot.core.operator.transform.function.TransformFunctionFactory.get(TransformFunctionFactory.java:206)\n\tat org.apache.pinot.core.operator.transform.function.TransformFunctionFactory.get(TransformFunctionFactory.java:201)\n\tat org.apache.pinot.core.operator.transform.function.TransformFunctionFactory.get(TransformFunctionFactory.java:201)\n\tat org.apache.pinot.core.operator.filter.ExpressionFilterOperator.<init>(ExpressionFilterOperator.java:56)\n\tat org.apache.pinot.core.plan.FilterPlanNode.constructPhysicalOperator(FilterPlanNode.java:125)\n\tat org.apache.pinot.core.plan.FilterPlanNode.run(FilterPlanNode.java:69)\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$1.callJob(CombinePlanNode.java:127)\n\tat org.apache.pinot.core.plan.CombinePlanNode$1.callJob(CombinePlanNode.java:113)\n\tat org.apache.pinot.core.util.trace.TraceCallable.call(TraceCallable.java:44)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)", "errorCode": 200 },```
@xiangyu.peng: if i replace now() with a timestamp column, the same query works
@karinwolok1: :tada: We officially passed 1K slack members!!! :tada: :partying_face: :wave: Welcome to the newbie Pinot community members who brought us over the edge! :wine_glass: Would love to know what brought you here and what you're working on. :smiley: @ana @rakovilya @lqxshay @harshal @gonzalesteb @accounts_slack @harbingeryellow @nick.saggese @jhmarques3 @e-ramirez @saurabh.dwivedy @abdelwahab.touil @paulwelch @atadesoba @gbahrani @write2agb @ray @jdelmerico @renegomezlondono @demetrius.williams.pm @atadesoba @ricardobordon @jungmwiner @yg.y @nachiket.kate90 @leslie.nyahwa @phillip.fleischer @jai.patel856
#random
@saurabh.dwivedy: @saurabh.dwivedy has joined the channel
@abdelwahab.touil: @abdelwahab.touil has joined the channel
@ana: @ana has joined the channel
@rakovilya: @rakovilya has joined the channel
@shayl: @shayl has joined the channel
@karinwolok1:
@aaron: @aaron has left the channel
@harshal: @harshal has joined the channel
#feat-compound-types
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#feat-text-search
@abdelwahab.touil: @abdelwahab.touil has joined the channel
@ray: @ray has joined the channel
@e-ramirez: @e-ramirez has joined the channel
#feat-rt-seg-complete
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#feat-presto-connector
@abdelwahab.touil: @abdelwahab.touil has joined the channel
@ray: @ray has joined the channel
@e-ramirez: @e-ramirez has joined the channel
#pql-2-calcite
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#feat-upsert
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#group-by-refactor
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#feat-better-schema-evolution
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#sql-rollout-plan
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#troubleshooting
@saurabh.dwivedy: @saurabh.dwivedy has joined the channel
@abdelwahab.touil: @abdelwahab.touil has joined the channel
@ana: @ana has joined the channel
@rakovilya: @rakovilya has joined the channel
@shayl: @shayl has joined the channel
@harshal: @harshal has joined the channel
#pinot-k8s-operator
@khushbu.agarwal: @khushbu.agarwal has joined the channel
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#pinot-dev
@khushbu.agarwal: Hi, the kubernetes helm setup for pinot has a LoadBalancer service created for both broker and controller. I wanted to understand, what should be used, LoadBalancer or clusterIP service for accessing pinot broker and controller by an internal service with the same kubernetes cluster but a different namespace?
@fx19880617: if in same k8s cluster, then you can use internal service name. E.g. `pinot-controller.<pinot-namespace>:9000`
@fx19880617: controller is used for all admin and ops ,broker is used for querying pinot
@abdelwahab.touil: @abdelwahab.touil has joined the channel
@ray: @ray has joined the channel
@e-ramirez: @e-ramirez has joined the channel
#community
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#announcements
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#presto-pinot-streaming
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#pinot-docs
@khushbu.agarwal: @khushbu.agarwal has joined the channel
#presto-pinot-connector
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#time-based-segment-pruner
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#segment-cold-storage
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#pinot-perf-tuning
@abdelwahab.touil: @abdelwahab.touil has joined the channel
#getting-started
@abdelwahab.touil: @abdelwahab.touil has joined the channel
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
