Hi, Guys! im a new here. I got the error like this
> ERROR: column "ph.company_size" must appear in the GROUP BY clause or be used in an aggregate function Position: 2919
actually, how to read the position, where to find 2919?
Thanks, appreciate your help
Hi @alk0301
That's currently not possible to easily locate that, but make sure that whichever columns you have in your select-clause should also be in your group-clause.
You can try running your query directly on your database and see if it helps you locate the problem.
There's a request for such functionality, which is a lot harder than what people think.
https://github.com/metabase/metabase/issues/625 - upvote by clicking on the first post
It seems Metabase team is working on it:
opened 07:49PM - 12 Jul 15 UTC
Querying/Processor
Type:New Feature
Querying/Native
.Backend
new card builder only tells you position number instead of row that an error occ… urred in
:arrow_down: Please click the :+1: reaction instead of leaving a `+1` or `update?` comment
I left a comment on the issue asking more details.
Having the line number instead of the position would improve our life so much.