Re: Find a date that is in the range of any array dates in Hive

2014-02-02 Thread Matouk IFTISSEN
Hé You can use explode function that is an udf in hive: like this SELECT explode(ActivityDates) AS ActivityDates FROM myMapTable; and think who to map the result whith rates ;) Regadrs. Matouk 2014-02-01 Raj Hadoop : > Hi, > > > I have the following requirement from a Hive table below. > > Cus

Find a date that is in the range of any array dates in Hive

2014-01-31 Thread Raj Hadoop
Hi, I have the following requirement from a Hive table below. CustNumActivityDatesRates 10010-Aug-13,12-Aug-13,20-Aug-1310,15,20 The data above says that From 10 Aug to 11 Aug the rate is 10. From 12 Aug to 19 Aug the rate is 15. From 20-Aug to till date the rate is 20. Note : The order is m