Tutorial - Apache Hive - Apache Software Foundation

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 hardware. Hive is designed to enable easy data summarization, ad-hoc querying and analysis of large volumes of data. It provides SQL which enables users to do ad-hoc querying, summarization and data ana

[mogwaing]

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.