Last active
July 17, 2018 16:09
-
-
Save dgadiraju/bd44034324d683dbdf908587bc5a26d5 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sqoop eval \ | |
--connect jdbc:mysql://ms.itversity.com:3306/retail_db \ | |
--username retail_user \ | |
--password itversity \ | |
--query "SELECT * FROM order_items LIMIT 10" | |
sqoop eval \ | |
--connect jdbc:mysql://ms.itversity.com:3306/retail_db \ | |
--username retail_user \ | |
--password itversity \ | |
--query "INSERT INTO orders VALUES (100000, '2017-10-31 00:00:00.0', 100000, 'DUMMY')" | |
sqoop eval \ | |
--connect jdbc:mysql://ms.itversity.com:3306/retail_export \ | |
--username retail_user \ | |
--password itversity \ | |
--query "CREATE TABLE dummy (i INT)" | |
sqoop eval \ | |
--connect jdbc:mysql://ms.itversity.com:3306/retail_export \ | |
--username retail_user \ | |
--password itversity \ | |
--query "INSERT INTO dummy VALUES (1)" | |
sqoop eval \ | |
--connect jdbc:mysql://ms.itversity.com:3306/retail_export \ | |
--username retail_user \ | |
--password itversity \ | |
--query "SELECT * FROM dummy" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment