Hi , I haven't upgraded to Drill 1.14 yet . Here is the query and data SELECT `IP_Subnet`,LTRIM(`IP_Subnet`,'/') AS Subnets FROM `tmp`.`default`.`./mapping/` ;
The LTRIM not working on special characters :( IP_Subnet Subnets 10.128.18.0/23 10.128.18.0/23 10.128.20.0/24 10.128.20.0/24 10.128.36.0/23 10.128.36.0/23 10.128.86.0/23 10.128.86.0/23 10.128.18.0/23 10.128.18.0/23 Thanks, Divya On Wed, 19 Sep 2018 at 03:01, Karthikeyan Manivannan <kmanivan...@mapr.com> wrote: > Hi Divya, > > Can you please post your query and and an example of the column data. And > have you tried this on Drill 1.14 ? > > Thanks. > > Karthik > > On Mon, Sep 17, 2018 at 2:27 AM Divya Gehlot <divya.htco...@gmail.com> > wrote: > > > Hi, > > I am using Drill 1.10 > > My apologies if My query is naive . > > One of the table column field has special character like '/' > > when I am doing RTRIM on it to just get the data before the '/' , it's > not > > working :( > > > > Appreciate if anybody know how it works in Apache Drill ! > > > > Thanks, > > Divya > > >