{"id":7845,"date":"2018-02-10T13:27:33","date_gmt":"2018-02-10T13:27:33","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=7845"},"modified":"2021-12-07T12:16:31","modified_gmt":"2021-12-07T06:46:31","slug":"sqoop-supported-databases","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/","title":{"rendered":"Sqoop Supported Databases"},"content":{"rendered":"

Basically, we can not use every database out of the box, also some databases may be used in an inefficient manner in Sqoop<\/strong><\/a>. So, in this article, we will study Sqoop supported databases. Also, we mention the specific versions of databases for which Sqoop supports.<\/span><\/p>\n

So, let’s start Sqoop Supported Databases tutorial.<\/p>\n

What is Sqoop Supported Databases?<\/h3>\n

Basically, JDBC is a compatibility layer. However, that allows a program to access many different databases through a common API. Although slight differences in the SQL language spoken by each database may mean that we can not use every database out of the box, also some databases may be used in an inefficient manner in Sqoop.<\/p>\n

To be more specific, while we offer a connect string to Sqoop, it inspects the protocol scheme to determine appropriate vendor-specific logic to use. Moreover, Sqoop works automatically if Sqoop knows about a given database. Instead,\u00a0we may need to specify the driver class to load –driver.<\/p>\n

Basically, this will use a generic code path Although, that will use standard SQL to access the database. Likewise, It offers some databases with faster, non-JDBC-based access mechanisms. Though, these can enable\u00a0by specifying the –direct parameter.<\/p>\n

Let’s revise Sqoop Features<\/strong><\/a> & Sqoop Architecture\u00a0<\/strong><\/a>
\nMoreover, for the several Sqoop Supported databases, includes vendor-specific support:<\/p>\n\n\n\n\n\n\n\n\n
Database<\/b><\/td>\nversion<\/b><\/td>\n–direct support?<\/b><\/td>\nconnect string matches<\/b><\/td>\n<\/tr>\n
HSQLDB<\/span><\/td>\n1.8.0+<\/span><\/td>\nNo<\/span><\/td>\njdbc:hsqldb:*\/\/<\/span><\/td>\n<\/tr>\n
MySQL<\/span><\/td>\n5.0+<\/span><\/td>\nYes<\/span><\/td>\njdbc:mysql:\/\/<\/span><\/td>\n<\/tr>\n
Oracle<\/span><\/td>\n10.2.0+<\/span><\/td>\nNo<\/span><\/td>\njdbc:oracle:*\/\/<\/span><\/td>\n<\/tr>\n
PostgreSQL<\/span><\/td>\n8.3+<\/span><\/td>\nYes (import only)<\/span><\/td>\njdbc:postgresql:\/\/<\/span><\/td>\n<\/tr>\n
CUBRID<\/span><\/td>\n9.2+<\/span><\/td>\nNO<\/span><\/td>\njdbc:cubrid:*<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Although, we would like to specify that Sqoop may work with older versions of the databases listed.<\/span> Since we have only tested it with the versions specified above.<\/p>\n

Make sure you need to install the database vendor\u2019s JDBC driver in your $SQOOP_HOME\/lib path on your clientEen even if it Sqoop supports database internally.<\/span> Moreover, Sqoop can load classes from any jars in $SQOOP_HOME\/lib on the client. Also, will use them as part of any MapReduce<\/a><\/strong> jobs it runs. However, we no longer need to install JDBC jars in the Hadoop<\/strong> <\/a>library path on your servers, unlike older versions.<\/p>\n

Conclusion<\/h3>\n

As a result, we have seen all possible Sqoop supported databases.\u00a0Also, with information of specific versions. So, if you want to ask any query regarding, feel free to ask. we will definitely\u00a0respond.
\nSee Also- Sqoop Jobs<\/a><\/strong> & Sqoop Codegen<\/strong><\/a>
\nFor reference<\/a><\/strong>

Basically, we can not use every database out of the box, also some databases may be used in an inefficient manner in Sqoop. So, in this article, we will study Sqoop supported databases. Also,...<\/p>\n","protected":false},"author":9,"featured_media":7924,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68],"tags":[13672,13988],"class_list":["post-7845","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqoop","tag-sqoop-supported-databases","tag-supported-databases-in-sqoop"],"yoast_head":"\nSqoop Supported Databases - DataFlair<\/title>\n<meta name=\"description\" content=\"Sqoop Supported Databases - Specific versions of Supported Databases in Sqoop with examples, MySQL, Oracle, HSQLDB, PostgreSQL, CUBRID\" \/>\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-supported-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sqoop Supported Databases - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Sqoop Supported Databases - Specific versions of Supported Databases in Sqoop with examples, MySQL, Oracle, HSQLDB, PostgreSQL, CUBRID\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/\" \/>\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-10T13:27:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T06:46:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Supported-Databases-in-Sqoop-01-1.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=\"2 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sqoop Supported Databases - DataFlair","description":"Sqoop Supported Databases - Specific versions of Supported Databases in Sqoop with examples, MySQL, Oracle, HSQLDB, PostgreSQL, CUBRID","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-supported-databases\/","og_locale":"en_US","og_type":"article","og_title":"Sqoop Supported Databases - DataFlair","og_description":"Sqoop Supported Databases - Specific versions of Supported Databases in Sqoop with examples, MySQL, Oracle, HSQLDB, PostgreSQL, CUBRID","og_url":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-02-10T13:27:33+00:00","article_modified_time":"2021-12-07T06:46:31+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Supported-Databases-in-Sqoop-01-1.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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/6e11a88eea98179e861a0933f8959f8f"},"headline":"Sqoop Supported Databases","datePublished":"2018-02-10T13:27:33+00:00","dateModified":"2021-12-07T06:46:31+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/"},"wordCount":395,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Supported-Databases-in-Sqoop-01-1.jpg","keywords":["Sqoop Supported Databases","Supported Databases in Sqoop"],"articleSection":["Sqoop Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/","url":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/","name":"Sqoop Supported Databases - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Supported-Databases-in-Sqoop-01-1.jpg","datePublished":"2018-02-10T13:27:33+00:00","dateModified":"2021-12-07T06:46:31+00:00","description":"Sqoop Supported Databases - Specific versions of Supported Databases in Sqoop with examples, MySQL, Oracle, HSQLDB, PostgreSQL, CUBRID","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Supported-Databases-in-Sqoop-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Supported-Databases-in-Sqoop-01-1.jpg","width":1200,"height":628,"caption":"Introduction to Sqoop Supported Databases"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sqoop-supported-databases\/#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 Supported Databases"}]},{"@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\/7845","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=7845"}],"version-history":[{"count":6,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/7845\/revisions"}],"predecessor-version":[{"id":105308,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/7845\/revisions\/105308"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/7924"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=7845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=7845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=7845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}