You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by priyanka B <pr...@gmail.com> on 2019/04/16 09:42:34 UTC

Wrong column name when using value window function

While generating a parquet using the query below in Drill 1.15, the last
column(lead_sales) appears as '$1'. The issue happens only when parquet is
written and the last column is value window function. Otherwise, a select
query shows the proper column name.

*CREATE TABLE dfs.fs1.`test` AS SELECT*
*  `date`*
*, `sales`*
*, `lead`(`sales`) OVER (ORDER BY `sales` ASC) `lead_sales`*
*FROM*
* dfs.fs1.`input_1`*

Let me know your inputs.

Thank you,
Priyanka Bhoir