Hi,
I am using Vertica DB and connected to Dremio. Running a simple select as “select count(*) from table where column1 is null;” this query is running for a while (waiting for 30 minutes and beyond) but not displaying any result hence need to cancel. The same query is working fine on dbeavur or any other clients. I am using Vertica 11.1.x and Dremio version 23.2.2-202307280452300417-9276e770. I created a view in space and created reflection which is working out. But i cannot use reflection for this purpose as there will be a latency in data. Please advice.
You should check out the Dremio query profile and see if the filter has been pushed down into Vertica.
It is stuck in the JDBC_SUB_SCAN and i need to cancel the query. I am running against Vertica.
Thanks.
@u.sundaram Does the query complete if you directly run on Vertica? If yes, kindly send the Dremio profile as (like @Benny_Chow pointed out) that will tell us what the pushdown to Vertica is
Hi Balaji, Thanks for your quick response. Yes it is finishing in Vertica using VSQL or Dbeaver but not in Dremio. Here is attached the profile for your analysis. Thanks.
80cb6e0d-eed9-418f-b973-c04bc0c9962c.zip (61.8 KB)