Invalid Query Exception

1

I have a query that terminates with an ‘Invalid Query Exception’ error. I’m trying to figure out what the issue is. I’ve attached the profile. Could you take a look and let me know what the issues is?

631e2e9d-a0a1-4acc-98cc-83bac0b773c7.zip (3.0 MB)

2

Hello @summersmd,

I’m having trouble viewing this query profile (it’s relatively large). Can you report the verbose error stack from the error tab of the profile?

3 
     PLAN ERROR: Query was cancelled because planning time exceeded 60 seconds

Planner Phase Logical Planning

4

ben, if you get time could you also look at Execution times differ radically between runs for me? It’s been causing some issues.

5

Has anoyone else seen this issue?

6

I’m facing a similar problem. I described it on his thread: Dremio jobs taking too long to planning

7

Is your planner.experimental.pclean_logical: parameter disabled, @summersmd?

8

Yes, it is toggled off.

9

Ben,

I have posted the error stack. Is there any way you can help me fix this?