hi,
i refer to the official document to compact carbondata table by command 'ALTER
TABLE tempdb.trade_item_par_3 COMPACT 'CUSTOM' WHERE SEGMENT.ID IN (11,12) ',
but got error :
Error: org.apache.spark.sql.AnalysisException: == Parse1 ==
Operation not allowed: ALTER TABLE COMPACT(line 1, pos 0)
== SQL ==
ALTER TABLE tempdb.trade_item_par_3 COMPACT 'CUSTOM' WHERE SEGMENT.ID IN (11,12)
^^^
== Parse2 ==
[1.54] failure: ``;'' expected but `where' found
ALTER TABLE tempdb.trade_item_par_3 COMPACT 'CUSTOM' WHERE SEGMENT.ID IN (11,12)
^;;
SQLState: null
ErrorCode: 0
chenxingyu