title: How to PIVOT data in Hive
body: <p>How to achive PIVOT functionality in HiveQL. Following is SQL Query and please help me in achieving this in Hive:</p>
  
  <pre><code> CREATE TABLE Product(Cust VARCHAR(25), Product VARCHAR(20), QTY INT)
   GO
   -- Inserting Data into Table
   INSERT INTO Product(Cust, Product, QTY) VALUES('KATE','VEG',2)
   INSERT INTO Product(Cust, Product, QTY) VALUES('KATE','SODA',6)
   INSERT INTO Product(Cust, Product, QTY) VALUES('KATE','MILK',1)
   INSERT INTO Product(Cust, Product, QTY) VALUES('KATE','BEER',12)
   INSERT INTO Product(Cust, Product, QTY) VALUES('FRED','MILK',3)
   INSERT INTO Product(Cust, Product, QTY) VALUES('FRED','BEER',24)
   INSERT INTO Product(Cust, Product, QTY) VALUES('KATE','VEG',3)
   GO
  
   -- Pivot Table ordered by PRODUCT
   SELECT PRODUCT, FRED, KATE FROM (
   SELECT CUST, PRODUCT, QTY
   FROM Product) up
   PIVOT (SUM(QTY) FOR CUST IN (FRED, KATE)) AS pvt
   ORDER BY PRODUCT
  </code></pre>
  
  <p>--Desired Output:
  Cust    Product QTY
  KATE    VEG 2
  KATE    SODA    6
  KATE    MILK    1
  KATE    BEER    12
  FRED    MILK    3
  FRED    BEER    24
  KATE    VEG 3</p>