You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pinot.apache.org by Pinot Slack Email Digest <sn...@apache.org> on 2021/02/23 02:00:18 UTC
Apache Pinot Daily Email Digest (2021-02-22)
### _#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: dev-unsubscribe@pinot.apache.org For additional commands,
e-mail: dev-help@pinot.apache.org