Hi, I am facing an error, when I run a query like ...
# troubleshootingh
harry singh
07/20/2022, 6:42 PMHi, I am facing an error, when I run a query like select col1, count() from table where col2='val' group by col1 having count() >1 it works on pinot but fails when run via trino-pinot connector.
Error:
Error from Query Engine
ExtractedRawQuery select "internal_error_code", count("*") from sr_view_v1 where (("count(*)" > '1')) AND ("network" = 'Visa') group by "internal_error_code" limit 5000001 encountered exception org.apache.pinot.common.response.broker.QueryProcessingException@3e0dac0b with query "select "internal_error_code", count("*") from sr_view_v1 where (("count(*)" > '1')) AND ("network" = 'Visa') group by "internal_error_code" limit 5000001"m
Mayank
07/20/2022, 7:00 PM
@Elon ^^
h
harry singh
07/21/2022, 8:28 AM@Elon what can we do here?
e
Elon
07/21/2022, 8:34 AMUnfortunately having support is not yet supported. I have code for it working here, need to open source it.
Elon
07/21/2022, 8:35 AMAs a workaround you can filter the
count(*)h
harry singh
07/21/2022, 8:50 AMjust to confirm you mean the support for it is not there in the trino-pinot connector right? I checked the query works on pinot. also, the filters are generated by a BI tool (looker), let me check if there is a way I can filter the count(*) outside somehow, not too sure about it
harry singh
07/21/2022, 10:11 AM@Elon can you provide us the code that you have working for "having" query?
e
Elon
07/21/2022, 10:14 AMabsolutely, will update you.
👍 1
h
harry singh
07/24/2022, 4:59 PM@Elon hey, following up on previous conv.
e
Elon
07/24/2022, 6:25 PMHi, I will likely have something this week, will keep you updated.
thankyou 1
h
harry singh
08/08/2022, 8:21 AMhi @Elon @Mayank just following up on this thread, is there a solution/ workaround we can do?
harry singh
08/08/2022, 8:26 AMok i see there is a PR for this already https://github.com/trinodb/trino/pull/13429 , thanks, any way we can ask the community to prioritize this?