1. UPLOAD THE DATA FILE INTO HDFS

2. CREATE TABLES FOR THE DATA WITH HIVE AND HCATALOG
  CREATE TABLE mytable 
  (col1 int, col2 string)
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY ','

3. Now  load the data file into the table. Use the following command to do so.

  LOAD DATA INPATH '/path/to/data' OVERWRITE INTO TABLE mytable

4. EXPLORE PIG LATIN DATA TRANSFORMATION

The data is already in HDFS through HCatalog. HCatalog stores schema and
location information, so we can use the HCatLoader() function within the
Pig script to read data from HCatalog-managed tables.

Please refer below screen shot to use HCatLoader in Hortonworks