Post by Admin on Mar 14, 2014 18:49:46 GMT
Hive vs Pig
Hive Pig
1. Language is SQL-Like 1. Language is Pig Latin.
2. Schema: Table definitions that are stored 2. A Schema is optionally defined at runtime. in a meta store.
3. Hire programatical access is JDBE, ODBC 3. Pig access is Pig server.
4. In the Hire have partitions. 4. There is no partitions.
5. Server is optional (Thrift) 5. No server.
6. UDFS (Java) 6. UDFS (Java)
7. Custom serializer / Deserializer. 7. Custom serializer / Deserializer.
8. DFS direct access at run time. 8. DFS direct access at default.
9. Join/Order/Set is possible 9. Join/Order/Set is possible.
10. Shell command Interface is possible. 10. Shell command interface have.
11. Streaming is supported. 11. Streaming is supported.
12. Web Interface is possible 12. There is no Web Interface.
Hive Pig
1. Language is SQL-Like 1. Language is Pig Latin.
2. Schema: Table definitions that are stored 2. A Schema is optionally defined at runtime. in a meta store.
3. Hire programatical access is JDBE, ODBC 3. Pig access is Pig server.
4. In the Hire have partitions. 4. There is no partitions.
5. Server is optional (Thrift) 5. No server.
6. UDFS (Java) 6. UDFS (Java)
7. Custom serializer / Deserializer. 7. Custom serializer / Deserializer.
8. DFS direct access at run time. 8. DFS direct access at default.
9. Join/Order/Set is possible 9. Join/Order/Set is possible.
10. Shell command Interface is possible. 10. Shell command interface have.
11. Streaming is supported. 11. Streaming is supported.
12. Web Interface is possible 12. There is no Web Interface.