drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt <bsg...@gmail.com>
Subject Re: How to avoid case sensitivity in group by
Date Thu, 09 Feb 2017 00:10:40 GMT
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 <dgu@mapr.com> wrote:
> 
> Sanjiv,
> 
> Can you share the query and the output you get through sql server?
> 
> 
> Thanks,
> 
> Dechang
> 
> ________________________________
> From: Sanjiv Kumar <sanjivktr@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 <sanjivktr@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.

Mime
View raw message