You can modify logback.xml in your drill conf directory (DRILL_HOME/conf/logback.xml).
<logger name="org.apache.drill" additivity="false"> <level value="info" /> --> Change INFO to either WARN or ERROR <appender-ref ref="FILE" /> </logger> On Sun, Feb 26, 2017 at 7:17 PM, Charles Givre <cgi...@gmail.com> wrote: > Hello all, > I was doing some unrelated work and somehow made it so that every time I > execute a query in Drill from the command line, I get all these INFO > messages. Could someone please explain how to disable these? > Thanks, > — Charles > > > > : jdbc:drill:zk=local> SELECT `Asking - Sold Delta Percent` AS `Asking - Sold > Delta Percent` FROM dfs.test.`comps.xlsx` WHERE `Close Date` >= '2014-02-24 > 00:07:38' AND `Close Date` <= '2017-02-24 00:07:38' LIMIT 50000; > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.work.foreman.Foreman run > INFO: Query text for query id 274c6cc2-7e8e-c652-812b-2cd6414e453a: SELECT > `Asking - Sold Delta Percent` AS `Asking - Sold Delta Percent` FROM > dfs.test.`comps.xlsx` WHERE `Close Date` >= '2014-02-24 00:07:38' AND > `Close Date` <= '2017-02-24 00:07:38' LIMIT 50000 > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 11 classes for org.apache.drill.exec.store.dfs.FormatPlugin > took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM > org.apache.drill.common.scanner.persistence.ScanResult getImplementations > INFO: loading 12 classes for > org.apache.drill.common.logical.FormatPluginConfig took 0ms > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection > getStatuses > INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1 > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.schedule.BlockMapBuilder > getEndpointByteMap > INFO: Failure finding Drillbit running on host localhost. Skipping affinity > to that host. > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.TimedRunnable run > INFO: Get block maps: Executed 1 out of 1 using 1 threads. Time: 0ms total, > 0.729272ms avg, 0ms max. > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.TimedRunnable run > INFO: Get block maps: Executed 1 out of 1 using 1 threads. Earliest start: > 0.824000 μs, Latest start: 0.824000 μs, Average start: 0.824000 μs . > Feb 26, 2017 9:47:25 PM > org.apache.drill.exec.planner.logical.partition.PruneScanRule doOnMatch > INFO: Beginning partition pruning, pruning class: > org.apache.drill.exec.planner.logical.partition.PruneScanRule$DirPruneScanFilterOnScanRule > Feb 26, 2017 9:47:25 PM > org.apache.drill.exec.planner.logical.partition.PruneScanRule doOnMatch > INFO: No partition columns are projected from the scan..continue. Total > pruning elapsed time: 0 ms > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.work.fragment.FragmentExecutor > updateState > INFO: 274c6cc2-7e8e-c652-812b-2cd6414e453a:0:0: State change requested > AWAITING_ALLOCATION --> RUNNING > Feb 26, 2017 9:47:25 PM > org.apache.drill.exec.work.fragment.FragmentStatusReporter stateChanged > INFO: 274c6cc2-7e8e-c652-812b-2cd6414e453a:0:0: State to report: RUNNING > Feb 26, 2017 9:47:25 PM org.apache.drill.exec.work.fragment.FragmentExecutor > updateState > INFO: 274c6cc2-7e8e-c652-812b-2cd6414e453a:0:0: State change requested > RUNNING --> FINISHED > Feb 26, 2017 9:47:25 PM > org.apache.drill.exec.work.fragment.FragmentStatusReporter stateChanged > INFO: 274c6cc2-7e8e-c652-812b-2cd6414e453a:0:0: State to report: FINISHED > Feb 26, 2017 9:47:25 PM > org.apache.drill.exec.work.foreman.Foreman$ForemanResult logQuerySummary > INFO: > {"queryId":"274c6cc2-7e8e-c652-812b-2cd6414e453a","schema":"","queryText":"SELECT > `Asking - Sold Delta Percent` AS `Asking - Sold Delta Percent` FROM > dfs.test.`comps.xlsx` WHERE `Close Date` >= '2014-02-24 00:07:38' AND > `Close Date` <= '2017-02-24 00:07:38' LIMIT > 50000","start":1488163645452,"finish":1488163645633,"outcome":"COMPLETED","username":"anonymous","remoteAddress":"192.168.1.151:54865"} > > > >