you can use the Position function in drill which do the same thing. select POSITION(’substring’ in ’string’) from sample_table
Rajkumar Singh MapR Technologies > On Sep 8, 2015, at 12:48 PM, Leon Clayton <lclay...@maprtech.com> wrote: > > Hello All > > Anyone come up with a way to do the instr function within Apache Drill. INSTR > function returns the position of a substring in a string. > > Regards > > Leon Clayton > >
