'msck repair table sync partitions and spark-sql

I have a problem when adding keyphrase sync partitions in spark-sql cli:

spark-sql> msck repair table my_table sync partitions;
Error in query: 
mismatched input 'sync' expecting {<EOF>, ';'}

== SQL ==
MSCK REPAIR TABLE my_table sync partitions
---------------------------^^^

At the same time, the same request is ok with hive cli:

hive> msck repair table my_table sync partitions
[2022-03-22 12:58:50] completed in 670 ms

Is there any workaround, to execute repair with sync partitions via spark-sql?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'msck repair table sync partitions and spark-sql

Sources

Related Questions