Re: Problem Creating Views In Apache Drill

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 settlement_date

Re: Problem Creating Views In Apache Drill

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

Re: Problem Creating Views In Apache Drill

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

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 settlement_date ,transaction_id, transaction_type, settlement_institution, settlement_institution_bank_domain_id, domain_i,product_group_id,

Problem Creating Views In Apache Drill

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