Can you please try manual compaction and see if those delta files getting merged? ... View more

Nothing seems wrong in the logs, Did it triggered automatically? if not have you tried manual way? ... View more

Not sure why NN format required here. ... View more

@c pat This seems to be an issue with Ambari, Kindly restart the Ambari process and NN host to cleanup cache. Or else you can change the port 50070 to some other available port. Curious to know your Ambari and HDP version? ... View more

@Laurent de Laprade I have opened an internal Documentation bug for this and it will get fixed soon, Thanks for raising it. ... View more

Rest of the parameters seems fine, Are you seeing any error in metastore logs? Did you notice any compaction or cleaner thread logs in hivemeta? ... View more

@Roberto Sancho Did you restarted the hive services after changing delta threshold to 5?. Did you tried to do manual compaction? if yes then was there any transaction files inside those directories after that? ... View more

@sameer lail Do you have some sample dataset that I can use to reproduce this? ... View more

@Roberto Sancho If compaction is enabled then you won't need to do it manually but if it disabled then you can use "ALTER TABLE" statement. Please see below doc for info. ALTER TABLE table_name [PARTITION (partition_key = 'partition_value' [, ...])] COMPACT 'compaction_type'; https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTable/PartitionCompact ... View more