In this part of the project, you will various queries using Hive, Pig and Hadoop streaming. The schema is available below, but dont forget to apply the correct delimiter: http://rasinsrv07.cstcis.cti.depaul.edu/CSC555/SSBM1/SSBM_schema_hive.sql The data is available at: http://rasinsrv07.cstcis.cti.depaul.edu/CSC553/data/ (we will use Scale4)

Transform lineorder.tbl table into a comma-separated file: Use Hive, Pig In Hive (but not in Pig), you must expand all numeric fields to a minimum of 3 digits (i.e. 0=>000, 2=>002, 28=>028). In Pig, you can keep the numbers as-is.