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?