Error on ANALYZE TABLE [...] COMPUTE STATISTICS FOR COLUMNS [...]

leungi
Contributor

‎07-09-2024 07:51 AM

End goal is to apply OPTIMIZE and ZORDER table.

However, one of the columns to be ZORDER doesn't have stats collected.

Running ANALYZE generates the error below.

Query

ANALYZE TABLE <catalog>.<schema>.<table> COMPUTE STATISTICS FOR COLUMNS my_col_1, my_col_2;
 
Error
[INTERNAL_ERROR] Eagerly executed command failed. You hit a bug in Spark or the Spark plugins you use. Please, report this bug to the corresponding communities or vendors, and provide the full stack trace. SQLSTATE: XX000
0 Kudos

leungi
Contributor
In response to Retired_mod

‎07-11-2024 09:17 AM - edited ‎07-11-2024 09:19 AM

@Retired_mod , thanks for the detailed suggestions.

1. Running SHOW COLUMN STATS yields the following error:

[PARSE_SYNTAX_ERROR] Syntax error at or near 'CHECK'. SQLSTATE: 42601 line 1, pos 0

== SQL ==
CHECK COLUMN STATS <catalog>.<schema>.<table> 
^^^

Ran DESCRIBE DETAIL <catalog>.<schema>.<table> successfully, and it indicates no column stats are currently being collected.

leungi_0-1720714440270.png

3. Ran ANALYZE TABLE <catalog>.<schema>.<table> COMPUTE STATISTICS FOR COLUMN my_col_1; for a single column, and faced the same error.

 

Any further troubleshooting tips are much appreciated!

0 Kudos