https://community.cloudera.com/t5/Support-Questions/Dynamic-partition-with-sqoop/m-p/191782#M153861 <P>I read from sqoop documentation</P><P><A href="http://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_hcatalog_background" target="_blank">http://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_hcatalog_background</A></P><H3>23.6. Support for Partitioning</H3><P>The Sqoop HCatalog feature supports the following table types:</P><UL> <LI>Unpartitioned tables</LI><LI>Partitioned tables with a static partitioning key specified</LI><LI>Partitioned tables with dynamic partition keys from the database result set</LI><LI>Partitioned tables with a combination of a static key and additional dynamic partitioning keys</LI></UL><P>But I am not getting how to use dynamic partition using sqoop.</P><PRE>sqoop import --connect jdbc:mysql://localhost:3306/test --username root --password-file file:///home/hdfs/.password --split-by id --table test --delete-target-dir --fields-terminated-by "," --hcatalog-table test --hcatalog-storage-stanza "stored as orcfile" --create-hcatalog-table --hcatalog-partition-keys created_at --map-column-hive created_at=date,updated_at=date</PRE><P><STRONG>Getting This error</STRONG></P><P><BR />Either both --hcatalog-partition-keys and --hcatalog-partition-values should be provided or both of these options should be omitted.<BR />and if I use the partition value then it assigns it as static partition</P><PRE>sqoop import --connect jdbc:mysql://localhost:3306/test --username root --password-file file:///home/hdfs/.password --split-by id --table test --delete-target-dir --fields-terminated-by "," --hcatalog-table test --hcatalog-storage-stanza "stored as orcfile" --create-hcatalog-table --hcatalog-partition-keys created_at --hcatalog-partition-value created_at --map-column-hive created_at=date,updated_at=date </PRE><P>after giving created_at as hcatalog-partition-value it created the directory like apps/hive/warehouse/test/created_at=created_at</P><P>it should have used created_at column to create dynamic partition based on data.<BR /></P><P>Please help me fix this issue</P> Wed, 17 Jan 2018 15:20:33 GMT mubbashar_h 2018-01-17T15:20:33Z