drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abdel Hakim Deneche <adene...@maprtech.com>
Subject select * + window function gives strange column names
Date Thu, 28 May 2015 22:51:08 GMT
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>

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