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