{"id":1861,"date":"2018-05-01T23:08:07","date_gmt":"2018-05-01T21:08:07","guid":{"rendered":"http:\/\/van-maanen.com\/?p=1861"},"modified":"2018-05-01T23:08:07","modified_gmt":"2018-05-01T21:08:07","slug":"sqoop-2","status":"publish","type":"post","link":"http:\/\/archief.van-maanen.com\/?p=1861","title":{"rendered":"Sqoop"},"content":{"rendered":"<p>Sqoop is used in an Hadoop environment to load data from a relational database upon an Hadoop platform. I have installed an Oracle 12.2 database. I tried to load data from that database to Hadoop. To do so, one needs to install a java jdbc driver to be able to access that database. For Oracle 12, two drivers are available: the ojdbc6.jar and the ojdbc7.jar. Both seem to work fine. I established this by putting both files on the \/opt\/cloudera\/parcels\/CDH\/lib\/sqoop\/lib, which is used in a Cloudera environment to install the database drivers for sqoop. Subsequently, I verified the correct working with:<\/p>\n<pre>\nsqoop list-tables \\\n--connect jdbc:oracle:thin:@192.168.2.2:1521:orcl \\\n--username c##hr \\\n--password ine13258\n<\/pre>\n<p>I also tried to use ojdbc8.jar, but this provided an error, saying &#8220;Unsupported major.minor version 52.0&#8221;.<\/p>\n<p>A similar exercise can be undertaken with mysql:<\/p>\n<pre>\nsqoop list-tables \\\n--connect jdbc:mysql:\/\/192.168.2.2\/wordpress \\\n--username tom \\\n--password ine13258\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Sqoop is used in an Hadoop environment to load data from a relational database upon an Hadoop platform. I have installed an Oracle 12.2 database. I tried to load data from that database to Hadoop. To do so, one needs to install a java jdbc driver to be able to access that database. For Oracle [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1861","post","type-post","status-publish","format-standard","hentry","category-allgemein"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/1861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1861"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/1861\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1861"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}