Hi All ,
I have a strange error in my stored procedure when i try to do merge partition but the same error is not encounter when doing from hana studio sql console any help is really appreciated . Many thanks
From sql console
Statement 'alter table DMF.TEST2 merge partitions' successfully executed in 290 ms 952 µs (server processing time: 289 ms 473 µs) - Rows Affected: 0
From Stored procedure
line 22 col 1 (at pos 1560): [129] (range 3): transaction rolled back by an internal error: column store error: fail to alter partition: [2999] general error (no further information available);replayLog: Cannot create delta for table that is not yet visible in a separate transaction;Error when merging delta index of part. java.sql.SQLWarning: Not recommended feature: DDL statement is used in Dynamic SQL (current dynamic_sql_ddl_error_level = 1)
My syntax in stored procedure
exec 'alter table ' || :p_schema_name || '.TEST2 drop primary key'; --exec 'alter table ' || :p_schema_name || '.TEST2 merge partitions'; exec ( 'alter table ' || :p_schema_name || '.TEST2 merge partitions' );
Any thoughts ??, Thanks