Support Questions
Find answers, ask questions, and share your expertise

HDPCD Practice exam instance: sqoop --hive-import forcing to specify--target-dir

Contributor

In HDPCD practice exam instance available in AWS, while trying --hive-import in sqoop, mentioning --target-dir is an option.

But this instance doesnt run the sqoop query until --target-dir is not mentioned.

sqoop import --connect jdbc:mysql://namenode/flightinfo --query "SELECT * from weather WHERE precipitation!=0 AND \$CONDITIONS" --hive-import -m 1 --username root -P

Warning: /usr/hdp/2.2.0.0-2041/sqoop/sqoop/bin/../../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
17/11/05 00:39:34 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5.2.2.0.0-2041
Enter password: 
Must specify destination with --target-dir. 
Try --help for usage instructions.