Am I missing any configuration step?

@Xiang Fu Any plan for this : https://github.com/apache/pinot/issues/8783 - This is something we require too.

I've created a GH issue proposing to create a developer documentation page. Please take a look and add your feedback!

Hi I have added a proposal for existing GH issue: Database Support in Pinot UI. Please take a look and let me know of your feedbacks.

I build pinot from source with command: mvn verify -Ppinot-fastdev -DskipTests I expect script(pinot-admin.sh) for launching zk, kafka, controller,broker etc to be created, like in pinot-distribution module, but I dont see any.

Hello, I have a PR for

Controller AccessControl interface accepts Request parameter

up for review now, appreciate any feedback on the same! Thanks!

Hi, does anyone know of ways to dynamically construct SQL queries for Pinot? Our data is spread across multiple tables, and we're looking for an efficient way to query it. Thanks!

I could test entire write flow with SegmentGenerationMinionClusterIntegrationTest. Is there similar test for read flow?

Without checking, does

JSON_MATCH(json, '"$.array[*]" != ''a''')

return true or false if the array is

["a","b","c"]

?

Hi devs, I have PR to support the S3A connector up for review. Appreciate any reviews. Thanks

On Creating an Apache Release, there's a step to run

mvn clean test

after the release branch is cut. Is this step still valid? On my end (using the master branch) I see that maven skips all of the tests because “clean tests” is an unknown lifecycle.

Hi, I send a SELECT query from query console to debug the flow. I see BaseBrokerRequestHandler.handleRequest being hit, which is supposed to send back BrokerResponse. But for entire flow, I see number of records in BrokerResponse instance as 0, but still on console I see records as part of response. Where exactly result set gets populated then?

Hi , does anyone known about preServeQueries interface in BaseServerStarter, we were exploring a pagecache warmup solution on server restart. Was wondering if this interface was meant to be used for something like this

Hi Team , There was a minor issue we were facing while adding a new table via UI : https://github.com/apache/pinot/pull/14663 One of the UI engineer from Our team has raised the fix , can you please check

FYI, Pinot-1.3 Release soon.

Reminder, tomorrow EOD, I will cut the 1.3.0 version release candidate. Slack Conversation

FYI.

FYI

Hi All, We are exploring Pinot. And have few questions, hope this is a right group to put across if not kindly let me know the right group. ( Question ). Can pinot work with deep storage, we are looking for inverted index and columnar which pretty much solved in pinot servers itself. Should we need deep storage? like hdfs? (Answer we find in ) https://docs.pinot.apache.org/release-0.4.0/developers/tutorials/store-data . Yes you need hdfs or s3 to have persistence. (Overall Question is ) : Does it mean one need hdfs or s3 for persistent storage and you can't make pinot server itself as a persistent layer as incase of ALL pinot server shutdown and started, data will be gone?

Hi Team , Is anyone working on this : https://docs.pinot.apache.org/developers/advanced/ingestion-level-transformations#one-record-into-many This is a good to have native support feature. @Jackie @Mayank

@Anand Kr Shaw I think https://docs.pinot.apache.org/basics/data-import/pinot-input-formats/complex-type was introduced for this

Hi everyone! There is connectivity issue with ZooKeeper in the latest release of Java client lib (1.2.0) , and causes any call to

ConnectionFactory.fromZookeeper(zkServers)

to block forever. Apparently, the issue is due to the latest version of zkClient library (0.11). I tested older version of Pinot client (0.9.3) relying on previous versions of zkClient (0.7) and everything worked fine. I have also opened an issue on GH https://github.com/apache/pinot/issues/15074 . A couple of workaround comes to my mind and I wanted to know your perspective on this and how we can tackle it. First, this repo https://github.com/sgroschupf/zkclient seems abandoned and we may not expect any fix for this issue from their side. We have the option to use the implementation provided by Apache Helix - zkClient . Second, we can remove the dependency to this lib and write a compatible wrapper using latest official zookeeper client.

Hi , I get this error when running pinot on local (Mac OS)

2025/02/25 10:55:02.231 ERROR [PinotQueryResource] [grizzly-http-server-13] Caught exception while processing post request
java.net.ConnectException: Operation timed out
	at java.base/sun.nio.ch.Net.connect0(Native Method) ~[?:?]
	at java.base/sun.nio.ch.Net.connect(Net.java:579) ~[?:?]
	at java.base/sun.nio.ch.Net.connect(Net.java:568) ~[?:?]
	at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:576) ~[?:?]
	at java.base/java.net.Socket.connect(Socket.java:666) ~[?:?]
	at java.base/java.net.Socket.connect(Socket.java:600) ~[?:?]
	at java.base/sun.net.NetworkClient.doConnect(NetworkClient.java:183) ~[?:?]

2025/02/25 10:55:02.230 ERROR [PinotQueryResource] [grizzly-http-server-13] Caught exception in sendQueryRaw
java.net.ConnectException: Operation timed out
	at java.base/sun.nio.ch.Net.connect0(Native Method) ~[?:?]
	at java.base/sun.nio.ch.Net.connect(Net.java:579) ~[?:?]

There are no errors in the server logs. Can you provide any pointers to unblock from this? Thanks

Hey all! FYI, we’re launching a Pinot OSS YouTube channel soon! 📺 Before we go live, we want to gather all the must-have Pinot videos ; tutorials, meetup recordings, use cases, or anything valuable for the community. Got a video in mind? Maybe one that helped you understand Pinot better? pls drop it in this thread or share it on #C08GH2MAVT4! Thank you ❤️

Hey there 👋 I'd appreciate a PR review 🙏 https://github.com/apache/pinot/pull/15015 It's done for this issue The PR expands

/ingestFromURI

endpoint, which is not meant for production, and the PR includes tests

Hi, anyone looking for a helping hand on issue they are working upon...coding, unit tests etc? I have bandwidth for few days.

Here's the list of currently-open "beginner-task" marked Github issues. Consider starting here, and if you have more time, there's meatier work ahead for sure! https://github.com/apache/pinot/labels/beginner-task

Here's also a bunch of "help-wanted" tasks, if you want to roll your sleeves up: https://github.com/apache/pinot/issues?q=is%3Aopen+label%3A%22help+wanted%22

https://apache-pinot.slack.com/archives/C011C9JHN7R/p1741911243212059 cross-posting for visibility 😆