select * + window function gives strange column names

2015-05-28 Thread Abdel Hakim Deneche
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¦

Re: select * + window function gives strange column names

2015-05-28 Thread Abdel Hakim Deneche
never mind, DRILL-3210 was just filled for a similar problem On Thu, May 28, 2015 at 3:51 PM, Abdel Hakim Deneche wrote: > I have a small json file that contains the following columns: > employee_id, position_id, salary, sub and count > > when I