| 80 |
+--+-+
From: Sanjiv Kumar
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
Sql Server Query:- select
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
.
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
.
share the query and the output you get through sql server?
>
>
> Thanks,
>
> Dechang
>
>
> From: Sanjiv Kumar
> Sent: Wednesday, February 8, 2017 5:01:27 AM
> To: user@drill.apache.org
> Subject: Re: How to avoid case sensit
Sanjiv,
Can you share the query and the output you get through sql server?
Thanks,
Dechang
From: Sanjiv Kumar
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
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
>Mode:- embedded m
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 name 'State' in db, wh
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 showi