Trouble getting hadoop connector to work

What format is your data? The hadoop connector expects everything to be in the hadoop Text format. You may need to run a M-R internal to get the data in the format the connector expects. There are some other options in sqoop itself, like generating the java sources and then editing from there.