I too got the same exception while insert overwrite to a bucketed table by selecting data from a partitioned table. I applied a work around to get around this problem. 1. First insert the data to a non partitioned temp table 2.select the data from the temp table and insert it to the bucketed table This solved the problem for me. ... View more