Thank you for your reply! Compaction never happen. I used Hive in ASW EMR. create the table from S3 ORC files using the following command: CREATE TABLE tablename (id STRING, ts TIMESTAMP, category STRING) PARTITIONED BY(`date` STRING) clustered by (category) into 1 buckets STORED AS ORC LOCATION 's3://orc-mutation-test/20/' tblproperties ("orc.compress"="SNAPPY","transactional"="true"); In this way, the user and owner of this table is Hive, right? I feel it was because I did not add in remote metastore, so the compaction cannot be generated and submitted.
... View more
