Where to check generated SQL by Arcadia. Does Arcadia not perform group by automatically?

Hi,
Where to check generated SQL by Arcadia please advise. I don’t have Activity in drop down menu, is that the place?
I am using Postgres connection from Arcadia.
Facing complaints about syntax which is not used in filter e.g.

Visual 2207 - Could not load data
Error: column “2019-09-21” does not exist
LINE 4: …019-09-21’) AND (TA_0.“period_start_time” between "2019-09-2…

which my filter does not use between but date([period_start_time]) >= ‘<selectdate.start:2019-09-20>’

Also another visual shows error:
Visual 1651 - Could not load data
Error: column “ta_0.period_start_time” must appear in the GROUP BY clause or be used in an aggregate function
LINE 4: HAVING (TA_0.“period_start_time” \u003E= ‘2019-09-20’ AND
^
in my visual only use period_start_time in filter shelft not in dimension so wonder why it complains about ‘Group by’

The same visuals has been tested with spark connection with no error.

Please advise. Thank you very much.

@Stima_Livingpresent there’s known bug with postgres connection when using date filters. It has been fixed in our newer release, starting in 5.1

As for the generated SQL, you need to look at the Activity log page (the last column called “query” as shown below).

Alternatively, you have to look at the raw logs on the server located in /var/log/arcadia.

2 Likes