Check out this post from Alan Gates, Pig architect at Yahoo!, that compares when would use a SQL like Hive rather than Pig. He makes a very convincing case as to the usefulness of a procedural language like Pig (vs. declarative SQL) and its utility to dataflow designers.
More Related Contents:
- What is the difference between partitioning and bucketing a table in Hive ?
- Difference between Hive internal tables and external tables?
- How to transpose/pivot data in hive?
- Sqoop import : composite primary key and textual primary key
- How to delete and update a record in Hive
- Hive unable to manually set number of reducers
- How to update table in Hive 0.13?
- how many mappers and reduces will get created for a partitoned table in hive
- Hive: Add partitions for existing folder structure
- How to load data to hive from HDFS without removing the source file?
- Loading Data from a .txt file to Table Stored as ORC in Hive
- Pig Latin: Load multiple files from a date range (part of the directory structure)
- Create HIVE Table with multi character delimiter
- Job queue for Hive action in oozie
- What is Hive: Return Code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
- Can Hive recursively descend into subdirectories without partitions or editing hive-site.xml?
- Hive Data Retrieval Queries: Difference between CLUSTER BY, ORDER BY, and SORT BY
- Merging multiple files into one within Hadoop
- Information about big data and hadoop [closed]
- Hive: Best way to do incremetal updates on a main table
- Execute Hive Query with IN clause parameters in parallel
- Container is running beyond memory limits
- Chaining multiple MapReduce jobs in Hadoop
- Pyspark: get list of files/directories on HDFS path
- Namenode not getting started
- What is the use of grouping comparator in hadoop map reduce
- Default number of reducers
- Difference between hadoop fs -put and hadoop fs -copyFromLocal
- Cannot Read a file from HDFS using Spark
- Hadoop WordCount example stuck at map 100% reduce 0%