In this part of the project, you will various queries usingHive, Pig and Hadoop streaming. The schema is available below, butdon’t 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 useScale4)
Transform lineorder.tbl table into a comma-separated file: UseMapReduce with HadoopStreaming In Hadoop streaming , you mustexpand all numeric fields to a minimum of 3 digits (i.e. 0=>000,2=>002, 28=>028).
Expert Answer
An answer will be send to you shortly. . . . .