Re: Left function

2015-06-22 Thread @Sanjiv Singh
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 wrote: > try using substr function > > On Tue, Jun 16

Re: Left function

2015-06-16 Thread Nitin Pawar
try using substr function On Tue, Jun 16, 2015 at 3:03 PM, Ravisankar Mani 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

Left function

2015-06-16 Thread Ravisankar Mani
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