#general@mayanks: Hello Pinot community,
we at LinkedIn, are planning to host a Virtual Meetup for Apache Pinot on Aug
27. We would like to have one presenter from the community share their
success-story/journey/etc with Pinot. Please reply to this thread if you would
be interested in speaking, with a brief on what you would like to talk
about.@christian: @christian has joined the
channel@qiaochu: @qiaochu has joined the
channel#random@christian: @christian
has joined the channel@qiaochu: @qiaochu has joined the
channel#feat-text-search@christian:
@christian has joined the
channel#troubleshooting@sosyalmedya.oguzhan:
can someone help me about maven enforcer rules?
:disappointed:@yash.agarwal: I am getting the following
exception when querying the controller with a specific sql query.
```Caught exception while sending query request
java.io.IOException: Failed : HTTP error code : 500
at
org.apache.pinot.controller.api.resources.PinotQueryResource.sendPostRaw(PinotQueryResource.java:284)
~[pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-0fc081157c88734af0433c3cd30f310474d177f0]
at
org.apache.pinot.controller.api.resources.PinotQueryResource.sendRequestRaw(PinotQueryResource.java:322)
~[pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-0fc081157c88734af0433c3cd30f310474d177f0]
at
org.apache.pinot.controller.api.resources.PinotQueryResource.getQueryResponse(PinotQueryResource.java:204)
~[pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-0fc081157c88734af0433c3cd30f310474d177f0]
at
org.apache.pinot.controller.api.resources.PinotQueryResource.handlePostSql(PinotQueryResource.java:131)
~[pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-0fc081157c88734af0433c3cd30f310474d177f0]```
If I directly query the broker I am getting
```html
head
titleGrizzly 2.4.4/title
style
!--div.header
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#003300;font-size:22px;-moz-border-radius-topleft:
10px;border-top-left-radius: 10px;-moz-border-radius-topright:
10px;border-top-right-radius: 10px;padding-left: 5px}div.body
{font-family:Tahoma,Arial,sans-serif;color:black;background-color:#CC;font-size:16px;padding-top:10px;padding-bottom:10px;padding-left:10px}div.footer
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#33;font-size:14px;-moz-border-radius-bottomleft:
10px;border-bottom-left-radius: 10px;-moz-border-radius-bottomright:
10px;border-bottom-right-radius: 10px;padding-left: 5px}BODY
{font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;}B
{font-family:Tahoma,Arial,sans-serif;color:black;}A {color : black;}HR {color :
#66;}
--
/style
/head
body
div class="header"Request failed./div
div class="body"Request failed./div
div class="footer"Grizzly 2.4.4/div
/body
/html```
I have recently added a config in broker
```pinot.broker.timeoutMs=12```
Any Ideas ?@yash.agarwal: There are no logs in broker.
Other queries are working fine, this query would scan 1.7 Bil recods and do a
sum of 3 metrics and distinctcount of 1 dimension@yash.agarwal:
It might be because of high memory usage on broker. as i am seeing
usage spikes upto 60 - 80 %@mayanks: Yes, distinctcount on
1.7B records may the likely issue. Have you considered using HLL based
approximate distinctcount?@yash.agarwal: We have tried HLL
in the past. We are not looking for approximations.@yash.agarwal:
Also seems like that is the problem, I tried without the distinctcount
and it is returning successfully in 2 secs.@mailtobuchi:
@mailtobuchi has left the channel@christian:
@christian has joined the
channel#pinot-dev@mayanks: `mvn clean
install -DskipTests -Pbin-dist` takes awfully long time, it seems to have
creeped up quite a bit over the years. Any ideas on how to make the build
faster?@dlavoie: ~ 10 minutes on my own CI server.
```[INFO] Pinot .. SUCCESS [ 22.428
s]
[INFO] Pinot Service Provider Interface ... SUCCESS [ 7.931 s]
[INFO] Pinot Common ... SUCCESS [ 32.668 s]
[INFO] Pinot Plugins .. SUCCESS [ 0.563 s]
[INFO] Pinot Input Format . SUCCESS [ 0.510 s]
[INFO] Pinot Avro Base SUCCESS [ 1.694 s]
[INFO] Pinot Avro . SUCCESS [ 5.284 s]
[INFO] Pinot Csv .. SUCCESS [ 0.844 s]
[INFO] Pinot JSON . SUCCESS [ 0.738 s]
[INFO] Pinot Core . SUCCESS [ 22.112 s]
[INFO] Pinot Server ... SUCCESS [ 9.760 s]
[INFO] Pinot Controller ... SUCCESS [01:25 min]
[INFO]