Apache Pinot Daily Email Digest (2020-06-15)

[Pinot Slack Email Digest]

<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
```       &lt;dependency&gt;
         &lt;groupId&gt;org.apache.httpcomponents&lt;/groupId&gt;
         &lt;artifactId&gt;httpclient&lt;/artifactId&gt;
-        &lt;version&gt;4.5.3&lt;/version&gt;
+        &lt;version&gt;4.5.9&lt;/version&gt;
       &lt;/dependency&gt;
       &lt;dependency&gt;
         &lt;groupId&gt;org.apache.httpcomponents&lt;/groupId&gt;
         &lt;artifactId&gt;httpcore&lt;/artifactId&gt;
-        &lt;version&gt;4.4.6&lt;/version&gt;
+        &lt;version&gt;4.4.9&lt;/version&gt;
       &lt;/dependency&gt;```
<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 &gt;= '2019-05-27' AND sales_date &lt;= 
'2019-06-26' group by psa_name```
<br><strong>@fx19880617: </strong>it will give approximation for unique 
count<br>