<h3><u>#general</u></h3><br><strong>@kavinsrec33: </strong>@kavinsrec33 has
joined the channel<br><strong>@kavin.kuppusamy: </strong>@kavin.kuppusamy has
joined the channel<br><h3><u>#random</u></h3><br><strong>@kavinsrec33:
</strong>@kavinsrec33 has joined the channel<br><strong>@kavin.kuppusamy:
</strong>@kavin.kuppusamy has joined the
channel<br><h3><u>#troubleshooting</u></h3><br><strong>@pradeepgv42:
</strong>Is there support for SSL connections to Kafka for the KafkaConsumer
used by pinot?
<https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMdTeAXadp8BL3QinSdRtJdo5Vml3IIBLs7JiV3aA7xH6E1xuyunoVEcnqa9dbWn9CJtee9zt1zS2vZW4Bc-2FI7OT2S7h91HyM56Tdn3p1HYrCtW8anj1KBhTvL6z8tNyKrg-3D-3D1Bx5_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTzVTwLItI-2BsDwwZTW9HyEK9O2AwqrLE7sm2kj1PEVPNotQe6OkuJTZoUPb2QyU5jcqH9ElAemhr2p3exNUopsRGJaWZF-2F8jM7-2FqXsZ7fw2jo-2Bs9LbyXF5EgVGPFRljaNILNqtL71niN0-2B54BW4hNsb3OHcil9YOoft75ZJdIFCXLw-3D-3D>
I don’t see option to pass in keystore/truststore etc as part of the
configuration?<br><strong>@kavinsrec33: </strong>@kavinsrec33 has joined the
channel<br><strong>@kavin.kuppusamy: </strong>@kavin.kuppusamy has joined the
channel<br><strong>@pradeepgv42: </strong>awesome
thanks<br><h3><u>#enable-generic-offsets</u></h3><br><strong>@ssubrama:
</strong>@ssubrama has left the
channel<br><h3><u>#pinot-dev</u></h3><br><strong>@ssubrama: </strong>@npawar
will be good to send out an email as well, with a summary of proposed config
changes. With pinot gaining wider adoption in the community and more production
cases, we need to pay attention to our configs and make sure we pick the right
defaults and keep things as simple as possible. The community can help us
here<br><strong>@jackie.jxt: </strong>I've submitted a PR to remove the code
for HAVING clause handling because it is not properly done and the result is
not accurate:
<https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMSfW2QiSG4bkQpnpkSL7FiK3MHb8libOHmhAW89nP5XKeHZoW8VXHXETAL6OLFt2lw-3D-3DoQQh_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTzVTwLItI-2BsDwwZTW9HyEK95z7KZdQIe687YLrIpY6BJzP0NNQ8asiHqE1G5sR5-2F80PHfK3mz9I75QJnqwR-2F8bbO7NAdOWpbdqX0kx6C3sfd8z9LGwRG5SQpwBd7OP4XXMv32J3KlkNo3jM0NPHBQ-2B8PgVA8UOQD-2BjG77FlxUYO8g-3D-3D><br><strong>@jackie.jxt:
</strong>Officially (in the documentation) Pinot does not support HAVING for
now. Will add HAVING clause support after migrating to
SQL<br><strong>@jackie.jxt: </strong>Can someone help review the PR? And please
leave comments if you have concern on removing the support of
HAVING<br><strong>@fx19880617: </strong>I’m trying to move pinot startable to
use config files always:
<https://u17000708.ct.sendgrid.net/ls/click?upn=1BiFF0-2FtVRazUn1cLzaiMSfW2QiSG4bkQpnpkSL7FiK3MHb8libOHmhAW89nP5XKryTRZlFWkpBfqZFu5-2BbiRA-3D-3DTV--_vGLQYiKGfBLXsUt3KGBrxeq6BCTMpPOLROqAvDqBeTzVTwLItI-2BsDwwZTW9HyEK9dkrusbbq-2B84nsWGwYijlw8TZu4LVQrSJ-2F9IvYrKJwGSh9HeEQhp6HSLteAF2NDw0PVmGs5-2BR5VEpHcqIo38v1nX3I78NEEjXML7FQ-2BMd8qe-2BRze4tRPJ7J0RXKFqvq5xz-2F3sTBwT2MSpbcv0TS3Fkw-3D-3D><br><strong>@fx19880617:
</strong>this can better fill the cap between trying out our quickstart and
deploying pinot<br><strong>@dlavoie: </strong>Consistency is awesome! Just a
quick question on the theme around this improvement. Has it been considered to
standardize config management so all the potential properties may be passed
through env var, cli args and property files independently? Most modern java
framework offers configuration abstraction. Apache Commons Configuration
enables that with CompositePropertiesConfiguration but it requires manual setup
and bootstrap.<br><strong>@fx19880617: </strong>The purpose is to let startable
not using the cli args but use config file<br><strong>@fx19880617: </strong>so
it would be better place to enforce the consistency<br><strong>@dlavoie:
</strong>I understand the purpose of the PR, and think is a good improvement.
My question is wether it has been considered to implement an abstraction that
offer the maximum flexibility for operators. Based on the deployment method,
cli args might be the best. In the case of K8s, env var are more likely to be
preferable, and on template engine based deployment, config files are great. I
like to think that pinot should be independent from the configuration
source.<br><strong>@dlavoie: </strong>This question is off topic from the PR,
I’m forecasting ideas for future improvement for maximum flexibility for
operators.<br><strong>@fx19880617: </strong>hmm<br><strong>@fx19880617:
</strong>let me think about it<br><strong>@fx19880617: </strong>ideally there
could be templating configs<br><strong>@fx19880617: </strong>then config
override from cli is supported<br><strong>@fx19880617: </strong>I feel most of
the deployment should be fine with updating the config file and
restart<br><strong>@g.kishore: </strong>@dlavoie we want to standardize the
start/stop of all components<br><strong>@g.kishore: </strong>will create an
issue and share my thoughts<br><strong>@dlavoie: </strong>Config management is
a topic of the hearth, by such it is hard to assume what people prefer. By
experience, what usually finds appeal in a community is choice. The best
configuration mechanism is tied to a context which that cannot be assumed by a
software contributor. Long story short, abstract it from your software and
everyone will be happy. Yaml, json, env var, java system properties,
implementation detail and not much of a deployment constraint.<br>