drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Raj <rahul....@option3consulting.com>
Subject Re: Incorrect column name with OVER clause on Drill 1.8
Date Sun, 04 Dec 2016 07:16:07 GMT
Ignore the '${}' in the table name ${purchases_by_item_date}, it gets
substituted as a valid name.
Rahul

On Sun, Dec 4, 2016 at 12:36 PM, Rahul Raj <rahul.raj@option3consulting.com>
wrote:

> The following query:
>
> SELECT
> bill_date,
> sum(sell_amt) over() as `cum_purchases_amt`
> FROM ${purchases_by_item_date}
>
> on a parquet file returns column name as '$1' instead of cum_purchases_amt.
> Any ways to override the name?
>
> Drill 1.6 also shows the same behaviour.
>
> Rahul
>
>

-- 
**** This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom it is 
addressed. If you are not the named addressee then you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately and delete this e-mail from your system.****

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