(Solved) : Part Project Various Queries Using Hive Pig Hadoop Streaming Schema Available Don T Forget Q29753114 . . .
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.sqlThe data is available at:http://rasinsrv07.cstcis.cti.depaul.edu/CSC553/data/ (we will useScale4)
Transform lineorder.tbl table into a comma-separated file: UseHive, Pig
In Hive (but not in Pig), you must expand all numeric fields to aminimum of 3 digits (i.e. 0=>000, 2=>002, 28=>028). InPig, you can keep the numbers as-is.
Expert Answer
Answer to Part Project Various Queries Using Hive Pig Hadoop Streaming Schema Available Don T Forget Q29753114 . . .
OR