#general
@ciano4fr: @ciano4fr has joined the channel
@francis.west: @francis.west has joined the channel
@ankit.itassociate: @ankit.itassociate has joined the channel
@saadkhan: @saadkhan has joined the channel
#random
@ciano4fr: @ciano4fr has joined the channel
@francis.west: @francis.west has joined the channel
@ankit.itassociate: @ankit.itassociate has joined the channel
@saadkhan: @saadkhan has joined the channel
#troubleshooting
@yash.agarwal: Does pinot have a default limit? ```select id from table group by id limit 100000000``` only returns 1.1 M rows from API and JDBC client.
@mayanks: Hmm shouldn’t be, I’ll check. Btw what are you trying to do with this query
@yash.agarwal: Not much. Just something we found during some testing. We are querying upto 1M records so we are fine right now.
@yash.agarwal: We wanna have a way in future to increase it if we really want to
@mayanks: Ok, however note that this is not the best use of Pinot. Could you elaborate on what app needs to fetch 1M rows?
@31cswarszawa: Hey, Wanted to ask which Pinot distribution is recommended for production deployments in Kubernetes cluster? Are there any other recommendations for production deployments?
@xiangfu0: you can pick the latest pinot release version, the docker image tag is same as release tag
@31cswarszawa: I’m trying to test with latest (0.8.0) using this tutorial:
@31cswarszawa: Ok, it seems that `JAVA_OPTS` env var is no longer needed in compose file? I deleted it and everything started correctly.
@xiangfu0: ohh
@xiangfu0: yes
@xiangfu0: that’s for jdk8 java_opts
@xiangfu0: pinot is now on jdk11
@xiangfu0: we will update the docs
@xiangfu0: thanks for reporting
@31cswarszawa: No problem, thanks for helping!
@ciano4fr: @ciano4fr has joined the channel
@francis.west: @francis.west has joined the channel
@gqian3: Hi team, for Boolean type of field, what’s the main difference to define it as a Boolean vs string in the schema, in terms of querying the table?
@mayanks: Not much, internally both will be dictionary encoded
@gqian3: Thanks.
@ankit.itassociate: @ankit.itassociate has joined the channel
@saadkhan: @saadkhan has joined the channel
#pinot-s3
@ankit.itassociate: @ankit.itassociate has joined the channel
@ankit.itassociate: Hello guys, Good noon
@g.kishore: hello
@ankit.itassociate: Hi Kishore, Hope you are doing well
@ankit.itassociate: I have recently started using pinot and I was trying to integrate deep storage for historical data, I am able to store and see the data for controller but it doesn’t work for server data
@ankit.itassociate: I have added configurations like class, accessKey, secretKey, endpoint , protocol region and S3PinotFS as the s3, factory classes
@ankit.itassociate: My controller config also has controller.data.dir = s3://<bucket>/path controller.local.temp.dir= local path
@ankit.itassociate: And server has pinot.server.instance.dataDir= local path Pinot.server.instance.segmentTarDir= local path/segment
@ankit.itassociate: Not sure if I have to configure bucket details as well for server
@g.kishore: how are you pushing the segments to pinot
@ankit.itassociate: segments are being pushed via Kafka streaming
#pinot-dev
@ken: Someone with admin rights for
@g.kishore: I dont think we can edit it
@g.kishore: checking with ASF
@ankit.itassociate: @ankit.itassociate has joined the channel
@ankit.itassociate: Hi All, I need some details around pinot S3 integration. Please let me know if this is the right forum to ask my question
@g.kishore: feel free to ask in troubleshooting
--------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org