Consider the following two$-$dimensional data cube.

The data cube contains information about that parts that can be shipped by the suppliers.

Download and unzip a file task$4.$zip. You should obtain a folder task$4$ with the

following files: part.tbl$,$ supplier.tbl$,$ partsupp.tbl$.$

Use an editor to examine the contents of $*.$tbl files. Note, that the contents of the files

can be loaded into the relational tables obtained from the transformation of the two$-$

dimensional data cube given above into the relational table PART, SUPPLIER, and

PARTSUPP.

Transfer the files into HDFS$.$

Implement HQL script solution$4.$hql that creates the external tables obtained from

a step of logical design performed earlier. The external tables must overlap on the files

transferred to HDFS in the previous step. Note, that a header in each $*.$tbl file must be

removed before creating the external tables.

Include into solution$4.$hql script SELECT statements that any $5$ rows from each

one of the external tables implemented in the previous step and the total number of rows

included in each table.

When ready, use a command line interface beeline to process a script

solution$4.$hql and to save a report from processing in a file solution$4.$rpt$.$