<h3><u>#general</u></h3><br><strong>@yash.agarwal: </strong>I am querying a table in Pinot Query Console with id = 21400000008726127. the response it returns is id = 21400000008726130. The same if I do through broker, it is working fine.<br><strong>@g.kishore: </strong>Can you check the broker log, when you run the query via query console?<br><strong>@tmmwangioo3: </strong>Hello, does Pinot support pagination when Group By is specified? These two queries give me the same results For the second one the pagination is ignored.
```select foo_name, AVG(foo_age) from fooTable group by foo_name order by foo_name DESC limit 5 select foo_name, AVG(foo_age) from fooTable group by foo_name order by foo_name DESC limit 5,5``` Pagination works for simple selection without a group by. These 2 queries give me different results and the merged results are the same as doing a similar query with no pagination and a limit of 10. ```select foo_name, foo_age from fooTable order by foo_name DESC limit 5 select foo_name, foo_age from fooTable order by foo_name DESC limit 5,5```<br><strong>@mayanks: </strong>Pagination is currently not supported with group by<br><strong>@tmmwangioo3: </strong>Ok. Thanks for confirming<br><strong>@npawar: </strong>Hey folks! Thanks for the great response on the Pinot videos we’ve released so far. We’re thinking about the next set of topics for videos, and would love your suggestions. Please vote for topics you’d be interested in watching, or add suggestions of your own. Thanks! <https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMdAsVU7EGhC4DQsGxxQQeZ9wLFPwBx6gmX7X-2FjTb5oF9CzK7_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTxY7xE4twza17gAM-2BG-2Fi-2FYrh0NlgUYo5thW-2FmsStUg1OTKQievp-2BG5URZT9qaormVllyIXBrCbYG0K-2BRowrTQSJIny89zjmqSFw4vwo9wa9rLtXIP9NBgBAXSZiMZGlASMtcN9NVVfqs4hkTetFzpwE4IxswO0AANRFCHeTlIi2D0Qd9yLTSExNUnk81y2juq8-3D><br><h3><u>#feat-presto-connector</u></h3><br><strong>@bhavikkumar.ambani: </strong>@bhavikkumar.ambani has joined the channel<br><h3><u>#pql-2-calcite</u></h3><br><strong>@bhavikkumar.ambani: </strong>@bhavikkumar.ambani has joined the channel<br><h3><u>#troubleshooting</u></h3><br><strong>@bhavikkumar.ambani: </strong>@bhavikkumar.ambani has joined the channel<br><strong>@elon.azoulay: </strong>FYI, when we start up the controller we notice about 385k worth of exceptions from Reflections.setScan in BeanConfig. Are these just because the classes are not in the class path? (i.e. we don't use all the plugins):<br><strong>@elon.azoulay: </strong>```org.reflections.ReflectionsException: could not get type for name org.osgi.framework.BundleListener at org.reflections.ReflectionUtils.forName(ReflectionUtils.java:390) ~[pinot-all-0.4.0-SNAPSHOT-jar-with-dependencies.jar:0.4.0-SNAPSHOT-9e7da0349baa23dd02987a3142818dbc6a144fbe] at org.reflections.Reflections.expandSuperTypes(Reflections.java:381) ~[pinot-all-0.4.0-SNAPSHOT-jar-with-dependencies.jar:0.4.0-SNAPSHOT-9e7da0349baa23dd02987a3142818dbc6a144fbe] at org.reflections.Reflections.<init>(Reflections.java:126) ~[pinot-all-0.4.0-SNAPSHOT-jar-with-dependencies.jar:0.4.0-SNAPSHOT-9e7da0349baa23dd02987a3142818dbc6a144fbe] at io.swagger.jaxrs.config.BeanConfig.classes(BeanConfig.java:276) ~[pinot-all-0.4.0-SNAPSHOT-jar-with-dependencies.jar:0.4.0-SNAPSHOT-9e7da0349baa23dd02987a3142818dbc6a144fbe] at io.swagger.jaxrs.config.BeanConfig.scanAndRead(BeanConfig.java:240) ~[pinot-all-0.4.0-SNAPSHOT-jar-with-dependencies.jar:0.4.0-SNAPSHOT-9e7da0349baa23dd02987a3142818dbc6a144fbe] at io.swagger.jaxrs.config.BeanConfig.setScan(BeanConfig.java:221) ~[pinot-all-0.4.0-SNAPSHOT-jar-with-dependencies.jar:0.4.0-SNAPSHOT-9e7da0349baa23dd02987a3142818dbc6a144fbe] at org.apache.pinot.controller.api.ControllerAdminApiApplication.setupSwagger(ControllerAdminApiApplication.java:126) ~[pinot-all-0.4.0-SNAPSHOT-jar-with-dependencies.jar:0.4.0-SNAPSHOT-9e7da0349baa23dd02987a3142818dbc6a144fbe] at org.apache.pinot.controller.api.ControllerAdminApiApplication.start(ControllerAdminApiApplication.java:87) ~[pinot-all-0.4.0-SNAPSHOT-jar-with-dependencies.jar:0.4.0-SNAPSHOT-9e7da0349baa23dd02987a3142818dbc6a144fbe] ```<br><strong>@elon.azoulay: </strong>Are these acceptable or does this indicate some misconfiguration or other issue?<br><strong>@fx19880617: </strong>I’m also seeing those swagger related exceptions, they raises when the first time you hit controller ui<br><h3><u>#pinot-dev</u></h3><br><strong>@sosyalmedya.oguzhan: </strong>Hi everyone, <https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMSfW2QiSG4bkQpnpkSL7FiK3MHb8libOHmhAW89nP5XKGXCeN9ByDQBr9lB9eSmY9Q-3D-3D1LYC_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTxY7xE4twza17gAM-2BG-2Fi-2FYruRpGUnoSbTg0J5hNH-2BHort7jn-2FNxJGCojCDg-2FYlWx3opXIYTAQ9uibxNw-2BKSAh21Dza4Szaj9HuEsUfvSR-2F0xJW-2FBYh65yzchCsx5oMSgXQuFLZt-2B1T9SRcwINIcbDW4l89Gk8few1VtN90bwzSRIbvMhPTgYACx3GcxsvGrioo-3D> UnitTests - OracleJDK8 and IntegrationTests - OracleJDK8 in travis are failed due to scalatest maven plugin. it says some tests are failed, but all tests working as expected in local env when i build it. What can be problem? local maven version 3.6.1<br><h3><u>#pinot-docs</u></h3><br><strong>@kharekartik: </strong>@kharekartik has joined the channel<br><strong>@fx19880617: </strong>@fx19880617 has joined the channel<br><strong>@g.kishore: </strong>@g.kishore has joined the channel<br><strong>@kharekartik: </strong>Hi, I have added a lot of properties in the configuration reference along with their defaults. But I need some context to write descriptions for those properties for general public. This channel will serve as a knowledge sharing base for this as well as future changes in the docs<br><strong>@kharekartik: </strong>You can see all the newly added properties here <https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMdTeAXadp8BL3QinSdRtJdp60AJx08J5D0h7qkwrxysZi1MZSkbl4JFUtJ8U-2FoWTVgoCFqcP56mjeZC9WiZvM7c-3DShOu_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTxY7xE4twza17gAM-2BG-2Fi-2FYrwjbtlQkaBgxxTE9W-2B4gj66-2FBPE6LPOVMgCYzWb-2FsDahhmYq23WV2KqXujp6oBUGZsbPloZDLWCpK0NsWkCxVxYP2xkcr8BgZqKTn1J7hfvBqSZa8hrijja43rKHBXGAoNhZwTejC-2Fzb48Ja-2Bvm3KuBap23mzDb95b6xH45ywdPc-3D> <https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMdTeAXadp8BL3QinSdRtJdp60AJx08J5D0h7qkwrxysZ9HoeYMvqwNg0Ruekl7GXWt3W-2FZIOHPR0DQRlVGHAHAg-3DAZUt_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTxY7xE4twza17gAM-2BG-2Fi-2FYr-2Br3OK1-2BFwpk5l5tnGYj5E5H0DuyFvYKQzXedkwl2p3BSQsqfaomWgJRToDJbpC5N9xDkjhCS1VEleAw-2FVIdXAAPiG0-2BWXzDc-2FXLC9TNi1Wh2VzJrZ9XVXgoJG-2FykLvbUUOgFOnLLa6K5Hz6J8EuQyojql2LlAOxk-2FLmsrTHwYGk-3D> <https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMdTeAXadp8BL3QinSdRtJdp60AJx08J5D0h7qkwrxysZucSma-2FCJEuYTtSasVHSlu3BV7wymQPbmxUsk7N5Fl8Q-3DrY1k_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTxY7xE4twza17gAM-2BG-2Fi-2FYrQpgk-2B9LtgtUu7ImAZAwdCJUhbq0QNQZ-2FKbDidyk-2BZKIBWOrK-2Bv9PcGxaMLpKamY-2BTNap7zQuS9K3njtf4K9-2FKnX-2B5OyTLDaSrVWXXwSHDFeJvnUg13Y6Db-2Fe-2Fc71i17V0ngYVeShDp0uYB7G3fwAHomNHulpihhi8IUna0QlXrE-3D><br><strong>@jackie.jxt: </strong>@jackie.jxt has joined the channel<br><h3><u>#pinot-0-5-0-release</u></h3><br><strong>@tingchen: </strong>The mvn test passed in the Mac OS env. The tests on an older Ubuntu setup (running in a VM) had a few test failures.<br><strong>@tingchen: </strong>@hbwang89 @fx19880617 which env did you use to run the mvn test?<br><strong>@fx19880617: </strong>linux<br><strong>@fx19880617: </strong>I used to ran it on a ubuntu box<br><strong>@hbwang89: </strong>I used Xiang's box :grinning:. Tests kept failing on my mac<br><strong>@tingchen: </strong>Thanks. The test ran on Mac OS is much faster also (finished within 1.5hr). Let me take a look at the Ubuntu box failures too. But overall I trust the latest MacOS results more than my 2-3 yo ubuntu running on a VM.<br><strong>@fx19880617: </strong>I feel maybe we can launch a box in Aws/Azure for release?<br>
