Thanks Harsh,   Can you please elaborate bit more about you below comment,   " Configure two unique values for these properties in two different instances of the command to achieve your goal."   Did you mean on two different host ? Can "sqoop.metastore.server.port " take comma delimited multiple value ? Can "sqoop.metastore.server.location " take comma delimited multiple value ?     Your expert comment will be highly appreciated.   Regards Niraj ... View more