Hey all I’m new to Pinot and this Slack. I’m stuc...
# troubleshooting
d
Hey all I’m new to Pinot and this Slack. I’m stuck on a couple of issues. I’m hoping there are answers here… 1. Realtime tables: I am trying to add a very simple Realtime table via the commandline. My pinot implementation is within a docker container. Here is the line I am running:
docker exec -i pinot ./pinot/bin/pinot-admin.sh AddTable -schemaFile testschema.json –tableConfigFile testtable.json -exec
• From what I can tell, this is exactly what it should be. The schema is already successfully added. Kafka is successfully running with messages in a topic. However, when I run this line, it returns the error: MissingParameterException: Missing required option: ‘-tableConfigFile=<_tableConfigFile>’ • Then, when I look into the Pinot UI, there is no table. • I try then to add the table via the Pinot UI and discover that the table is actually there, but I cannot see it in the UI. ◦ I initially see this message when saving the Realtime table via the Pinot UI: “TimeoutException: Timeout expired while fetching topic metadata” ◦ I try the save again and at that point I received the message that the table exists already. • Apparently, I am able to delete the table using the “Delete tableConfig” in the Swagger API… The “Delete tableName” would not work. • Attached are the schema and table config…
m
I suspect that the table config json file has some issue. Can you check for errors in controller log?
d
Where should the logs be?
Do you mean in a particular folder? Or, do you mean that the logs are available through the Pinot UI?
I think I found them…
pinot-all.log
I see the mention of an Invalid instance setup, but I see the Pinot UI and it shows that things are running…. just no table.
image.png
m
Will take a look at the log shortly
Hmm, I don’t seem to find anything related to
testtable
in your doc. Can you try to add the table using Pinot UI?
image.png
d
We were able to solve the issue with the table. The problem was that “stream.kafka.broker.list”needed the value of “broker:9092" rather than “localhost:9092”. Apparently, the kafka instance was spun up under the hostname “broker”….. thtas the best estimation I have. Another colleague believes that the work “broker” is hard-coded into the Pinot system. Could you clarify whether that is the case or not? Thanks!
m
I don’t think it is hardcoded in Pinot.