Home >> Big Data Hadoop >> Sqoop Eval in Big Data Hadoop

Sqoop Eval in Big Data Hadoop

Can evaluate any type of SQL query.

sqoop eval --connect jdbc:mysql://localhost:3306/db --driver com.mysql.jdbc.Driver --username root --query “select * from employee limit 3”

Insert:

sqoop eval --connect jdbc:mysql://localhost:3306/db --driver com.mysql.jdbc.Driver --username root -password root -e “insert into employee values (1107,‘chandra’,‘UI dev’,15000,‘TP’)”

List database:

sqoop list-databases --connect jdbc:mysql://localhost:3306/db --driver com.mysql.jdbc.Driver --username root -password root

List Table:

sqoop list-tables --connect jdbc:mysql://localhost:3306/db --driver com.mysql.jdbc.Driver --username root -password root

 

Post Your Comment

Next Questions
Sqoop import command
Sqoop import table with columns
Sqoop incremental import
Sqoop import all tables
Sqoop export command
Sqoop import export key word
Sqoop Job
Sqoop Codegen
Sqoop job scheduling
Sqoop cron Job
Sqoop cron job example
Hive Prerequisites
Hive Installation
What is Hive
Hive MapReduce Execution
Features of Hive
Hive Architecture
Configuring Metastore of Hive
Hive vs Hadoop
Hive Create Database
Hive Internal and External Table
Hive Internal Table
Drawback of Hive Internal/Managed Table
HIve External Table
Hive DDL

Copyright ©2022 coderraj.com. All Rights Reserved.