drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abdel Hakim Deneche <adene...@maprtech.com>
Subject Re: select * + window function gives strange column names
Date Thu, 28 May 2015 22:53:07 GMT
never mind, DRILL-3210 <https://issues.apache.org/jira/browse/DRILL-3210>
was just filled for a similar problem

On Thu, May 28, 2015 at 3:51 PM, Abdel Hakim Deneche <adeneche@maprtech.com>
wrote:

> I have a small json file that contains the following columns:
> employee_id, position_id, salary, sub and count
>
> when I run the following query:
>
> select *, count(*) over(partition by position_id) from `myfile.json`;
>
> I get this list of columns:
>
> T1¦¦employee_id  |  T1¦¦position_id  |  T1¦¦sub  |  T1¦¦salary  |
>>  position_id  |  w0$o0  |  w0$o00  |  EXPR$1 |
>
>
> is this correct ?
>
>
> --
>
> Abdelhakim Deneche
>
> Software Engineer
>
>   <http://www.mapr.com/>
>
>
> Now Available - Free Hadoop On-Demand Training
> <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
>



-- 

Abdelhakim Deneche

Software Engineer

  <http://www.mapr.com/>


Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>

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