Note that Hive only supports equi-joins. Also it is best to put the largest table on the rightmost side of the join to get the best performance.

hive
join

mogwaing のブックマーク 2012/01/24 10:16

<blockquote class="hatena-bookmark-comment"><a class="comment-info" href="https://b.hatena.ne.jp/entry/77387125/comment/mogwaing" data-user-id="mogwaing" data-entry-url="https://b.hatena.ne.jp/entry/s/cwiki.apache.org/confluence/display/Hive/Tutorial" data-original-href="https://cwiki.apache.org/confluence/display/Hive/Tutorial" data-entry-favicon="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FHive%2FTutorial" data-user-icon="/users/mogwaing/profile.png">Tutorial - Apache Hive - Apache Software Foundation</a><ul class="comment-tag" style="list-style: none; margin: 0px;"><li style="float: left">[<a href="https://b.hatena.ne.jp/q/hive">hive</a>]</li><li style="float: left">[<a href="https://b.hatena.ne.jp/q/join">join</a>]</li></ul><br><p style="clear: left"> Note that Hive only supports equi-joins. Also it is best to put the largest table on the rightmost side of the join to get the best performance.</p><a class="datetime" href="https://b.hatena.ne.jp/mogwaing/20120124#bookmark-77387125"><span class="datetime-body">2012/01/24 10:16</span></a></blockquote><script src="https://b.st-hatena.com/js/comment-widget.js" charset="utf-8" async></script>

このブックマークにはスターがありません。
最初のスターをつけてみよう！

Tutorial - Apache Hive - Apache Software Foundation

cwiki.apache.org2011/07/06

ConceptsWhat Is HiveHive is a data warehousing infrastructure based on Apache Hadoop. Hadoop provides massive scale out and fault tolerance capabilities for data storage and processing on commodity...

9 人がブックマーク・1 件のコメント

他のコメントを読む

＼コメントがサクサク読めるアプリです／

はてなブックマーク

Tutorial - Apache Hive - Apache Software Foundation

はてなブックマーク

公式Twitter

はてなのサービス