{"id":7164,"date":"2018-02-03T06:47:43","date_gmt":"2018-02-03T06:47:43","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=7164"},"modified":"2021-12-07T13:13:43","modified_gmt":"2021-12-07T07:43:43","slug":"sqoop-eval","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/","title":{"rendered":"Sqoop Eval – Commands and Query Evaluation in Sqoop"},"content":{"rendered":"

Basically, to quickly run simple SQL queries against a database, we use Sqoop Eval tool in Sqoop<\/strong><\/a>. However, there are many more purposes Sqoop Eval offers. So, this Sqoop tutorial aims the whole concept of Sqoop Eval. After its introduction, we will also cover its syntax and its commands. Moreover, we will also cover its examples to understand it better. <\/span><\/p>\n

What is Sqoop Eval?<\/h3>\n

Basically, to quickly run simple SQL queries against a database server. Also to preview the result in the console, we use Sqoop Eval tool. Hence, as a user, we can expect the resultant table data to Sqoop import<\/strong><\/a>. Moreover, we can evaluate any type of SQL query. Either DDL or DML statement by using eval.<\/span><\/p>\n

Follow this link to know about Sqoop Export<\/strong><\/a><\/p>\n

Why Sqoop Eval?<\/h3>\n

As we discussed above, the main purpose\u00a0of eval tool is it allows users to quickly run simple SQL queries against a database. Afterwards, results are printed to the console. Also, it allows users to preview their Sqoop import<\/a> queries to ensure they import the data they expect.<\/span>
\n<\/b><\/p>\n

Note:<\/b> Basically, for evaluation purpose only, the eval tool is provided. Moreover, we can only use it to verify database connection from within the Sqoop. Also, to test simple queries. Likewise, we can not use Sqoop tool in production workflows.<\/span><\/p>\n

Sqoop Eval Syntax<\/h3>\n

$ sqoop eval (generic-args) (eval-args)
\n$ sqoop-eval (generic-args) (eval-args)
\nHowever, Sqoop eval arguments can be entered in any order with respect to one another, but the Hadoop<\/a>\u00a0<\/strong>generic arguments must precede any eval arguments only. <\/span><\/p>\n

a. Common arguments<\/h4>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Argument<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
–connect <jdbc-uri><\/span><\/td>\nSpecify JDBC connect string<\/span><\/td>\n<\/tr>\n
–connection-manager <class-name><\/span><\/td>\nSpecify connection manager class to use<\/span><\/td>\n<\/tr>\n
–driver <class-name><\/span><\/td>\nManually specify JDBC driver class to use<\/span><\/td>\n<\/tr>\n
–hadoop-mapred-home <dir><\/span><\/td>\nOverride $HADOOP_MAPRED_HOME<\/span><\/td>\n<\/tr>\n
–help<\/span><\/td>\nPrint usage instructions<\/span><\/td>\n<\/tr>\n
–password-file<\/span><\/td>\nSet path for a file containing the authentication password<\/span><\/td>\n<\/tr>\n
-P<\/span><\/td>\nRead password from console<\/span><\/td>\n<\/tr>\n
–password <password><\/span><\/td>\nSet authentication password<\/span><\/td>\n<\/tr>\n
–username <username><\/span><\/td>\nSet authentication username<\/span><\/td>\n<\/tr>\n
–verbose<\/span><\/td>\nPrint more information while working<\/span><\/td>\n<\/tr>\n
–connection-param-file <filename><\/span><\/td>\nOptional properties file that provides connection parameters<\/span><\/td>\n<\/tr>\n
–relaxed-isolation<\/span><\/td>\nSet connection transaction isolation to read uncommitted for the mappers.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

b. SQL evaluation arguments<\/h4>\n\n\n\n\n
Argument<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
-e,–query <statement><\/span><\/td>\nExecute statement in SQL.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Sqoop Eval Commands<\/h3>\n

a. For changing the directory to \/usr\/local\/hadoop\/sbin<\/span>
\n$ cd \/<\/strong>usr\/local\/<\/strong>hadoop\/<\/strong>sbin
\nb. To Start all Hadoop daemons<\/span>
\n$ start-all.sh<\/strong>
\nc.<\/span> The JPS(java virtual machine Process Status Tool) tool is limited to reporting information on JVMs for which it has the access Permissions<\/span>
\n$ <\/strong>jps
\nd. Change the directory to \/usr\/local\/Sqoop\/bin<\/span>
\n$ cd \/<\/strong>usr\/local\/sqoop\/bin<\/strong><\/p>\n

Select Query Evaluation in Sqoop Eval<\/h3>\n

As we discussed earlier, we can evaluate any type of SQL query by using eval tool. For example, \u00a0we are selecting limited rows in the employee table of DB database. Now, to evaluate the given example using SQL query we will use the following command.<\/span>
\n$ sqoop eval \\<\/b>
\n–connect jdbc:mysql:\/\/localhost\/db \\<\/b>
\n–username root \\ <\/b>
\n–query \u201cSELECT * FROM employee LIMIT 3\u201d<\/b>
\nMoreover, it will produce the following output on the terminal, if the command executes successfully.<\/span><\/p>\n\n\n\n\n\n\n
Id \u00a0\u00a0<\/strong><\/td>\nName<\/strong><\/td>\nDesignation<\/strong><\/td>\nSalary \u00a0\u00a0<\/strong><\/td>\nDept<\/strong><\/td>\n<\/tr>\n
1001<\/span><\/td>\njoe<\/span><\/td>\nmanager <\/span><\/td>\n50000<\/span><\/td>\nTP <\/span><\/td>\n<\/tr>\n
1002<\/span><\/td>\nchandler<\/span><\/td>\npreader<\/span><\/td>\n50000<\/span><\/td>\nTP <\/span><\/td>\n<\/tr>\n
1003<\/span><\/td>\nRoss<\/span><\/td>\nphp dev<\/span><\/td>\n30000<\/span><\/td>\nAC <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Insert Query Evaluation<\/h3>\n

Basically, for both modeling and defining the SQL statements, Sqoop eval tool can be applied. It refers that for insert statements too, we can use eval tool. Likewise, to insert a new row in the employee table of DB database we use the following command.<\/span>
\n$ sqoop eval \\<\/b>
\n–connect jdbc:mysql:\/\/localhost\/db \\<\/b>
\n–username root \\ <\/b>
\n-e \u201cINSERT INTO employee VALUES(1007,\u2018Gem\u2019,\u2018UI dev\u2019,15000,\u2018TP\u2019)\u201d<\/b><\/p>\n

Moreover, it will display the status of the updated rows on the console, if the command executes successfully.<\/span>
\nHowever, we can also verify the employee table on MySQL console. Moreover, using select\u2019 query we can verify the rows of employee table of DB database with the following Sqoop Eval command:<\/span>
\nmysql><\/b>
\nmysql> use DB;<\/b>
\nmysql> SELECT * FROM employee;<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n
Id<\/strong><\/td>\nName <\/strong><\/td>\nDesignation<\/strong><\/td>\nSalary <\/strong><\/td>\nDept<\/strong><\/td>\n<\/tr>\n
1001<\/span><\/td>\njoe<\/span><\/td>\nmanager <\/span><\/td>\n50000<\/span><\/td>\nTP <\/span><\/td>\n<\/tr>\n
1002<\/span><\/td>\nchandler<\/span><\/td>\npreader<\/span><\/td>\n50000<\/span><\/td>\nTP <\/span><\/td>\n<\/tr>\n
1003<\/span><\/td>\nRoss<\/span><\/td>\nphp dev<\/span><\/td>\n30000<\/span><\/td>\nAC <\/span><\/td>\n<\/tr>\n
1004<\/span><\/td>\nMike<\/span><\/td>\nphp dev<\/span><\/td>\n30000<\/span><\/td>\nAC<\/span><\/td>\n<\/tr>\n
1005<\/span><\/td>\nClay<\/span><\/td>\nadmin<\/span><\/td>\n20000<\/span><\/td>\nTP <\/span><\/td>\n<\/tr>\n
1006<\/span><\/td>\nHenna<\/span><\/td>\nGrp des<\/span><\/td>\n20000<\/span><\/td>\nGR<\/span><\/td>\n<\/tr>\n
1007<\/span><\/td>\nGem<\/span><\/td>\nUI dev<\/span><\/td>\n15000<\/span><\/td>\nTP <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Conclusion<\/h3>\n

As a result, we have seen the whole concept of Sqoop Eval. Also, we have seen Sqoop Eval purpose and its syntax. Moreover, we have seen all\u00a0Sqoop Eval Commands. Afterwards, we have also covered\u00a0Select Query Evaluation and\u00a0Insert Query Evaluation.<\/p>\n

However, still, if you feel anything is missing or if you want to ask any query regarding, feel free to ask in the comment section. We Ensure we will definitely get back to you.<\/p>\n

Learn Validation in Sqoop<\/a>\u00a0<\/strong>& Feature of Sqoop<\/a><\/strong>
\nFor reference<\/strong><\/a>

Basically, to quickly run simple SQL queries against a database, we use Sqoop Eval tool in Sqoop. However, there are many more purposes Sqoop Eval offers. So, this Sqoop tutorial aims the whole concept...<\/p>\n","protected":false},"author":9,"featured_media":7360,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68],"tags":[6742,7118,10250,13618,13619,13620,15980,16185],"class_list":["post-7164","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqoop","tag-insert-query-evaluation","tag-introduction-to-sqoop-eval","tag-purpose-of-sqoop-eval","tag-sqoop-eval-commands","tag-sqoop-eval-examples","tag-sqoop-eval-syntax","tag-what-is-sqoop-eval","tag-why-sqoop-eval"],"yoast_head":"\nSqoop Eval - Commands and Query Evaluation in Sqoop - DataFlair<\/title>\n<meta name=\"description\" content=\"Sqoop Eval- Syntax of Eval in Sqoop,purpose of Sqoop eval,Sqoop eval command, select & insert query evaluation in eval with syntax & sqoop eval example\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sqoop-eval\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sqoop Eval - Commands and Query Evaluation in Sqoop - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Sqoop Eval- Syntax of Eval in Sqoop,purpose of Sqoop eval,Sqoop eval command, select & insert query evaluation in eval with syntax & sqoop eval example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sqoop-eval\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-03T06:47:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T07:43:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Sqoop-Eval-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sqoop Eval - Commands and Query Evaluation in Sqoop - DataFlair","description":"Sqoop Eval- Syntax of Eval in Sqoop,purpose of Sqoop eval,Sqoop eval command, select & insert query evaluation in eval with syntax & sqoop eval example","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/","og_locale":"en_US","og_type":"article","og_title":"Sqoop Eval - Commands and Query Evaluation in Sqoop - DataFlair","og_description":"Sqoop Eval- Syntax of Eval in Sqoop,purpose of Sqoop eval,Sqoop eval command, select & insert query evaluation in eval with syntax & sqoop eval example","og_url":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-02-03T06:47:43+00:00","article_modified_time":"2021-12-07T07:43:43+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Sqoop-Eval-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/6e11a88eea98179e861a0933f8959f8f"},"headline":"Sqoop Eval – Commands and Query Evaluation in Sqoop","datePublished":"2018-02-03T06:47:43+00:00","dateModified":"2021-12-07T07:43:43+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/"},"wordCount":785,"commentCount":3,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Sqoop-Eval-01.jpg","keywords":["Insert Query Evaluation","Introduction to Sqoop Eval","purpose of sqoop eval","Sqoop Eval Commands","Sqoop eval examples","sqoop eval syntax","what is sqoop eval","why sqoop eval"],"articleSection":["Sqoop Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sqoop-eval\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/","url":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/","name":"Sqoop Eval - Commands and Query Evaluation in Sqoop - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Sqoop-Eval-01.jpg","datePublished":"2018-02-03T06:47:43+00:00","dateModified":"2021-12-07T07:43:43+00:00","description":"Sqoop Eval- Syntax of Eval in Sqoop,purpose of Sqoop eval,Sqoop eval command, select & insert query evaluation in eval with syntax & sqoop eval example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sqoop-eval\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Sqoop-Eval-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Sqoop-Eval-01.jpg","width":1200,"height":628,"caption":"Sqoop Eval - Introduction"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sqoop-eval\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Sqoop Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sqoop\/"},{"@type":"ListItem","position":3,"name":"Sqoop Eval – Commands and Query Evaluation in Sqoop"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/6e11a88eea98179e861a0933f8959f8f","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/54363d8635c383dcd7e3be0ef00dbeef4217c45bf323d27bc2c92366b724df08?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/54363d8635c383dcd7e3be0ef00dbeef4217c45bf323d27bc2c92366b724df08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/54363d8635c383dcd7e3be0ef00dbeef4217c45bf323d27bc2c92366b724df08?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"At DataFlair, our team of experts is committed to offering high-quality tutorials on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. We simplify learning to help you advance your career in the tech world.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam5\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/7164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=7164"}],"version-history":[{"count":6,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/7164\/revisions"}],"predecessor-version":[{"id":105348,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/7164\/revisions\/105348"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/7360"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=7164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=7164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=7164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}