Or You can wrrite UDF to avail LEFT function in Hive. Follow : http://snowplowanalytics.com/blog/2013/02/08/writing-hive-udfs-and-serdes/
Regards Sanjiv Singh Mob : +091 9990-447-339 On Tue, Jun 16, 2015 at 3:13 PM, Nitin Pawar <nitinpawar...@gmail.com> wrote: > try using substr function > > On Tue, Jun 16, 2015 at 3:03 PM, Ravisankar Mani <rrav...@gmail.com> > wrote: > >> Hi every one, >> >> >> how to get leftmost length of characters from the string in hive? >> >> In Mysql or sq has specific function >> >> "LEFT(string,length) " >> >> Could you please help any other way to achieve this scenario? >> >> >> Regards >> Ravisnkar >> > > > > -- > Nitin Pawar >
