Drill is not SQL Server, and not expected to work identically. Using the upper() and lower() functions is a common approach, unless you find options to set the collation sort order in the Drill docs.
> On Feb 8, 2017, at 1:13 PM, Dechang Gu <d...@mapr.com> wrote: > > Sanjiv, > > Can you share the query and the output you get through sql server? > > > Thanks, > > Dechang > > ________________________________ > From: Sanjiv Kumar <sanjiv...@gmail.com> > Sent: Wednesday, February 8, 2017 5:01:27 AM > To: user@drill.apache.org > Subject: Re: How to avoid case sensitivity in group by > > lower and upper is not a solution which i am aspecting. I want to display > same output as i get through sql server management studio > >> On Wed, Feb 8, 2017 at 5:15 PM, Sanjiv Kumar <sanjiv...@gmail.com> wrote: >> >> Drill Environment:- OS:- Window 10 >> Version:- 1.9 >> Mode:- embedded mode >> >> I have a column name 'State' in db, which have data like(e.g:- Florida, >> florida,new jersey, etc). >> >> My problem is while using count(State) and group by in query, >> Florida and florida are showing two seperate rows. >> >> So how to avoid case sensitivity so that both Florida and florida act as >> 1 rows while firing count(Sate).? >> >> >> -- >> Thanks & Regards. >> Sanjiv Kumar. >> > > > > -- > Thanks & Regards. > Sanjiv Kumar.