Pig:<\/span><\/h2>\n<\/div>\n<\/div>\n

\n

\n

\n
• Pig is a platform for managing large data.<\/li>\n
• It uses high level programming to analyse the data.<\/li>\n
• The programming is done using the language pig latin.<\/li>\n
• It is simple and highly specific.<\/li>\n
• The pig Metastore stores all info about the tables. And we can execute spark sql queries because spark can interact with pig Metastore<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
  \n

  Sqoop:<\/h2>\n<\/div>\n

  \n

  \n

  \n
  • Sqoop is a simple tool used for transferring large amount of data.<\/li>\n
  • It is used for transferring data from hadoop to relational database.<\/li>\n
  • sqoop can import data from Oracle,MYSQL,SQl.<\/li>\n
  • Sqoop metastore is a tool for using hosts in a shared metadata repository. Multiple users and remote users execute saved jobs in metastore.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
    \n

    <\/div>\n<\/div>\n

    \n

    \n

    <\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Answer : Sqoop is a simple tool used for transferring large amount of data…<\/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,499,636,504,196,712,7039,286,8787,8786,207,501,8819,500,503,502,8818,208,493,483,972,1714,1705,1711,1710,1715,1713,210,200,974,197,280,364,8817,968,216],"class_list":["post-1203","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-difference-between-sqoop-and-hive","tag-hive-vs-pig-vs-hbase","tag-hive-vs-pig-vs-spark","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-pig-and-hive-tutorial","tag-pig-and-sqoop-tutorial","tag-pig-hive-sqoop-flume","tag-pig-vs-hive-comparison","tag-pig-vs-hive-performance","tag-pig-vs-sqoop-performance","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-incremental-import-with-query","tag-sqoop-incremental-load-example","tag-sqoop-incremental-update-example","tag-sqoop-scenario-based-interview-questions","tag-sqoop-scenario-based-questions","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-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-what-is-pig-and-hive","tag-wipro-infotech-interview-questions-and-answers","tag-wipro-interview-questions-and-answers"],"yoast_head":"\n