Hello everyone, Did anybody try histogram functio...
# getting-started
m
Hello everyone, Did anybody try histogram function?
SELECT HISTOGRAM(value, 0, 200, 10) as hist from metrics
I am getting following error - “message”: “QueryExecutionError\norg.apache.pinot.spi.exception.BadQueryRequestException Unsupported function: histogram not found I installed pinot using helm on k8s.
r
^
value
needs to be escaped
m
Here is the full error message -
Copy code
{
  "message": "QueryExecutionError:\norg.apache.pinot.spi.exception.BadQueryRequestException: Unsupported function: histogram not found\n\tat org.apache.pinot.core.operator.transform.function.TransformFunctionFactory.get(TransformFunctionFactory.java:241)\n\tat org.apache.pinot.core.operator.transform.TransformOperator.<init>(TransformOperator.java:67)\n\tat org.apache.pinot.core.plan.TransformPlanNode.run(TransformPlanNode.java:71)\n\tat org.apache.pinot.core.plan.SelectionPlanNode.run(SelectionPlanNode.java:58)",
  "errorCode": 200
}
SELECT HISTOGRAM(“value”, 0, 200, 10) as hist from metrics
What am I missing?
r
it should work. I just tried with the quickstart on latest master.
which version of pinot are you using?
m
Copy code
0.10.0
helm3 repo add pinot https://raw.githubusercontent.com/apache/pinot/master/kubernetes/helm helm chart - APP version - 0.2.5
r
can you try latest?
m
This is the latest chart. helm3 search repo pinot -l NAME CHART VERSION APP VERSION DESCRIPTION pinot/pinot 0.2.5 0.2.5 Apache Pinot is a realtime distributed OLAP dat...
r
i meant using the latest pinot image
not from 0.10.0
m
Finally it worked..
👍 1
I uninstalled the helm chart and reinstalled with the helm parameter “--set image.tag=latest”
Thank you Rong
👍 1
image.png
helm3 install pinot pinot/pinot \ -n pinot-quickstart \ --set cluster.name=pinot \ --set server.replicaCount=2 \ --set image.pullPolicy=Always \ --set image.tag=latest