DuneSQL Plan Time Error with Many Columns [New to DuneSQL - not an error in Spark]

When I have a query return many columns ~20+ (including window functions), DuneSQL returns an error: `Error: Query exceeded the maximum planning time limit of 10.00m [Execution ID: 01H3SK69EB5H6MXB6DH0BCNT2A].` This error is new to DuneSQL and does not happen in Spark. One of these queries ran in 1 min in Spark, but returns this planning timeout error in DuneSQL (after running for 10 mins). When some of these columns are removed from the final output, this error does not appear. Error: https://dune.com/queries/347720/662079?d=11 Fix when removing many columns: https://dune.com/queries/876366 Also shared in Discord here: https://discord.com/channels/757637422384283659/1051871389432422491/1122551330339299379

Please authenticate to join the conversation.

Upvoters
Status

Open

Board

Bugs

Date

Almost 3 years ago

Author

Michael S

Subscribe to post

Get notified by email when there are changes.