Linked Questions

Popular Questions

Find maximum occurrence of an year in Hive

Asked by At

Here are some credit card records, I need to find the year having the maximum number of card expiry dates. As the dates are not in YYYY/MM/DD format so in the schema I have defined the dates as of 'string' type

Card Type Full Name,Card Holder's Name,Issue Date,Expiry Date,Card PIN

Discover,Brenda D Peterson,01/2017,01/2022,1998
Diners Club International,Dawn U Reese,12/2015,12/2013,3915 
Diners Club International,Helen P Perry,02/2007,02/2020,2319
American Express,Christine E Kim,08/2011,08/2013,9017

Related Questions