Github Project : https://gitlab.saagie.tech/service/example-java-read-and-write-from-drill
Common part
Maven Dependencies
...
The command INSERT is not supported by Drill.
Apache Drill cannot insert, update, or delete data that currently exists on HDFS.
How to select data from an Impala table with Java?
...