{"id":1200,"date":"2021-07-22T06:52:07","date_gmt":"2021-07-22T06:52:07","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=1200"},"modified":"2021-09-08T09:36:36","modified_gmt":"2021-09-08T09:36:36","slug":"what-is-update-command-in-sqoop","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/","title":{"rendered":"What is update command in sqoop ?"},"content":{"rendered":"<div class=\"TextHeading\">\n<div class=\"hddn\">\n<h2 id=\"update-command-in-sqoop\" class=\"color-purple\">Update command in sqoop:<\/h2>\n<\/div>\n<\/div>\n<div class=\"row\">\n<div class=\"col-sm-12\">\n<div class=\"Content\">\n<div class=\"hddn\">\n<ul>\n<li>There are two approaches to update in sqoop.\n<ul>\n<li>The records inserted are to be added to the target table.<\/li>\n<li>The sqoop provides an update mode by providing \u201cupdate-key <column(s)>\u201d command.<\/li>\n<\/ul>\n<\/li>\n<li>This command is used to generate the SQl update statement.<\/li>\n<li>If the value in column 1 matches the data is updated else the data is inserted into the table.<\/li>\n<li>This technique is also refered to as upsert where the default action is update but insertion takes place when matching data is not available.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"CodeContent\">\n<div class=\"hddn\">\n<figure class=\"highlight\"><div class=\"code-embed-wrapper\"> <div class=\"code-embed-infos\"> <\/div> <pre class=\"language-markdown code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-markdown code-embed-code\">$ sqoop export (Generic Arguments)<br\/>  --table target-relational-table <br\/>  --update-key column1<br\/>  --export-dir \/user\/my-hdfs-file<br\/>  ...<br\/>Generates => UPDATE target-relational-table SET<br\/>                    column2=1000,column3=2000<br\/>\t\t          WHERE column1=100;<\/code><\/pre> <\/div><\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Answer : There are two approaches to update in sqoop&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8770],"tags":[195,971,365,214,289,291,205,8806,196,712,7039,286,8787,8786,207,208,493,483,972,1714,8808,8803,8805,1715,1713,8809,8807,210,200,974,197,8804,8802,280,364,968,216],"class_list":["post-1200","post","type-post","status-publish","format-standard","hentry","category-sqoop","tag-accenture-interview-questions-and-answers","tag-altimetrik-india-pvt-ltd-interview-questions-and-answers","tag-amazon-development-centre-india-pvt-ltd-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-ciber-global-solutions-interview-questions-and-answers","tag-datamatics-global-services-ltd-interview-questions-and-answers","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-how-will-you-update-the-rows-that-are-already-exported-in-sqoop","tag-ibm-interview-questions-and-answers","tag-indiabulls-technology-solutions-ltd-interview-questions-and-answers","tag-iris-software-interview-questions-and-answers","tag-lt-infotech-interview-questions-and-answers","tag-maxima-it-consulting-india-pvt-ltd-interview-questions-and-answers","tag-morningstar-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-quintiles-interview-questions-and-answers","tag-reliance-industries-ltd-interview-questions-and-answers","tag-sapient-consulting-pvt-ltd-interview-questions-and-answers","tag-sqoop-difficult-interview-questions","tag-sqoop-export-command","tag-sqoop-export-update-key-example","tag-sqoop-import-update","tag-sqoop-scenario-based-interview-questions","tag-sqoop-scenario-based-questions","tag-sqoop-update-mode","tag-sqoop-upsert","tag-symphony-teleca-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","tag-trigent-software-interview-questions-and-answers","tag-unitedhealth-group-interview-questions-and-answers","tag-update-mode-allow-insert","tag-update-mode-in-sqoop","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-wipro-infotech-interview-questions-and-answers","tag-wipro-interview-questions-and-answers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is update command in sqoop ? - Sqoop - Wikitechy<\/title>\n<meta name=\"description\" content=\"What is update command in sqoop ? - sqoop interview questions - There are two approaches to update in sqoop. The records inserted are to be added to the target table.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is update command in sqoop ? - Sqoop - Wikitechy\" \/>\n<meta property=\"og:description\" content=\"What is update command in sqoop ? - sqoop interview questions - There are two approaches to update in sqoop. The records inserted are to be added to the target table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-22T06:52:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-08T09:36:36+00:00\" \/>\n<meta name=\"author\" content=\"Editor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Editor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sqoop\\\/what-is-update-command-in-sqoop\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sqoop\\\/what-is-update-command-in-sqoop\\\/\"},\"author\":{\"name\":\"Editor\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"headline\":\"What is update command in sqoop ?\",\"datePublished\":\"2021-07-22T06:52:07+00:00\",\"dateModified\":\"2021-09-08T09:36:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sqoop\\\/what-is-update-command-in-sqoop\\\/\"},\"wordCount\":134,\"commentCount\":0,\"keywords\":[\"Accenture interview questions and answers\",\"Altimetrik India Pvt Ltd interview questions and answers\",\"Amazon Development Centre India Pvt Ltd interview questions and answers\",\"CGI Group Inc interview questions and answers\",\"Ciber Global Solutions interview questions and answers\",\"Datamatics Global Services Ltd interview questions and answers\",\"Dell International Services India Pvt Ltd interview questions and answers\",\"how will you update the rows that are already exported in sqoop\",\"IBM interview questions and answers\",\"Indiabulls Technology Solutions Ltd interview questions and answers\",\"Iris Software interview questions and answers\",\"L&amp;T Infotech interview questions and answers\",\"Maxima IT Consulting India Pvt Ltd interview questions and answers\",\"Morningstar interview questions and answers\",\"Mphasis interview questions and answers\",\"Prokarma Softech Pvt Ltd interview questions and answers\",\"Quintiles interview questions and answers\",\"Reliance Industries Ltd interview questions and answers\",\"Sapient Consulting Pvt Ltd interview questions and answers\",\"sqoop difficult interview questions\",\"sqoop export command\",\"sqoop export update-key example\",\"sqoop import update\",\"sqoop scenario based interview questions\",\"sqoop scenario based questions\",\"sqoop update mode\",\"sqoop upsert\",\"Symphony Teleca interview questions and answers\",\"Tech Mahindra interview questions and answers\",\"Trigent Software interview questions and answers\",\"UnitedHealth Group interview questions and answers\",\"update-mode allow insert\",\"update-mode in sqoop\",\"Virtusa Consulting Services Pvt Ltd interview questions and answers\",\"Wells Fargo interview questions and answers\",\"Wipro Infotech interview questions and answers\",\"Wipro interview questions and answers\"],\"articleSection\":[\"Sqoop\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sqoop\\\/what-is-update-command-in-sqoop\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sqoop\\\/what-is-update-command-in-sqoop\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sqoop\\\/what-is-update-command-in-sqoop\\\/\",\"name\":\"What is update command in sqoop ? - Sqoop - Wikitechy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"datePublished\":\"2021-07-22T06:52:07+00:00\",\"dateModified\":\"2021-09-08T09:36:36+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"description\":\"What is update command in sqoop ? - sqoop interview questions - There are two approaches to update in sqoop. The records inserted are to be added to the target table.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sqoop\\\/what-is-update-command-in-sqoop\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\",\"name\":\"Editor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"caption\":\"Editor\"},\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/editor\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is update command in sqoop ? - Sqoop - Wikitechy","description":"What is update command in sqoop ? - sqoop interview questions - There are two approaches to update in sqoop. The records inserted are to be added to the target table.","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:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/","og_locale":"en_US","og_type":"article","og_title":"What is update command in sqoop ? - Sqoop - Wikitechy","og_description":"What is update command in sqoop ? - sqoop interview questions - There are two approaches to update in sqoop. The records inserted are to be added to the target table.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/","og_site_name":"Wikitechy","article_published_time":"2021-07-22T06:52:07+00:00","article_modified_time":"2021-09-08T09:36:36+00:00","author":"Editor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Editor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/"},"author":{"name":"Editor","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"headline":"What is update command in sqoop ?","datePublished":"2021-07-22T06:52:07+00:00","dateModified":"2021-09-08T09:36:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/"},"wordCount":134,"commentCount":0,"keywords":["Accenture interview questions and answers","Altimetrik India Pvt Ltd interview questions and answers","Amazon Development Centre India Pvt Ltd interview questions and answers","CGI Group Inc interview questions and answers","Ciber Global Solutions interview questions and answers","Datamatics Global Services Ltd interview questions and answers","Dell International Services India Pvt Ltd interview questions and answers","how will you update the rows that are already exported in sqoop","IBM interview questions and answers","Indiabulls Technology Solutions Ltd interview questions and answers","Iris Software interview questions and answers","L&amp;T Infotech interview questions and answers","Maxima IT Consulting India Pvt Ltd interview questions and answers","Morningstar interview questions and answers","Mphasis interview questions and answers","Prokarma Softech Pvt Ltd interview questions and answers","Quintiles interview questions and answers","Reliance Industries Ltd interview questions and answers","Sapient Consulting Pvt Ltd interview questions and answers","sqoop difficult interview questions","sqoop export command","sqoop export update-key example","sqoop import update","sqoop scenario based interview questions","sqoop scenario based questions","sqoop update mode","sqoop upsert","Symphony Teleca interview questions and answers","Tech Mahindra interview questions and answers","Trigent Software interview questions and answers","UnitedHealth Group interview questions and answers","update-mode allow insert","update-mode in sqoop","Virtusa Consulting Services Pvt Ltd interview questions and answers","Wells Fargo interview questions and answers","Wipro Infotech interview questions and answers","Wipro interview questions and answers"],"articleSection":["Sqoop"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/","name":"What is update command in sqoop ? - Sqoop - Wikitechy","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"datePublished":"2021-07-22T06:52:07+00:00","dateModified":"2021-09-08T09:36:36+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"description":"What is update command in sqoop ? - sqoop interview questions - There are two approaches to update in sqoop. The records inserted are to be added to the target table.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/sqoop\/what-is-update-command-in-sqoop\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757","name":"Editor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","caption":"Editor"},"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/editor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/1200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=1200"}],"version-history":[{"count":2,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/1200\/revisions"}],"predecessor-version":[{"id":2987,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/1200\/revisions\/2987"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=1200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=1200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=1200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}