I assume what you want is to disable those INFO level log messages in your drillbit.log (or sqlline.log, if it's embedded drill). If that's what you want, when you start sqlline to connect to drillbit, it will show the following information,
23:15:23,654 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [file:/private/etc/drill/conf/logback.xml] 23:15:25,636 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.drill] to false 23:15:25,637 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.apache.drill level set to WARN The first one tells you which logback.xml is used. Please make sure your modify the one list there. The second/third entries confirm log level for classes in package org.apache.drill. btw: in my previous email, I used cap "INFO", "WARN". Please use low-case ones. I tried the above approach, and it seemed to work. On Sun, Feb 26, 2017 at 8:40 PM, Charles Givre <[email protected]> wrote: > Hi Jinfeng, > That didn’t seem to do the trick. Any other suggestions? > >> On Feb 26, 2017, at 23:23, Jinfeng Ni <[email protected]> wrote: >> >> 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 <[email protected]> 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"} >>> >>> >>> >>> >
