Re: Best way to load the data in hadoop

2011-09-27 Thread Reju R
Hi, For reading from SQL tables, you can use SQOOP tool. For storing the data, and keeping the data relation, we can use Hive as a solution. You can write some mapreduce program to read the data from CSV files into hadoop. Regards Reju. R On Tue, Sep 27, 2011 at 7:26 PM, vikas srivastava

pivot table in hive

2011-06-08 Thread Reju R
ly me your suggestions. -- Thanks and Regards Reju. R -- Thanks and Regards Reju. R VendorId IncomeDay IncomeAmount -- -- SPIKE FRI 100 SPIKE MON 300 FREDS SUN 400 SPIKE