Looking for a working mysql import sqoop command line

2012-05-12 Thread David Morel
Hi everyone, I must say I'm only starting, and this is on cdh3u3. I'm struggling with the sqoop options ATM, trying to import mysql tables to hive, containing tabs, newlines, and all sorts of things. I cannot figure out a proper combination of options on the sqoop command line to turn these

Re: Looking for a working mysql import sqoop command line

2012-05-12 Thread Arvind Prabhakar
Hi David, A typical MySQL import will look like: $ sqoop import --connect jdbc:mysql://localhost/mydb --username user --password pswd --table mytable Depending upon what you are trying to do and the datatypes that you have in your MySQL table, you may have to provide different options. If you