Thank you Gopal for pointing the root cause. After running command alter table xxx compact ‘major’ to request a force compaction, total length is right !
Is there any way to do compact immediately after insert values. Bob He Thanks On 25 Jul 2018, at 1:45 PM, Gopal Vijayaraghavan <gop...@apache.org> wrote: > Search ’Total length’ in log sys_dag_xxx, it is 2147483648. This is the INT_MAX “placeholder” value for uncompacted ACID tables. This is because with ACIDv1 there is no way to generate splits against uncompacted files, so this gets “an empty bucket + unknown number of inserts + updates” placeholder value. Cheers, Gopal
