https://community.cloudera.com/t5/Support-Questions/Dynamic-partition-with-sqoop/m-p/297974#M218918 <P><U>Hi to all</U></P><P>&nbsp;</P><P><U>I'm looking for a solution to import and to partition dynamically data into ORC hive tables.</U></P><P>&nbsp;</P><P>I've seent that with sqoop it is possibile di import and to partition data dynamically by the value of columns, but I've also seen that this feature is working only for the first run, because in the following job launchs I get an&nbsp; '<EM>org.apache.hive.hcatalog.common.HCatException : 2002 : Partition already present with given partition key values' </EM>message since sqoop is aptempting toappend data to existing partitions.</P><P>&nbsp;</P><P>Any idea to resolve this issue that make impossibile to use dynamic partioning in sqoop?</P><P>&nbsp;</P> Fri, 12 Jun 2020 17:24:55 GMT larnone 2020-06-12T17:24:55Z