APACHE PIG ~ ALL SAMPLE TABLES and STRUCTURES

APACHE PIG ~ ALL SAMPLE TABLES and STUCTURES: 
Here are the Data Tables samples and structures use throughout the blog posts for your review.


Employees data table/structure::
(empno, ename, job, manager, joining data,salary,commission, deptno)


Department data table/structure::
(deptno, dname, location)


Users data table/structure::
(userid,uname, idfy, col1, col2)



Students data table/structure:
(student_id, st_name, st_middle_name,st_city_state,st_contact_nbr,st_gender,st_nbr1,st_nbr2,st_gpa,st_specialization)


Students Update data table/structure::
(student_id, st_course1,st_course_grade1,st_course_credit1, st_course2, st_course_grade2,
st_course_credit2,st_course3,st_course_grade3,st_course_credit3,st_course4,st_course_grade4,
st_course_credits4,st_course5,st_course_grade5,st_course_credits5)


Inventory data table/structure:
(inv_id, col1, price, qty, inv_name )