dbschema-pro commented on issue #14743:
URL: https://github.com/apache/pinot/issues/14743#issuecomment-2579767488
I tried again with no success.
The JDBC URL is: jdbc:pinot://localhost:9000
user admin and no password.
The docker does open the port 9000. Here are the logs and the command:
```
docker run --name apachepinot -p 2123:2123 -p 9000:9000 -p 8099:8099 -p
8000:8000 -p 7050:7050 -p 6000:6000 apachepinot/pinot:latest QuickStart -type
batch
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by
org.codehaus.groovy.reflection.CachedClass
(file:/opt/pinot/lib/pinot-all-1.3.0-SNAPSHOT-jar-with-dependencies.jar) to
method java.lang.Object.finalize()
WARNING: Please consider reporting this to the maintainers of
org.codehaus.groovy.reflection.CachedClass
WARNING: Use --illegal-access=warn to enable warnings of further illegal
reflective access operations
WARNING: All illegal access operations will be denied in a future release
***** Starting Zookeeper, controller, broker, server and minion *****
2025/01/09 10:24:31.268 INFO [QuickstartRunner] [main] Registered PinotFS
for scheme: s3
2025/01/09 10:24:31.276 INFO [StartZookeeperCommand] [main] Executing
command: StartZookeeper -zkPort 2123 -dataDir
/tmp/1736418269393/quickstart/PinotZkDir
2025/01/09 10:24:32.507 ERROR [ZkAsyncCallbacks]
[ZkClient-EventThread-77-localhost:2123] Interrupted waiting for success
java.lang.InterruptedException: null
at java.base/java.lang.Object.wait(Native Method) ~[?:?]
at java.base/java.lang.Object.wait(Object.java:328) ~[?:?]
at
org.apache.helix.zookeeper.zkclient.callback.ZkAsyncCallbacks$DefaultCallback.waitForSuccess(ZkAsyncCallbacks.java:265)
[pinot-all-1.3.0-SNAPSHOT-jar-with-dependencies.jar:1.3.0-SNAPSHOT-9b9606898872105341b5a218c81a61f8d60d76e4]
at
org.apache.helix.zookeeper.zkclient.ZkClient.issueSync(ZkClient.java:1692)
[pinot-all-1.3.0-SNAPSHOT-jar-with-dependencies.jar:1.3.0-SNAPSHOT-9b9606898872105341b5a218c81a61f8d60d76e4]
at
org.apache.helix.zookeeper.zkclient.ZkClient$4.run(ZkClient.java:1718)
[pinot-all-1.3.0-SNAPSHOT-jar-with-dependencies.jar:1.3.0-SNAPSHOT-9b9606898872105341b5a218c81a61f8d60d76e4]
at
org.apache.helix.zookeeper.zkclient.ZkEventThread.run(ZkEventThread.java:97)
[pinot-all-1.3.0-SNAPSHOT-jar-with-dependencies.jar:1.3.0-SNAPSHOT-9b9606898872105341b5a218c81a61f8d60d76e4]
2025/01/09 10:24:34.619 INFO [StartZookeeperCommand] [main] Start zookeeper
at localhost:2123 in thread main
2025/01/09 10:24:34.630 INFO [StartControllerCommand] [main] Executing
command: StartController -clusterName QuickStartCluster -controllerHost null
-controllerPort 9000 -dataDir /tmp/1736418269393/quickstart/PinotControllerDir0
-zkAddress localhost:2123
2025/01/09 10:24:34.644 INFO [StartServiceManagerCommand] [main] Executing
command: StartServiceManager -clusterName QuickStartCluster -zkAddress
localhost:2123 -port -1 -bootstrapServices []
2025/01/09 10:24:34.645 INFO [StartServiceManagerCommand] [main] Starting a
Pinot [SERVICE_MANAGER] at 6.386s since launch
2025/01/09 10:24:34.648 INFO [StartServiceManagerCommand] [main] Started
Pinot [SERVICE_MANAGER] instance [ServiceManager_116f76a7dd2f_-1] at 6.388s
since launch
2025/01/09 10:24:34.648 INFO [StartServiceManagerCommand] [main] Starting a
Pinot [CONTROLLER] at 6.389s since launch
2025/01/09 10:24:38.296 ERROR [DelayedAutoRebalancer]
[HelixController-pipeline-default-QuickStartCluster-(880be604_DEFAULT)] No
instances or active instances available for resource leadControllerResource,
allInstances: [], liveInstances: [], activeInstances: []
2025/01/09 10:24:38.340 ERROR [DelayedAutoRebalancer]
[HelixController-pipeline-default-QuickStartCluster-(b60a8c1d_DEFAULT)] No
instances or active instances available for resource leadControllerResource,
allInstances: [], liveInstances: [], activeInstances: []
2025/01/09 10:24:38.361 ERROR [DelayedAutoRebalancer]
[HelixController-pipeline-default-QuickStartCluster-(87e01465_DEFAULT)] No
instances or active instances available for resource leadControllerResource,
allInstances: [], liveInstances: [], activeInstances: []
2025/01/09 10:24:39.040 ERROR [DelayedAutoRebalancer]
[HelixController-pipeline-default-QuickStartCluster-(1db7ca46_DEFAULT)] No
instances or active instances available for resource leadControllerResource,
allInstances: [], liveInstances: [], activeInstances: []
2025/01/09 10:24:39.162 ERROR [DelayedAutoRebalancer]
[HelixController-pipeline-default-QuickStartCluster-(13bfbe76_DEFAULT)] No
instances or active instances available for resource leadControllerResource,
allInstances: [], liveInstances: [], activeInstances: []
2025/01/09 10:24:39.206 ERROR [DelayedAutoRebalancer]
[HelixController-pipeline-default-QuickStartCluster-(82c8e288_DEFAULT)] No
instances or active instances available for resource leadControllerResource,
allInstances: [], liveInstances: [], activeInstances: []
2025/01/09 10:24:39.240 ERROR [DelayedAutoRebalancer]
[HelixController-pipeline-default-QuickStartCluster-(fc13f663_DEFAULT)] No
instances or active instances available for resource leadControllerResource,
allInstances: [], liveInstances: [], activeInstances: []
2025/01/09 10:24:39.265 ERROR [DelayedAutoRebalancer]
[HelixController-pipeline-default-QuickStartCluster-(d78bd709_DEFAULT)] No
instances or active instances available for resource leadControllerResource,
allInstances: [], liveInstances: [], activeInstances: []
2025/01/09 10:24:39.291 ERROR [DelayedAutoRebalancer]
[HelixController-pipeline-default-QuickStartCluster-(06989a44_DEFAULT)] No
instances or active instances available for resource leadControllerResource,
allInstances: [], liveInstances: [], activeInstances: []
Jan 09, 2025 10:24:46 AM org.glassfish.grizzly.http.server.NetworkListener
start
INFO: Started listener bound to [0.0.0.0:9000]
Jan 09, 2025 10:24:46 AM org.glassfish.grizzly.http.server.HttpServer start
INFO: [HttpServer] Started.
2025/01/09 10:24:52.655 INFO [StartServiceManagerCommand] [main] Started
Pinot [CONTROLLER] instance [Controller_172.17.0.4_9000] at 24.395s since launch
2025/01/09 10:24:52.657 INFO [StartBrokerCommand] [main] Executing command:
StartBroker -brokerHost null -brokerPort 8000 -zkAddress localhost:2123
2025/01/09 10:24:52.658 INFO [StartServiceManagerCommand] [main] Executing
command: StartServiceManager -clusterName QuickStartCluster -zkAddress
localhost:2123 -port -1 -bootstrapServices []
2025/01/09 10:24:52.658 INFO [StartServiceManagerCommand] [main] Starting a
Pinot [SERVICE_MANAGER] at 24.398s since launch
2025/01/09 10:24:52.659 INFO [StartServiceManagerCommand] [main] Started
Pinot [SERVICE_MANAGER] instance [ServiceManager_116f76a7dd2f_-1] at 24.399s
since launch
2025/01/09 10:24:52.660 INFO [StartServiceManagerCommand] [Start a Pinot
[BROKER]] Starting a Pinot [BROKER] at 24.4s since launch
Jan 09, 2025 10:24:57 AM org.glassfish.jersey.internal.Errors logErrors
WARNING: The following warnings have been detected: WARNING: The
(sub)resource method getResults in
org.apache.pinot.broker.api.resources.ResponseStoreResource contains empty path
annotation.
WARNING: Return type, java.util.Collection<? extends
org.apache.pinot.spi.accounting.QueryResourceTracker>, of method, public
java.util.Collection<? extends
org.apache.pinot.spi.accounting.QueryResourceTracker>
org.apache.pinot.broker.api.resources.PinotBrokerDebug.getQueryUsage(), is not
resolvable to a concrete type.
WARNING: Return type, java.util.Collection<? extends
org.apache.pinot.spi.accounting.ThreadResourceTracker>, of method, public
java.util.Collection<? extends
org.apache.pinot.spi.accounting.ThreadResourceTracker>
org.apache.pinot.broker.api.resources.PinotBrokerDebug.getThreadResourceUsage(),
is not resolvable to a concrete type.
Jan 09, 2025 10:24:57 AM org.glassfish.grizzly.http.server.NetworkListener
start
INFO: Started listener bound to [0.0.0.0:8000]
Jan 09, 2025 10:24:57 AM org.glassfish.grizzly.http.server.HttpServer start
INFO: [HttpServer-1] Started.
2025/01/09 10:25:03.803 INFO [StartServiceManagerCommand] [Start a Pinot
[BROKER]] Started Pinot [BROKER] instance [Broker_172.17.0.4_8000] at 35.543s
since launch
2025/01/09 10:25:03.825 INFO [StartServerCommand] [main] Executing command:
StartServer -clusterName QuickStartCluster -serverHost null -serverPort 7050
-serverAdminPort 7500 -serverGrpcPort 7100 -serverMultistageServerPort 0
-serverMultistageRunnerPort 0 -dataDir
/tmp/1736418269393/quickstart/PinotServerDataDir0 -segmentDir
/tmp/1736418269393/quickstart/PinotServerSegmentDir0 -zkAddress localhost:2123
2025/01/09 10:25:03.828 INFO [StartServiceManagerCommand] [main] Executing
command: StartServiceManager -clusterName QuickStartCluster -zkAddress
localhost:2123 -port -1 -bootstrapServices []
2025/01/09 10:25:03.828 INFO [StartServiceManagerCommand] [main] Starting a
Pinot [SERVICE_MANAGER] at 35.568s since launch
2025/01/09 10:25:03.828 INFO [StartServiceManagerCommand] [main] Started
Pinot [SERVICE_MANAGER] instance [ServiceManager_116f76a7dd2f_-1] at 35.568s
since launch
2025/01/09 10:25:03.829 INFO [StartServiceManagerCommand] [Start a Pinot
[SERVER]] Starting a Pinot [SERVER] at 35.569s since launch
Jan 09, 2025 10:25:08 AM org.glassfish.jersey.internal.Errors logErrors
WARNING: The following warnings have been detected: WARNING: Return type,
java.util.Collection<? extends
org.apache.pinot.spi.accounting.QueryResourceTracker>, of method, public
java.util.Collection<? extends
org.apache.pinot.spi.accounting.QueryResourceTracker>
org.apache.pinot.server.api.resources.DebugResource.getQueryUsage(), is not
resolvable to a concrete type.
WARNING: Return type, java.util.Collection<? extends
org.apache.pinot.spi.accounting.ThreadResourceTracker>, of method, public
java.util.Collection<? extends
org.apache.pinot.spi.accounting.ThreadResourceTracker>
org.apache.pinot.server.api.resources.DebugResource.getThreadUsage(), is not
resolvable to a concrete type.
Jan 09, 2025 10:25:08 AM org.glassfish.grizzly.http.server.NetworkListener
start
INFO: Started listener bound to [0.0.0.0:7500]
Jan 09, 2025 10:25:08 AM org.glassfish.grizzly.http.server.HttpServer start
INFO: [HttpServer-2] Started.
2025/01/09 10:25:13.995 INFO [StartServiceManagerCommand] [Start a Pinot
[SERVER]] Started Pinot [SERVER] instance [Server_172.17.0.4_7050] at 45.735s
since launch
2025/01/09 10:25:13.998 INFO [StartMinionCommand] [main] Executing command:
StartMinion -minionHost null -minionPort 6000 -zkAddress localhost:2123
2025/01/09 10:25:13.999 INFO [StartServiceManagerCommand] [main] Executing
command: StartServiceManager -clusterName QuickStartCluster -zkAddress
localhost:2123 -port -1 -bootstrapServices []
2025/01/09 10:25:13.999 INFO [StartServiceManagerCommand] [main] Starting a
Pinot [SERVICE_MANAGER] at 45.739s since launch
2025/01/09 10:25:13.999 INFO [StartServiceManagerCommand] [main] Started
Pinot [SERVICE_MANAGER] instance [ServiceManager_116f76a7dd2f_-1] at 45.739s
since launch
2025/01/09 10:25:14.000 INFO [StartServiceManagerCommand] [Start a Pinot
[MINION]] Starting a Pinot [MINION] at 45.74s since launch
Jan 09, 2025 10:25:18 AM org.glassfish.grizzly.http.server.NetworkListener
start
INFO: Started listener bound to [0.0.0.0:6000]
Jan 09, 2025 10:25:18 AM org.glassfish.grizzly.http.server.HttpServer start
INFO: [HttpServer-3] Started.
2025/01/09 10:25:24.099 INFO [StartServiceManagerCommand] [Start a Pinot
[MINION]] Started Pinot [MINION] instance [Minion_172.17.0.4_6000] at 55.839s
since launch
***** Bootstrap tables *****
2025/01/09 10:25:24.206 INFO [AddTableCommand] [main] Executing command:
AddTable -tableConfigFile
/tmp/1736418324105/clickstreamFunnel_1736418324184.config
-offlineTableConfigFile null -realtimeTableConfigFile null -schemaFile
/tmp/1736418269393/clickstreamFunnel/clickstreamFunnel_schema.json
-controllerProtocol http -controllerHost localhost -controllerPort 9000
-controllerProtocol http -database null -user null -password [hidden] -exec
2025/01/09 10:25:24.674 INFO [AddTableCommand] [main]
{"unrecognizedProperties":{},"status":"TableConfigs clickstreamFunnel
successfully added"}
2025/01/09 10:25:25.683 INFO [AddTableCommand] [main] Executing command:
AddTable -tableConfigFile /tmp/1736418325669/airlineStats_1736418325671.config
-offlineTableConfigFile null -realtimeTableConfigFile null -schemaFile
/tmp/1736418269393/airlineStats/airlineStats_schema.json -controllerProtocol
http -controllerHost localhost -controllerPort 9000 -controllerProtocol http
-database null -user null -password [hidden] -exec
2025/01/09 10:25:25.983 INFO [AddTableCommand] [main]
{"unrecognizedProperties":{},"status":"TableConfigs airlineStats successfully
added"}
2025/01/09 10:25:42.123 INFO [AddTableCommand] [main] Executing command:
AddTable -tableConfigFile /tmp/1736418342114/baseballStats_1736418342118.config
-offlineTableConfigFile null -realtimeTableConfigFile null -schemaFile
/tmp/1736418269393/baseballStats/baseballStats_schema.json -controllerProtocol
http -controllerHost localhost -controllerPort 9000 -controllerProtocol http
-database null -user null -password [hidden] -exec
2025/01/09 10:25:42.244 INFO [AddTableCommand] [main]
{"unrecognizedProperties":{},"status":"TableConfigs baseballStats successfully
added"}
2025/01/09 10:26:12.899 INFO [AddTableCommand] [main] Executing command:
AddTable -tableConfigFile
/tmp/1736418372898/dimBaseballTeams_1736418372898.config
-offlineTableConfigFile null -realtimeTableConfigFile null -schemaFile
/tmp/1736418269393/dimBaseballTeams/dimBaseballTeams_schema.json
-controllerProtocol http -controllerHost localhost -controllerPort 9000
-controllerProtocol http -database null -user null -password [hidden] -exec
2025/01/09 10:26:12.958 INFO [AddTableCommand] [main]
{"unrecognizedProperties":{},"status":"TableConfigs dimBaseballTeams
successfully added"}
2025/01/09 10:26:13.117 INFO [AddTableCommand] [main] Executing command:
AddTable -tableConfigFile
/tmp/1736418373115/starbucksStores_1736418373116.config -offlineTableConfigFile
null -realtimeTableConfigFile null -schemaFile
/tmp/1736418269393/starbucksStores/starbucksStores_schema.json
-controllerProtocol http -controllerHost localhost -controllerPort 9000
-controllerProtocol http -database null -user null -password [hidden] -exec
2025/01/09 10:26:13.186 INFO [AddTableCommand] [main]
{"unrecognizedProperties":{},"status":"TableConfigs starbucksStores
successfully added"}
2025/01/09 10:26:13.811 INFO [AddTableCommand] [main] Executing command:
AddTable -tableConfigFile /tmp/1736418373809/githubEvents_1736418373810.config
-offlineTableConfigFile null -realtimeTableConfigFile null -schemaFile
/tmp/1736418269393/githubEvents/githubEvents_schema.json -controllerProtocol
http -controllerHost localhost -controllerPort 9000 -controllerProtocol http
-database null -user null -password [hidden] -exec
2025/01/09 10:26:13.877 INFO [AddTableCommand] [main]
{"unrecognizedProperties":{},"status":"TableConfigs githubEvents successfully
added"}
2025/01/09 10:26:17.509 INFO [AddTableCommand] [main] Executing command:
AddTable -tableConfigFile
/tmp/1736418377506/githubComplexTypeEvents_1736418377507.config
-offlineTableConfigFile null -realtimeTableConfigFile null -schemaFile
/tmp/1736418269393/githubComplexTypeEvents/githubComplexTypeEvents_schema.json
-controllerProtocol http -controllerHost localhost -controllerPort 9000
-controllerProtocol http -database null -user null -password [hidden] -exec
2025/01/09 10:26:17.581 INFO [AddTableCommand] [main]
{"unrecognizedProperties":{},"status":"TableConfigs githubComplexTypeEvents
successfully added"}
2025/01/09 10:26:29.119 INFO [AddTableCommand] [main] Executing command:
AddTable -tableConfigFile /tmp/1736418389119/billing_1736418389119.config
-offlineTableConfigFile null -realtimeTableConfigFile null -schemaFile
/tmp/1736418269393/billing/billing_schema.json -controllerProtocol http
-controllerHost localhost -controllerPort 9000 -controllerProtocol http
-database null -user null -password [hidden] -exec
2025/01/09 10:26:29.186 INFO [AddTableCommand] [main]
{"unrecognizedProperties":{},"status":"TableConfigs billing successfully added"}
2025/01/09 10:26:29.576 INFO [AddTableCommand] [main] Executing command:
AddTable -tableConfigFile
/tmp/1736418389575/fineFoodReviews_1736418389575.config -offlineTableConfigFile
null -realtimeTableConfigFile null -schemaFile
/tmp/1736418269393/fineFoodReviews/fineFoodReviews_schema.json
-controllerProtocol http -controllerHost localhost -controllerPort 9000
-controllerProtocol http -database null -user null -password [hidden] -exec
2025/01/09 10:26:29.668 INFO [AddTableCommand] [main]
{"unrecognizedProperties":{},"status":"TableConfigs fineFoodReviews
successfully added"}
***** Waiting for 5 seconds for the server to fetch the assigned segment
*****
***** Offline quickstart setup complete *****
Total number of documents in the table
Query : select count(*) from baseballStats limit 1
2025/01/09 10:26:40.127 INFO [PostQueryCommand] [main] Executing command:
PostQuery -brokerProtocol http -brokerHost 172.17.0.4 -brokerPort 8000 -query
select count(*) from baseballStats limit 1
count(*)
97889
***************************************************
Top 5 run scorers of all time
Query : select playerName, sum(runs) from baseballStats group by playerName
order by sum(runs) desc limit 5
2025/01/09 10:26:40.455 INFO [PostQueryCommand] [main] Executing command:
PostQuery -brokerProtocol http -brokerHost 172.17.0.4 -brokerPort 8000 -query
select playerName, sum(runs) from baseballStats group by playerName order by
sum(runs) desc limit 5
playerName sum(runs)
John Joseph 11581.0
Michael Joseph 7981.0
James Edward 6083.0
William Henry 5933.0
William Joseph 5547.0
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
