Hi All, I have Hive 0.8.0 version installed in my single node Apache Hadoop cluster.
I have a time column which is in format *MM:SS* (Minutes:seconds). I tried the date functions to get the value in MM:SS format. But its not working out. Below is my column for your reference. *Active Time* *12:01* 0:20 2:18 in the first record 12:01, 12 is the number of minutes and 01 is the seconds. so when the time i'm creating a table in Hive, i have to give a data type for this column Active Time, I have tried with various date type columns but none of them worked out for me. Please guide me. What function should I use, to get the time in *MM:SS* format? "You only live once, but if you do it right, once is enough." Cheers!! Maheedhar Reddy K V http://about.me/maheedhar.kv/#
