How are you guys practicing SQOOP

From the videos, the jdbc connector is from cloudera. For itversity tutorials, how are we supposed to run the eval command. Also, what do we give as username and password. Sorry, please help. I followed earlier posts but that wasn’t helping me. giving me errors.


sample, rest of them you can follow in

sqoop import
–connect “jdbc:mysql://”
–username retail_dba
–password itversity \

Thanks man. What about mysql ? mysql -u (then what?)

@Pruthvi_Konda, For mysql
$mysql -u retail_dba -p cloudera
$ mysql -u (username) -p (password)

if you are using Cloudera quick-start sandbox

I’ m currently using Itversity console. not cloudera @dksrinivasa

ok, Then it should be, $mysql -u retail_dba -p Itversity

$mysql -u retail_dba -p Itversity

mysql -u retail_dba -h -p itversity

above is not working @gnanaprakasam

@gnanaprakasam: I’m getting following error

ERROR 1045 (28000): Access denied for user ‘retail_dba’@‘’ (using password: YES)

mysql -u retail_dba -h -p

when password prompted type itversity

1 Like

got it. Thanks @gnanaprakasam :slight_smile:

Receiving this error while trying to run mysql query

16/12/06 16:10:46 INFO sqoop.Sqoop: Running Sqoop version:
16/12/06 16:10:46 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
16/12/06 16:10:46 ERROR tool.BaseSqoopTool: Error parsing arguments for list-tables:
16/12/06 16:10:46 ERROR tool.BaseSqoopTool: Unrecognized argument: --query
16/12/06 16:10:46 ERROR tool.BaseSqoopTool: Unrecognized argument: select count(1) from order_items

@Pruthvi_Konda - Could you please past the query ?