Can we import data with sqoop into hdfs and hive? I have try it with two different user (root and admin) Below the command between root and admin
[Root]
sqoop import --connect jdbc:mysql://10.6.162.58/test_alpha --username pbd -P --table posts --hive-import --hive-database test_root --hive-table posts1 --hive-drop-import-delims --null-string '\N' --null-non-string '\N' --target-dir test_hive_root/2
[Admin]
sqoop import --connect jdbc:mysql://10.6.162.58/test_alpha --username pbd -P --table posts --hive-import --hive-database test_admin --hive-table posts1 --hive-drop-import-delims --null-string '\N' --null-non-string '\N' --target-dir test_hive_admin/2
It returns:
Both ways successful import data to hive but both fail import to HDFS.
For root, it don't create directory that I've defined "test_hive_root/2"
For admin, it's just create directory "test_hive_admin/2" but only "success" file that have been created not the data (usually when I import it to HDFS, it will create "success" file and 4 more file)
How I can solve this problem? Can sqoop import to HDFS and Hive?