I have tried simple query on Drill 1.9.0 but seems query returns correct result.
create table dfs.tmp.t as select 1 col1, 2 col2 from (values(1)); select col1 c, sum(col1) over() cnt from dfs.tmp.t where col2 between 1 and 10; +----+------+ | c | cnt | +----+------+ | 1 | 1 | +----+------+ Amir, it would be great if you could provide sample data and instructions how to reproduce the issue (like I did above) and open Jira with this information. Kind regards Arina On Tue, Mar 28, 2017 at 1:23 PM, Amir Kafri <[email protected]> wrote: > Hi Arina, > > I'm using V 1.9. I tried it both in embedded and jdbc. > > The actual query is slightly more complicated: > > SELECT > bugs DYNAMIC_SCHEMA_2_MES_BUGS, > sum(bugs) over() AS CNT > FROM > s3datorama.`dss`.`dynamic-schema-id=2` DYNAMIC_SCHEMA_2 > WHERE > ( DYNAMIC_SCHEMA_2.date_id >= 2015021100 AND > DYNAMIC_SCHEMA_2.date_id <= 2017031223 ) > > On Tue, Mar 28, 2017 at 12:40 PM Arina Yelchiyeva < > [email protected]> wrote: > > > Hi Amir, > > > > Which version of Drill are you using? > > I have tried to reproduce the issue in embedded mode and in also using > jdbc > > but no luck. > > > > Kind regards > > Arina > > > > On Tue, Mar 28, 2017 at 10:25 AM, Amir Kafri <[email protected]> wrote: > > > > > Hi All, > > > > > > I think I've encountered a bug: > > > > > > I'm running the following query: > > > > > > SELECT > > > metric AS m, > > > COUNT(*) OVER() AS row_counter > > > FROM t > > > > > > The result is correct, but the name of the 2nd column in the result set > > is > > > w0$o0. > > > > > > If I switch the order in the SELECT: > > > SELECT > > > COUNT(*) OVER() AS row_counter, > > > metric AS m > > > FROM t > > > > > > then the column names are correct (row_counter, m). > > > > > > > > > -- > > > > > > *Amir Kafri*Data Engineer > > > > > > > > > *datorama*All Your *Data*, Working Together > > > *.*Habarzel 34, Ramat Hachayal, Tel-Aviv, 69710 > > > *E* [email protected] > > > *Website <http://www.datorama.com/> | LinkedIn > > > <https://www.linkedin.com/company/datorama> | Twitter > > > <https://twitter.com/datorama> | Facebook > > > <https://www.facebook.com/pages/Datorama/232963956806382>* > > > > > > -- > > *Amir Kafri*Data Engineer > > > *datorama*All Your *Data*, Working Together > *.*Habarzel 34, Ramat Hachayal, Tel-Aviv, 69710 > *E* [email protected] > *Website <http://www.datorama.com/> | LinkedIn > <https://www.linkedin.com/company/datorama> | Twitter > <https://twitter.com/datorama> | Facebook > <https://www.facebook.com/pages/Datorama/232963956806382>* >
