How are you guys practicing SQOOP

#1

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.

0 Likes

#2

@Pruthvi_Konda

sample, rest of them you can follow in itversity.com

sqoop import
–connect “jdbc:mysql://nn01.itversity.com:3306/retail_db”
–username retail_dba
–password itversity \

0 Likes

#3

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

0 Likes

#4

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

if you are using Cloudera quick-start sandbox

0 Likes

#5

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

0 Likes

#6

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

0 Likes

#7

$mysql -u retail_dba -p Itversity

0 Likes

#8

mysql -u retail_dba -h nn01.itversity.com -p itversity

0 Likes

#9

above is not working @gnanaprakasam

0 Likes

#10

@gnanaprakasam: I’m getting following error

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

0 Likes

#11

mysql -u retail_dba -h nn01.itversity.com -p

when password prompted type itversity

1 Like

#12

got it. Thanks @gnanaprakasam :slight_smile:

0 Likes

#13

Receiving this error while trying to run mysql query

16/12/06 16:10:46 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.5.0.0-1245
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

0 Likes

#14

@Pruthvi_Konda - Could you please past the query ?

0 Likes