Solution reporttransfer the files into hdfs whether the file transferred not table part the hive data part from hdfs statements for rows from table partcreate table supplier the hive data supplier from hdfsselect statements for rows from table suppliercreate table partsupp the hive data partsupp from hdfs statements for rows from table partsupp
Create table PART in the hive.
Create table SUPPLIER in the hive.
Create table PARTSUPP in the hive.