Re: How to avoid case sensitivity in group by

| 80 | +--+-+ From: Sanjiv Kumar <sanjiv...@gmail.com> Sent: Wednesday, February 8, 2017 10:11:11 PM To: user@drill.apache.org Subject: Re: How to avoid case sensitivity in group by Hello This is my input table in db:- State Price Alaska 75 Texas 80 Alaska 90 Florida 100 florida 70

Re: How to avoid case sensitivity in group by

Hello This is my input table in db:- State Price Alaska 75 Texas 80 Alaska 90 Florida 100 florida 70 Sql Server Query:- select State, Sum (Price) from testTable group by State. Sql Server Output:- State Price Alaska 165 Texas 80 Florida 170 Drill Query:- select T1.State, Sum(T1.Price) from

Re: How to avoid case sensitivity in group by

v, > > 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.

Re: How to avoid case sensitivity in group by

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

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 wrote: > Drill Environment:- OS:- Window 10 >Version:- 1.9 >

Re: How to avoid case sensitivity in group by

You can wrap state column in upper / lower function prior to count. Kind regards Arina On Wed, Feb 8, 2017 at 1:45 PM, Sanjiv Kumar wrote: > Drill Environment:- OS:- Window 10 >Version:- 1.9 >Mode:- embedded mode > > I have a column

How to avoid case sensitivity in group by

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