Hi Jinfeng, Thank you so much for your help. It turns out the problem was that I was working on another project and inadvertently copied the wrong slf4j binding into my classpath. Once I got rid of that, things returned to normal. Best, — C
> On Feb 27, 2017, at 02:26, Jinfeng Ni <[email protected]> wrote: > > 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"} >>>> >>>> >>>> >>>> >>
