Re: How to avoid case sensitivity in group by

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 wrote: > > Sanjiv, > > Can you

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 Sent: Wednesday, February 8, 2017 5:01:27 AM To: user@drill.apache.org Subject: Re: How to avoid case sensitivity in group by

Re: how to show decimal upto 2 points

Hi Sanjiv, You have a few options… You can use the ROUND() function IE: SELECT ROUND( `col1`, 2 ) AS col1 FROM… OR you can use the TO_CHAR() function like this: SELECT TO_CHAR( `col1`, ‘#,###.##’ ) AS col1 FROM… The biggest difference is that the ROUND() function gets you numeric data types

FINAL REMINDER: CFP for ApacheCon closes February 11th

Dear Apache Enthusiast, This is your FINAL reminder that the Call for Papers (CFP) for ApacheCon Miami is closing this weekend - February 11th. This is your final opportunity to submit a talk for consideration at this event. This year, we are running several mini conferences in conjunction with

how to show decimal upto 2 points

Hi Drill Environment:- OS:- Window 10 Version:- 1.9 Mode:- embedded mode I have query i have set planner.enable_decimal_data_type=true and while firing select command in drill i got output in decimal value but it showing like 11936.3697. I want to

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

Re: How to enable decimal value

Hey.. I got my problem, In select query i am using cast. I have number value in database and while querying through drill, i have cast it to bigint, thats why decimal value are not showing in output even after set planner.enable_decimal_data_type=true. But after removing cast, expected output

Re: How to enable decimal value

Can you share your query and the results ? And did you set planner.enable_decimal_data_type=true at session level or system level ? From: Sanjiv Kumar Sent: Wednesday, February 8, 2017 3:15:08 PM To: user@drill.apache.org Subject: How to

How to enable decimal value

Hello I have decimal value in my table. When query through drill data are rounded off in output. I have enable planner.enable_decimal_data_type = true in system options. But still data are not showing in decimal form. Drill Environment:- OS:- Window 10 Version:- 1.9