thiscodeWorks - Organizing the best of code online

List view

#hdfs #bigdata #sqoop-list-databases-from-hadoop-terminal

DISPLAYING THE TABLE DATA USING SQOOP-EVAL I.E WE ARE FETCHING DATA FROM HADOOOP NOT FROM MYSQL

sqoop-eval \
--connect jdbc:mysql://quickstart.cloudera:3306/retail_db \
--username retail_dba \
--password cloudera \
-query "select product_id,product_image from products limit 2";

#hdfs #bigdata #sqoop-list-databases-from-hadoop-terminal

ACCESSING THE MYSQL/RDBMS TABLE USING THE ROOT USER FROM THE HADOOP TERMINAL

sqoop-list-tables --connect \
jdbc:mysql://quickstart.cloudera:3306/retail_db \
--username retail_dba \
--password cloudera

#hdfs #bigdata #sqoop-list-databases-from-hadoop-terminal

ACCESSING THE MYSQL/RDBMS DB FROM HADOOP USEING SQOOP

# this below ex is to demonstrate how to list the databases of mysql/redbms from hadoop cloudser i.e we are not log in to mysql/rdbms termial but directly from hadoop terminal only we are list the data bases;

# this scenario when we have to check the databases from hadoop terminal only 

[cloudera@quickstart ~]$ sqoop-list-databases \
--connect jdbd:mysql://quikcstart.cloudera:3306 \
--username retail_dba \
--passord cloudera

DISPLAYING THE TABLE DATA USING SQOOP-EVAL I.E WE ARE FETCHING DATA FROM HADOOOP NOT FROM MYSQL

ACCESSING THE MYSQL/RDBMS TABLE USING THE ROOT USER FROM THE HADOOP TERMINAL

ACCESSING THE MYSQL/RDBMS DB FROM HADOOP USEING SQOOP

Save snippets that work with our extensions