You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by soham sardar <so...@gmail.com> on 2012/06/08 12:48:32 UTC

sqoop export problem from hdfs via hive

now i want to know abt the export in sqoop from hdfs ;


this is my hadoop fs
hduser@XPS-L501X:~$ hadoop fs -ls
Found 11 items
drwxr-xr-x   - hduser supergroup          0 2012-06-07 15:15
/user/hduser/_sqoop
drwxr-xr-x   - hduser supergroup          0 2012-06-06 15:16
/user/hduser/infor
drwxr-xr-x   - hduser supergroup          0 2012-06-06 15:20
/user/hduser/inform
drwxr-xr-x   - hduser supergroup          0 2012-06-06 15:56
/user/hduser/information
drwxr-xr-x   - hduser supergroup          0 2012-06-06 16:29
/user/hduser/inter
drwxr-xr-x   - hduser supergroup          0 2012-06-06 16:19
/user/hduser/intern
drwxr-xr-x   - hduser supergroup          0 2012-06-06 16:26
/user/hduser/interns
drwxr-xr-x   - hduser supergroup          0 2012-06-06 17:22
/user/hduser/inters
drwxr-xr-x   - hduser supergroup          0 2012-06-07 15:38
/user/hduser/logs-export
drwxr-xr-x   - hduser supergroup          0 2012-06-08 14:59
/user/hduser/user_audit
drwxr-xr-x   - hduser supergroup          0 2012-06-08 15:03
/user/hduser/users


and when i try to export a table with the command
ome/soham$ cd
*hduser@XPS-L501X:~$ sqoop export --connect jdbc:mysql://localhost:3306/hue
--table user_check  --username hues --password hadoop --export-dir
/user/hduser/user_audit
*
the export thing happens but the last lines are


*2/06/08 15:52:27 INFO mapred.JobClient:   Job Counters
12/06/08 15:52:27 INFO mapred.JobClient:     SLOTS_MILLIS_MAPS=2209
12/06/08 15:52:27 INFO mapred.JobClient:     Total time spent by all
reduces waiting after reserving slots (ms)=0
12/06/08 15:52:27 INFO mapred.JobClient:     Total time spent by all maps
waiting after reserving slots (ms)=0
12/06/08 15:52:27 INFO mapred.JobClient:     SLOTS_MILLIS_REDUCES=0
12/06/08 15:52:27 INFO mapreduce.ExportJobBase: Transferred 0 bytes in
4.1619 seconds (0 bytes/sec)
12/06/08 15:52:27 INFO mapreduce.ExportJobBase: Exported 0 records.*

it says 0 bytes are transferred

can some one help me with this please !!