Can't query created tables

[vitali...@gmail.com]

Hello, 

I've faced with the following problem:

I add schema and create table:

ubuntu@pinot-1:~$ /opt/pinot-0.016/bin/pinot-admin.sh AddSchema -schemaFile /home/ubuntu/test-schema.json -controllerHost 127.0.0.1 -exec

Executing command: AddSchema -controllerHost 127.0.0.1 -controllerPort 9000 -schemaFilePath /home/ubuntu/test-schema.json -exec

ubuntu@pinot-1:~$ /opt/pinot-0.016/bin/pinot-admin.sh AddTable -filePath /home/ubuntu/test-table-definition.json -controllerHost 127.0.0.1 -exec

Executing command: AddTable -filePath /home/ubuntu/test-table-definition.json -controllerHost 127.0.0.1 -controllerPort 9000 -exec

Success

It seems that table creation was really succeeded, because if I try to execute the same command again, I get such a message:

ubuntu@pinot-1:~$ /opt/pinot-0.016/bin/pinot-admin.sh AddTable -filePath /home/ubuntu/test-table-definition.json -controllerHost 127.0.0.1 -exec

Executing command: AddTable -filePath /home/ubuntu/test-table-definition.json -controllerHost 127.0.0.1 -controllerPort 9000 -exec

Failed: Skip the operation. Resource ideal state directory already exists:/PinotCluster/IDEALSTATES/test_OFFLINE

Then I try to query this table and I get "No table hit!" exception:

ubuntu@pinot-1:~$ curl -X POST -d '{"pql":"select count(*) from test"}' http://127.0.0.1:8099/query

{"traceInfo":{},"numDocsScanned":0,"aggregationResults":[],"timeUsedMs":0,"segmentStatistics":[],"exceptions":["ProcessingException(errorCode:410, message:No table hit!)"],"totalDocs":0}

Does it mean that table was not created? What could go wrong?

[Jean-François Im]

Did you upload data to that table? When the table is empty, it will give this error.

[thasarathan s]

hi bro , if possible pls share the code how to create schema and table etc ...