https://community.cloudera.com/t5/Support-Questions/Hive-Dynamic-partition-issue/m-p/189641#M151734 <P><A rel="user" href="https://community.cloudera.com/users/48176/voxjungle.html" nodeid="48176">@Team Spark</A> </P><P>Seems the target has 2 columns where as your insert query has 3 columns. Check the no of columns in the select clause. Then it should work fine. Its not the problem with dynamic partition.</P> Mon, 06 Nov 2017 15:57:41 GMT balavignesh_nag 2017-11-06T15:57:41Z