question SQOOP - MYSQL - Practice test instance in Support Questions

SQOOP - MYSQL - Practice test instance

vidyaranya_kupp — Wed, 06 Jan 2016 11:32:30 GMT

I am working on HDPCD practice test instance. Can anybody let me know -

a) Is there anything I should do before issue sqoop command on AWS practice instance.

b) what is the parameter I should use for --connect jdbc:?????

Re: SQOOP - MYSQL - Practice test instance

KuldeepK — Wed, 06 Jan 2016 11:58:22 GMT

@Vidya SK

Run below command to list the tables:

sqoop list-tables --connect jdbc:mysql://<mysql-server>/database --username <username> --password <password>

Re: SQOOP - MYSQL - Practice test instance

vidyaranya_kupp — Wed, 06 Jan 2016 12:00:17 GMT

what is the value for <MySQL-server> on practice instance?

Re: SQOOP - MYSQL - Practice test instance

vidyaranya_kupp — Wed, 06 Jan 2016 12:02:23 GMT

@Kuldeep Kulkarni

what is the value for <MySQL-server> on practice instance?

Re: SQOOP - MYSQL - Practice test instance

KuldeepK — Wed, 06 Jan 2016 12:04:40 GMT

@Vidya SK - Goto Ambari UI -> select Hive service -> you should see mysql server there -> just point your mouse arrow over the link and you should get the name of mysql server

you will get it in hive-site.xml

grep -A 2 mysql /etc/hive/conf/hive-site.xml

Re: SQOOP - MYSQL - Practice test instance

vidyaranya_kupp — Mon, 19 Aug 2019 12:19:29 GMT

@Kuldeep Kulkarni

Thanks Kuldeep.

With the above grep command, I got the following:

Sqoop Command:

I am getting following error. Please suggest.

Re: SQOOP - MYSQL - Practice test instance

KuldeepK — Thu, 07 Jan 2016 13:47:50 GMT

@Vidya SK - you are getting access denied exception that means user root does not have access to mysql DB using password 'hadoop'. please check your password and try again with valid username and password

Re: SQOOP - MYSQL - Practice test instance

Shelton — Thu, 07 Jan 2016 14:42:28 GMT

Just reset the root password I had to reset the MySQL password to do so follow the below process.Start the DB if its down

[root@sandbox]# service mysqld start

Starting mysqld: [ OK ]

Reset the MySQL password

[root@sandbox]# mysqladmin -u root -h sandbox.hortonworks.com password 'newpassword'

[root@sandbox]# mysqladmin -u root password 'newpassword'

Try out the new password and it seems to work out well

[root@sandbox]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 6

Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select user();

After validating the successful logon retry

Re: SQOOP - MYSQL - Practice test instance

aervits — Wed, 03 Feb 2016 03:24:20 GMT

@rich @Vidya SK are you still having issues with this? Can you accept best answer or provide your own solution?

Re: SQOOP - MYSQL - Practice test instance

vidyaranya_kupp — Thu, 04 Feb 2016 03:34:53 GMT

@Artem Ervits

During the HDPCD exam, do we have to do this initial set up like - set up user, grant access etc. before we use sqoop commands? Or are these already taken care and we just run sqoop commands? If some access is not working can we ask the proctor to stop the clock and set up the required environment?

Re: SQOOP - MYSQL - Practice test instance

aervits — Thu, 04 Feb 2016 03:57:58 GMT

@rich can help with HDPCD related questions

Re: SQOOP - MYSQL - Practice test instance

vidyaranya_kupp — Thu, 04 Feb 2016 04:18:05 GMT

@rich

Re: SQOOP - MYSQL - Practice test instance

rich1 — Thu, 04 Feb 2016 05:44:42 GMT

Everything is configured perfectly fine on the real exam for Sqoop to work. It's also configured correctly on the practice exam. If you are having trouble getting the command to work, the solution is in the /home/horton/solutions folder on the Ubuntu instance. Try running the solution. If that fails, please share the error and I can help you from there.

Re: SQOOP - MYSQL - Practice test instance

rich1 — Thu, 04 Feb 2016 05:45:49 GMT

The server name is namenode

Re: SQOOP - MYSQL - Practice test instance

nsabharwal — Thu, 04 Feb 2016 05:52:29 GMT

@rich I have accepted this as best answer.

Re: SQOOP - MYSQL - Practice test instance

vidyaranya_kupp — Thu, 04 Feb 2016 06:42:42 GMT

@rich

I ran the sqoop command. I get the following error msg. Please look at the screen shot. Thanks.

sqoop.png

Re: SQOOP - MYSQL - Practice test instance

rich1 — Thu, 04 Feb 2016 07:16:41 GMT

You spelled "input-fields-terminated-by" incorrectly. I would bet that it will work once you fix that.

Re: SQOOP - MYSQL - Practice test instance

vidyaranya_kupp — Sat, 06 Feb 2016 07:11:16 GMT

@rich

Thanks rich. your solution worked out. I accept this answer.