<h3><u>#general</u></h3><br><strong>@adrian.f.cole: </strong>does anyone have any hints to help me do this faster? I want to use local objects to configure schema instead of ReST api as done in AddTable command <https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMSfW2QiSG4bkQpnpkSL7FiK3MHb8libOHmhAW89nP5XKS-2Fs4lZLnvn4tbpjiBjZNAg-3D-3DFwD7_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTzKttKWW4DFFZWksUhJ0Fc-2BfMI3cK-2FSeQi3j3rz83DgIVYQTeL14G6btByyM0CIWhRS6q0iRXH4Y4UY60q8aKsbf2st0NvL2rC4IqtBWUsfhW5bejqui6gPMenSIAtnx8PYgxkC-2B4UPH6p9CJYURjgKp363bVVh7w-2BZaiwpdAt11lK0-2BkTVBRxhUTZBkL8ko0g-3D><br><strong>@oliver.bauer: </strong>Dear all, thank you very much for building Apache Pinot - it is indeed a great tool! One question that came up during our evaluation of Pinot is *how to handle year over year (or period over period) comparisons* in Pinot (or in the Viz Tooling). How would you typically do this? In SQL, one normally would either use WINDOW functions (like LAG with PARTITION OVER) oder self-JOINS. Any advice is highly appreciated :slightly_smiling_face: THANKS!<br><strong>@npawar: </strong>Yet another amazing blog written by @kennybastani, this time using Pinot and Superset to visualize climate change: <https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMa1aAdGoOdRoyIvGAevnwx4MmluqK5BbqVUbYmCA2ouJFVlSaJlYxHG2kpQbJ6AR111fa7B8UpR7VpoVqqAGC3WYpPsQraMOi33q0iDGlZPDdMp4Rz443N-2B7p6XGBxyNzywycVqkvsZDEmDlt9cVzhiGeDVEbCpSccZBdZWpuumLLSoJ_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTzKttKWW4DFFZWksUhJ0Fc-2BYBx7PV0rGO6fD-2B1EjW25H1CtNu4pmEPWW9LHgCCmurML6AJ3pyqBozLpxShyUQhD8QGVL9hJRs6p4CqS5E-2BUuFUVhR0t5BzxUdFO5QB3U06JWIWuefnrpZU0ACDHcDzUx-2BZd3UWyW-2F9AuuK4F0Y-2FO9Gj-2Fp4XNQAdap9BlQlv8n4-3D><br><strong>@npawar: </strong>Please share it in your networks :slightly_smiling_face: :wine_glass:<br><strong>@lakshmi_monster: </strong>@lakshmi_monster has joined the channel<br><h3><u>#random</u></h3><br><strong>@highering.ai: </strong>1. Robustness of query 2. Built-in optimization 3. On-the-fly elasticity 4. Dynamic Environment Adaption 5. Separation of compute from storage 6. Support for diverse data
How can one assess these characteristics?<br><strong>@lakshmi_monster: </strong>@lakshmi_monster has joined the channel<br><h3><u>#troubleshooting</u></h3><br><strong>@ankit.raj.singh: </strong>Can anyone tell me how to see pinot server metrics(either via some api or jmx) and how to set lead controller for retention job?<br><h3><u>#jdbc-connector</u></h3><br><strong>@kharekartik: </strong>The External view stores broker per table and not per tenant so for tenant based it will still be inefficient<br><strong>@kharekartik: </strong>right now we get configs for all the instances filter out the tenants from the tag list which end in 'BROKER' filter out the instances which end with the tenant<br><strong>@kharekartik: </strong>This flow doesn't occur in External view as far as I can see<br><strong>@fx19880617: </strong>I feel we can maintain a tenant to table mapping?<br><strong>@g.kishore: </strong>we need to listen to both instance config and external view<br><strong>@g.kishore: </strong>this is similar to routing table<br><h3><u>#lp-pinot-poc</u></h3><br><strong>@fx19880617: </strong>This is another test running: with 50k incoming msgs and query qps around 1.8k<br><strong>@fx19880617: </strong><br><strong>@andrew: </strong>@fx19880617 thanks. what percentiles are the green, yellow, and blue lines?<br><strong>@fx19880617: </strong>blue is p999, yellow is p99, green is p50<br><strong>@fx19880617: </strong>this is the server jvm opts: `-Xms16G -Xmx16G -XX:+UseG1GC -XX:MaxGCPauseMillis=200 -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCApplicationConcurrentTime -Xloggc:/opt/pinot/gc-pinot-server.log`<br>
