Can Nodejs application be connected to Pinot? If so what are the packages that can be used in the Nodejs application to connect to pinot?

yes, you can use the rest api to connect to pinot and query. There is also a nodejs client: https://github.com/kffl/pinot-client-node

is this actively maintained?

Cc @Paweł Kuffel