Re: Drill on YARN Questions

2019-01-11 Thread Kwizera hugues Teddy
Hello , Other option work . As you say an update is needed in docs and the remove of wrong information. Thanks. On Sat, Jan 12, 2019, 08:10 Abhishek Girish Hello Teddy, > > I don't recollect a restart option for the drill-on-yarn.sh script. I've > always used a combination of stop and start,

Re: Drill on YARN Questions

2019-01-11 Thread Abhishek Girish
Hello Teddy, I don't recollect a restart option for the drill-on-yarn.sh script. I've always used a combination of stop and start, like Paul mentions. Could you please try if that works and get back to us? We could certainly have a minor enhancement to support restart - until then i'll request

Re: Drill on YARN Questions

2019-01-11 Thread Kwizera hugues Teddy
Hello Paul , Thanks you for your response with some interesting information(files in /tmp). For my side all other command line work normally(start|stop|status...|) but no restart(this option not recognized). I tried to search the code source and I found that the restart command is not

Re: Drill on YARN Questions

2019-01-11 Thread Paul Rogers
Let's try to troubleshoot. Does the combination of stop and start work? If so, then there could be a bug with the restart command itself. If neither start nor stop work, it could be that you are missing the application ID file created when you first started DoY. Some background. When we submit

Re: Problem Creating Views In Apache Drill

2019-01-11 Thread Khurram Faraaz
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

2019-01-11 Thread Gautam Parai
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,

Re: Drill on YARN Questions

2019-01-11 Thread Kwizera hugues Teddy
hello, 2 weeks ago, I began to discover DoY. Today by reading drill documents ( https://drill.apache.org/docs/appendix-a-release-note-issues/ ) I saw that we can restart drill cluster by : $DRILL_HOME/bin/drill-on-yarn.sh --site $DRILL_SITE restart But doesn't work when I tested it. No idea

Problem Creating Views In Apache Drill

2019-01-11 Thread Peter Edike
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