https://pinot.apache.org/ logo
Join Slack
Powered by
:wave: Hello, I am working through the QuickStart ...
# troubleshooting
r
šŸ‘‹ Hello, I am working through the QuickStart Tutorial, and I started pinot locally with the command: 
./bin/pinot-admin.sh QuickStart -type batch
. I can see a log entry for the the table being added, and no obvious errors:
Copy code
Adding offline table: baseballStats
Executing command: AddTable -tableConfigFile /var/folders/jv/g99n5jcj3hz0lbbf90gykcc40000gq/T/1651874628141/baseballStats_1651874628195.config -schemaFile /var/folders/jv/g99n5jcj3hz0lbbf90gykcc40000gq/T/1651874604715/baseballStats/baseballStats_schema.json -controllerProtocol http -controllerHost localhost -controllerPort 9000 -user null -password [hidden] -exec
but I do not see the table via the UI (please see screenshot). Is there an additional step that I need to take in order to see the table? Thanks! Not sure if it's relevant, but here is some version information: Java: 
openjdk 11.0.15 2022-04-19
pinot: 
pinot-0.10.0
x
if the cmd went well, the table should show up in UI
trying this on my side
r
Since I'm not seeing it, I'm guessing there was an issue adding table. Is there anywhere else to check for logging? I looked in 
logs/pinot-all.log
as well, but I see 
44293 2022/05/06 16:03:48.195 INFO [BootstrapTableTool] [main] Adding offline table: baseballStats
and no errors/exceptions.
x
hmm.. just tried this quickstart on my side (but on latest master branch), looks like things worked as expected, and logs are just emit to console
I can try it on 
pinot-0.10.0
shortly
thankyou 1
for a clean attempt, I downloaded pinot-0.10.0 binary and ran the cmd again. It went well. The sample queries returned with results, and the pinot UI showed the table too. And the logs simply emit to console (pretty verbose actually)
Copy code
āžœ  apache-pinot-0.10.0-bin bin/pinot-admin.sh QuickStart -type batch
...
Query : select playerName, runs, homeRuns from baseballStats order by yearID limit 10
Executing command: PostQuery -brokerProtocol http -brokerHost 192.168.0.101 -brokerPort 8000 -queryType sql -query select playerName, runs, homeRuns from baseballStats order by yearID limit 10
Processed requestId=5,table=baseballStats_OFFLINE,segments(queried/processed/matched/consuming)=1/1/1/-1,schedulerWaitMs=0,reqDeserMs=0,totalExecMs=33,resSerMs=0,totalTimeMs=34,minConsumingFreshnessMs=-1,broker=Broker_192.168.0.101_8000,numDocsScanned=97889,scanInFilter=0,scanPostFilter=97919,sched=FCFS,threadCpuTimeNs(total/thread/sysActivity/resSer)=0/0/0/0
requestId=5,table=baseballStats_OFFLINE,timeMs=40,docs=97889/97889,entries=0/97919,segments(queried/processed/matched/consuming/unavailable):1/1/1/0/0,consumingFreshnessTimeMs=0,servers=1/1,groupLimitReached=false,brokerReduceTimeMs=2,exceptions=0,serverStats=(Server=SubmitDelayMs,ResponseDelayMs,ResponseSize,DeserializationTimeMs,RequestSentDelayMs);192.168.0.101_O=0,36,642,0,1,offlineThreadCpuTimeNs(total/thread/sysActivity/resSer):0/0/0/0,realtimeThreadCpuTimeNs(total/thread/sysActivity/resSer):0/0/0/0,query=select playerName, runs, homeRuns from baseballStats order by yearID limit 10
playerName		runs		homeRuns
Alfred L.		0		0
Charles Roscoe		66		0
Adrian Constantine		29		0
Robert		9		0
Arthur Algernon		28		0
Douglas L.		28		2
Francis Patterson		0		0
Robert Edward		30		0
Franklin Lee		13		0
William		1		0

***************************************************
You can always go to <http://localhost:9000> to play around in the query console
...



āžœ  apache-pinot-0.10.0-bin java -version
openjdk version "11.0.11" 2021-04-20
OpenJDK Runtime Environment AdoptOpenJDK-11.0.11+9 (build 11.0.11+9)
OpenJDK 64-Bit Server VM AdoptOpenJDK-11.0.11+9 (build 11.0.11+9, mixed mode)
r
Interesting, I don't think I'm getting the query output. Is it after all of the bootstrapping has completed?
x
yes, after the pinot components got started, table created and sample data ingested into the table.
r
Did you get an explicit message for the data being ingested into the table?
x
e.g. there were logs like
Copy code
Executing command: AddTable -tableConfigFile /var/folders/_0/gctvc27x5795n3rb5zh52qm00000gn/T/1651877834470/baseballStats_1651877834521.config -schemaFile /var/folders/_0/gctvc27x5795n3rb5zh52qm00000gn/T/1651877789218/baseballStats/baseballStats_schema.json -controllerProtocol http -controllerHost localhost -controllerPort 9000 -user null -password [hidden] -exec
Adding schema: baseballStats with override: true
Added schema: baseballStats
...
{"status":"Table baseballStats_OFFLINE succesfully added"}
...

Uploading a segment baseballStats_OFFLINE_0 to table: baseballStats, push type SEGMENT, (Derived from API parameter)
...
Added segment: baseballStats_OFFLINE_0 to IdealState for table: baseballStats_OFFLINE
...
Open in Slack
PreviousNext
Powered by