Update command in sqoop:<\/h2>\n<\/div>\n<\/div>\n

\n

\n

\n

\n

\n
• There are two approaches to update in sqoop.\n
  \n
  • The records inserted are to be added to the target table.<\/li>\n
  • The sqoop provides an update mode by providing \u201cupdate-key <column(s)>\u201d command.<\/li>\n<\/ul>\n<\/li>\n
  • This command is used to generate the SQl update statement.<\/li>\n
  • If the value in column 1 matches the data is updated else the data is inserted into the table.<\/li>\n
  • 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
    \n

    \n

    <\/div>

    $ sqoop export (Generic Arguments)  --table target-relational-table   --update-key column1  --export-dir \/user\/my-hdfs-file  ...Generates => UPDATE target-relational-table SET                    column2=1000,column3=2000\t\t          WHERE column1=100;<\/code><\/pre> <\/div><\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
    Answer : There are two approaches to update in sqoop…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"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":"\n