AnsweredAssumed Answered

Error while joining relations in Pig - "Unable to open iterator for alias"

Question asked by iamavnish on Sep 28, 2017
Latest reply on Oct 2, 2017 by cathy

I am joining two relations and getting below error:

ERROR 1066: Unable to open iterator for alias joined 

Here is the list of pig commands I am running:

  1. customers = load '/home/avnish/customer_data.csv' using PigStorage(',') as (Customer_ID:int,First_Name:chararray,Second_Name:chararray,Contact_No:Long,Created_Date:chararray,Email_ID:chararray);
  2. orders = load '/home/avnish/order_data.csv' using PigStorage(',') as (Order_ID:chararray,Customer_ID:int,Order_Quantity:int,Order_Value:float,Order_Date:chararray, Product_ID:int,Product_Name:chararray);
  3. joined= join customers by Customer_ID,orders by Customer_ID;

Please let me know, if I am doing anything wrong here. My HadoopVersion is 2.4.1-mapr-1408 and PigVersion is 0.13.1-mapr-1410.@

Outcomes