You may be able to by playing around with the system/session options planner.width.max_per_query or planner.width.max_per_node <https://drill.apache.org/docs/configuration-options-introduction/>, Not sure if you would want to though.
Any of those options will reduce the parallelism possible either during CTAS(writing) or when reading the files through drill. Regards Ramana On Wed, Oct 21, 2015 at 8:59 AM, Boris Chmiel < boris.chm...@yahoo.com.invalid> wrote: > Hi all, > Does anyone know if there is a native way to force drill to produce only > one file as a result of a CTAS ?In one of my specific use case, I run > succession of queries with Drill to produce several csv result with > CTAS. Many folders contains multiple files and I need to run a shell script > to cat / sed the result. Is it possible to avoid that ? > cheersBoris
