Hello Everyone,
I have a set of parquet files which where created as a result of a batch ETL
job (using Sqoop 1).
I can query the fields normally without any kind of formatting and all is
well...
However, when i try to create a view with the following code
CREATE VIEW `dfs.asra`.`vw_tbl_s
Hi Peter,
Do you see the same error when you run the query instead?
SELECT id, settlement, settlement_type,
to_timestamp(to_char(settlement_date, '#')) as settlement_date
,transaction_id, transaction_type, settlement_institution,
settlement_institution_bank_domain_id, domain_i,product_group_id,
Hi Peter,
What version of Drill are you on ?
Thanks,
Khurram
On Fri, Jan 11, 2019 at 12:20 PM Gautam Parai wrote:
> Hi Peter,
>
> Do you see the same error when you run the query instead?
>
> SELECT id, settlement, settlement_type,
> to_timestamp(to_char(settlement_date, '#')) as settlement_d
Hi Peter,
The function to_char(settlement_date, '#') is operating on a date column,
so the second argument should be a date formatter, something like:
to_char(settlement_date, 'mm-dd-').Can you try that ?
Aman
On Fri, Jan 11, 2019 at 2:19 PM Khurram Faraaz wrote:
> Hi Peter,
>
> Wh
Hi Khurram
I am currently Running Apache Drill 1.13
Many Thanks
From: Khurram Faraaz
Sent: Friday, January 11, 2019 11:19 PM
To: user@drill.apache.org
Subject: Re: Problem Creating Views In Apache Drill
Hi Peter,
What version of Drill are you on
Sent: Friday, January 11, 2019 9:19 PM
To: user@drill.apache.org
Subject: Re: Problem Creating Views In Apache Drill
Hi Peter,
Do you see the same error when you run the query instead?
SELECT id, settlement, settlement_type,
to_timestamp(to_char(settlement_date, '#')) as settl