Operation not allowed: ALTER TABLE COMPACT(line 1, pos 0)

Posted by 陈星宇 on Jun 27, 2018; 9:38am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Operation-not-allowed-ALTER-TABLE-COMPACT-line-1-pos-0-tp53394.html

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