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 2020/06/15 02:00:09 UTC
Apache Pinot Daily Email Digest (2020-06-15)
<h3><u>#general</u></h3><br><strong>@pinot-bot: </strong>@pinot-bot has joined the channel<br><strong>@kharekartik: </strong>Hi
the main website (<https://u17000708.ct.sendgrid.net/ls/click?upn=iSrCRfgZvz-2BV64a3Rv7HYbJ5-2F8W6HMZppb-2FJJxGr0FYhzRIkgn3-2BMszPDqDcTUxU36tI_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTytJcaTnD0QWRsG4GsPPE37wwwjQ-2BNigibMbQHmMrNbZQHyJ-2BIb1q2uGt-2FMTyhT9VORotsTUxsIhN1Na1x47nyku08uVkE-2Batu6-2FrfSt6biOgGuFsGcGv1pjdi-2BcuQc4zf43UM-2B6f7fQwHLU0nNBXH4gN6B8wrhHOHyMJyqymd4Ui-2F-2FkK9Mte36SRHNreFsrek-3D>) still shows 0.3.0 release but I think the latest release is 0.4.0<br><strong>@kharekartik: </strong>can someone update that<br><strong>@fx19880617: </strong>will do<br><strong>@fx19880617: </strong>Updated<br><h3><u>#feat-presto-connector</u></h3><br><strong>@yash.agarwal: </strong>@yash.agarwal has joined the channel<br><strong>@yash.agarwal: </strong>@yash.agarwal has left the channel<br><h3><u>#troubleshooting</u></h3><br><strong>@pradeepgv42: </strong>Got it, I was using nanos and there were some issues. I think we can do with millis<br><strong>@pradeepgv42: </strong>At least for time column<br><strong>@pradeepgv42: </strong>Maybe nice to add to the documentation as just fyi I couldn't find it there<br><strong>@pinot-bot: </strong>@pinot-bot has joined the channel<br><strong>@g.kishore: </strong>Yes, I have seen this confusion multiple times. <br><strong>@pradeepgv42: </strong>I tried using S3 as deep storage, there seems to be some issue with older clients of httpclient and httpcore
See: <https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMYuQwgQIdm4Nmvscg-2BWORgNLCUsBVm6nXYzNDwC9Hp28yusKId-2Fd2BBAH9YQhzYQfQ-3D-3DEL4q_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTytJcaTnD0QWRsG4GsPPE37eakcNNfhIgpL9BIdmNbRPqmyxeR1dwyRzjUm4MX-2F36fH554lo-2FP1N7l8J83NrQRDoqEqLoudx-2ByXGNTPGlioX-2BvaCVSad3o4QTQyy9njWLUMbNaQxMm9qjYT3-2BEr0JUnb5BhQwxiBNqSsCxEbFCveRZ-2BWhf1-2FZkURZNZyXUANtE-3D>
With the below changes, i see segments getting uploaded to S3
``` <dependency>
<groupId>org.apache.httpcomponents</groupId>
<artifactId>httpclient</artifactId>
- <version>4.5.3</version>
+ <version>4.5.9</version>
</dependency>
<dependency>
<groupId>org.apache.httpcomponents</groupId>
<artifactId>httpcore</artifactId>
- <version>4.4.6</version>
+ <version>4.4.9</version>
</dependency>```
<br><h3><u>#pinot-dev</u></h3><br><strong>@snlee: </strong>Please vote for enabling html feature for pinot mailing lists. This is needed for setting up the daily digest mails from slack discussion.<br><strong>@snlee: </strong>I sent out the mail to dev@pinot mailing list<br><h3><u>#presto-pinot-issue-troubleshooting</u></h3><br><strong>@fx19880617: </strong>@veerabhadrasastry.gor could you try out the query like :
```SELECT sum(sales_amount), sum(sales_units), approx_distinct(trans_sales_key), approx_distinct(unq_member_id) , psa_name FROM ml_txn_sales_staging WHERE psa_name = 'Non-Alcoholic Beverages' AND country_code = 'US' AND sales_date >= '2019-05-27' AND sales_date <= '2019-06-26' group by psa_name```
<br><strong>@fx19880617: </strong>it will give approximation for unique count<br>