<@UK6JD1E85> Hi Rong. Sorry to bother you. I'm try...
# pinot-dev
e
@Rong R Hi Rong. Sorry to bother you. I'm trying to build Pinot on branch 'pr-query-integration'. I followed instructions from this Conversation(https://github.com/apache/pinot/pull/8662). But when I try to query on broker, I encountered some problems. When I query like this "SELECT * FROM baseballStats_OFFLINE", it will return some results. But if I query like this "SELECT playerId FROM baseballStats_OFFLINE", it will take almost 10 seconds, and return an empty result. It's same when I use 'inner join', doesn't report any exception or error, but just return empty result. I started Pinot like this 'bin/pinot-admin.sh StartServiceManager -bootstrapConfigPaths conf/pinot-controller.conf conf/pinot-broker.conf conf/pinot-server.conf'(I has already started Zookeeper), and all components on the same machine(1 controller,1 broker,1 server) And now I don't know what happened and want to know how to locate problems, could you please give me some advices? Thanks.
r
Interesting. Which commit ID were you using. I recently updated the branch to rebased against master. There might be some merge conflict that I wasn't resolving correctly
e
33196f0de787b4fb8a565b0e2562e881e0e88845
r
thanks. I will take a look.
e
Thanks, and I will try the latest commit.
r
thereโ€™s still a bug in the merge conflict in one of the serialization codepath. let me fix that and refresh the branch
i putout a fix for this once merged i will update the PR with new instructions
hotfix is landed. please try again whenever you have time: https://github.com/apache/pinot/pull/8662
e
Thanks! I will try it immediately๐Ÿ‘
Hi @Rong R. Sorry to bother you again. I used the branch multi_stage_query_engine(08da4ee9) to build project instead of pr_query_integration, cause I find the hotfix was on multi_stage_query_engine. After deployed, querying single table without join was okay. But If I query like this `select a.userId from aaa_OFFLINE as a inner join bbb_OFFLINE as b on a.orgId = b.orgId`(these tables were already uploaded), I will got an error like below:
Copy code
SQLParsingError:\njava.lang.RuntimeException: No list started\n\tat org.apache.calcite.sql.pretty.SqlPrettyWriter.sep(SqlPrettyWriter.java:1091)\n\tat org.apache.calcite.sql.pretty.SqlPrettyWriter.sep(SqlPrettyWriter.java:1086)\n\tat org.apache.calcite.sql.SqlJoin$SqlJoinOperator.unparse(SqlJoin.java:220)\n\tat org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:461)
I don't know if I missed some initial config or I just choose wrong branch(cause I find that there are some diff between multi_stage_query_engine and pr_query_integration). Could you please give me some advices? Thanks.
r
oops. I forgot to push to the quickstart branch. i just did.
๐Ÿ™Œ 1
this error indicate that you are not using the new engine. please try again with the quickstart branch.
e
I just used a join query and it works! Thanks!๐ŸŽ‰
r
no problem. sorry for the delay, once we merge it back to master branch we will have a more smooth experience.
๐ŸŽ‰ 1