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.****