{"id":6868,"date":"2013-10-09T17:13:35","date_gmt":"2013-10-09T17:13:35","guid":{"rendered":"http:\/\/mcslp.wordpress.com\/?p=9968"},"modified":"2013-10-09T17:13:35","modified_gmt":"2013-10-09T17:13:35","slug":"sql-to-hadoop-and-back-again-part-2-leveraging-hbase-and-hive","status":"publish","type":"post","link":"https:\/\/planet.mcb.guru\/?p=6868","title":{"rendered":"SQL to Hadoop and back again, Part 2: Leveraging HBase and Hive"},"content":{"rendered":"<p>The second article in a series covering Big Data and SQL interaction is available now:<\/p>\n<p>&#8220;Big data&#8221; is a term that has been used regularly now for almost a decade, and it \u2014 along with technologies like NoSQL \u2014 are seen as the replacements for the long-successful RDBMS solutions that use SQL. Today, DB2\u00ae, Oracle, Microsoft\u00ae SQL Server MySQL, and PostgreSQL dominate the SQL space and still make up a considerable proportion of the overall market. Here in Part 2, we will concentrate on how to use HBase and Hive for exchanging data with your SQL data stores. From the outside, the two systems seem to be largely similar, but the systems have very different goals and aims. Let\\&#8217;s start by looking at how the two systems differ and how we can take advantage of that in our big data requirements.<\/p>\n<p><a href=\"http:\/\/www.ibm.com\/developerworks\/library\/bd-sqltohadoop2\/index.html\">SQL to Hadoop and back again, Part 2: Leveraging HBase and Hive<\/a>.<\/p><br \/>  <a rel=\"nofollow\" href=\"http:\/\/feeds.wordpress.com\/1.0\/gocomments\/mcslp.wordpress.com\/9968\/\"><img alt=\"\" border=\"0\" src=\"http:\/\/feeds.wordpress.com\/1.0\/comments\/mcslp.wordpress.com\/9968\/\" \/><\/a> <img alt=\"\" border=\"0\" src=\"http:\/\/stats.wordpress.com\/b.gif?host=mcslp.wordpress.com&#038;blog=164882&%23038;post=9968&%23038;subd=mcslp&%23038;ref=&%23038;feed=1\" width=\"1\" height=\"1\" \/>","protected":false},"excerpt":{"rendered":"<p>The second article in a series covering Big Data and SQL interaction is available now: &#8220;Big data&#8221; is a term that has been used regularly now for almost a decade, and it \u2014 along with technologies like NoSQL \u2014 are &#8230; <a href=\"http:\/\/mcslp.wordpress.com\/2013\/10\/09\/sql-to-hadoop-and-back-again-part-2-leveraging-hbase-and-hive\/\">Continue reading <span>&#8594;<\/span><\/a><img loading=\"lazy\" decoding=\"async\" alt=\"\" border=\"0\" src=\"http:\/\/stats.wordpress.com\/b.gif?host=mcslp.wordpress.com&amp;blog=164882&amp;post=9968&amp;subd=mcslp&amp;ref=&amp;feed=1\" width=\"1\" height=\"1\" \/><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86,87,75],"tags":[42,57],"_links":{"self":[{"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/posts\/6868"}],"collection":[{"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6868"}],"version-history":[{"count":1,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/posts\/6868\/revisions"}],"predecessor-version":[{"id":6870,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=\/wp\/v2\/posts\/6868\/revisions\/6870"}],"wp:attachment":[{"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/planet.mcb.guru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}