Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

When i am using cmd, grunt> explain student_relation; , It shows Logical,Physical and MR Plan.What is exact mean of these plans and how they are used.

avatar
Expert Contributor
 
1 ACCEPTED SOLUTION

avatar
Master Mentor

Please see this https://pig.apache.org/docs/r0.15.0/test.html#explai

Use the EXPLAIN operator to review the logical, physical, and map reduce execution plans that are used to compute the specified relationship.

If no script is given:

  • The logical plan shows a pipeline of operators to be executed to build the relation. Type checking and backend-independent optimizations (such as applying filters early on) also apply.
  • The physical plan shows how the logical operators are translated to backend-specific physical operators. Some backend optimizations also apply.
  • The mapreduce plan shows how the physical operators are grouped into map reduce jobs.

View solution in original post

2 REPLIES 2

avatar
Master Mentor

Please see this https://pig.apache.org/docs/r0.15.0/test.html#explai

Use the EXPLAIN operator to review the logical, physical, and map reduce execution plans that are used to compute the specified relationship.

If no script is given:

  • The logical plan shows a pipeline of operators to be executed to build the relation. Type checking and backend-independent optimizations (such as applying filters early on) also apply.
  • The physical plan shows how the logical operators are translated to backend-specific physical operators. Some backend optimizations also apply.
  • The mapreduce plan shows how the physical operators are grouped into map reduce jobs.

avatar
Expert Contributor

thanks @Artem Ervits