mySQL query Error in itversity Lab


#1

Getting the following Error while executing the mysql query:

MySQL [retail_db]> sqoop eval --connect “jdbc:mysql://nn01.itversity.com:3306/retail_db” --username retail_dba --password i
tversity --query “select count(1) from orders”;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near ‘sqoop eval --connect “jdbc:mysql://nn01.itversity.com:3306/retail_db” --usernam’ at line 1


#2

@HamidHassan

You have to execute the command from the console, not from MySQL prompt.

image


#3