Sqoop Eval - Sqoop

What is the Sqoop ‘eval’ tool?

Sqoop Eval I tool s used to execute user-defined queries against respective database servers and preview the result in the console. So it import the resultant table, we can also evaluate any type of SQL query that can be either DDL or DML statement.

Syntax

The following syntax is used for Sqoop eval command.

Select Query Evaluation

Eval tool enables to evaluate any type of SQL query. Here’s an example of selecting limited rows in the employee table of db database. Below command is used to evaluate the given example using SQL query.
After successful execution of the command, it will produce the below output:

Insert Query Evaluation

Sqoop eval tool is useful for both modeling and defining the SQL statements. So, we can use eval for insert statements too. Below mentioned command is used to insert a new row in the employee table of db database.
After successful execution of the command it will display the status of the updated rows on the console.
Below mentioned command is used to verify the rows of employee table of db database using select’ query.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Sqoop Topics