drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjiv Kumar <sanjiv...@gmail.com>
Subject How to avoid case sensitivity in group by
Date Wed, 08 Feb 2017 11:45:49 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message