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>*
