@Cody kamat While running hive import target-dir argument value controls where the data needs to store temporarily before loading into Hive table, but target-dir doesn't create hive table in that location. If you want to import to specific directory then use target-dir without hive-import argument and create hive table on top of HDFS directory. (or) Create Hive external table pointing to your target-dir then in sqoop import remove --create-hive-table argument and --target-dir. For more info refer to this HCC thread regarding the same issue. ... View more