vincenzo_giangr
New Contributor

Re: INSERT OVERWRITE TABLE not compact ORC Files i...

by New Contributor in Support Questions
‎07-24-2019 07:40 AM
‎07-24-2019 07:40 AM
Hi @Vikas Srivastava , Thank you for your suggestion, I had already tried the suggestions of the page you linked, but there are 2 problem orders: SET mapreduce.input.fileinputformat.split. * Cannot be changed at runtime; The table uses bucketing, and the concatenate does not support Bucket; I get an error when I run it. Best regards Vincenzo ... View more

INSERT OVERWRITE TABLE not compact ORC Files in Pa...

by New Contributor in Support Questions
‎07-19-2019 05:08 AM
‎07-19-2019 05:08 AM
I have the external table : PARTITIONED BY ( `y_m` int) CLUSTERED BY ( l_n) INTO 16 BUCKETS STORED AS ORC; when I try to compaction ORC files (5000 files in HDFS path), the files not compacted, and the size of single files not changed: INSERT OVERWRITE TABLE TableName PARTITION (y_m='201906') SELECT ... .... FROM TableName WHERE y_m='201906'; ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎07-24-2019 07:36 AM
Public Statistics
Date Registered ‎07-18-2019 09:33 AM
Last Visited ‎07-24-2019 07:36 AM
Total Messages Posted 2
; ;