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

[陈星宇]

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

[kunalkapoor]

Hi chenxingyu,
I am unable to reproduce the issue. Can you please verify your jars. This
looks to be a parsing issue.

Thanks
Kunal Kapoor

On Wed, Jun 27, 2018 at 3:09 PM 陈星宇 <[hidden email]> wrote:

> 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