You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Charles Givre <cg...@gmail.com> on 2017/02/27 03:17:54 UTC
Excessive Logging Messages
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"}
Re: Excessive Logging Messages
Posted by Charles Givre <cg...@gmail.com>.
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 <jn...@apache.org> 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 <cg...@gmail.com> wrote:
>> Hi Jinfeng,
>> That didn’t seem to do the trick. Any other suggestions?
>>
>>> On Feb 26, 2017, at 23:23, Jinfeng Ni <jn...@apache.org> 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 <cg...@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"}
>>>>
>>>>
>>>>
>>>>
>>
Re: Excessive Logging Messages
Posted by Charles Givre <cg...@gmail.com>.
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 <jn...@apache.org> 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 <cg...@gmail.com> wrote:
>> Hi Jinfeng,
>> That didn’t seem to do the trick. Any other suggestions?
>>
>>> On Feb 26, 2017, at 23:23, Jinfeng Ni <jn...@apache.org> 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 <cg...@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"}
>>>>
>>>>
>>>>
>>>>
>>
Re: Excessive Logging Messages
Posted by Jinfeng Ni <jn...@apache.org>.
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 <cg...@gmail.com> wrote:
> Hi Jinfeng,
> That didn’t seem to do the trick. Any other suggestions?
>
>> On Feb 26, 2017, at 23:23, Jinfeng Ni <jn...@apache.org> 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 <cg...@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"}
>>>
>>>
>>>
>>>
>
Re: Excessive Logging Messages
Posted by Jinfeng Ni <jn...@apache.org>.
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 <cg...@gmail.com> wrote:
> Hi Jinfeng,
> That didn’t seem to do the trick. Any other suggestions?
>
>> On Feb 26, 2017, at 23:23, Jinfeng Ni <jn...@apache.org> 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 <cg...@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"}
>>>
>>>
>>>
>>>
>
Re: Excessive Logging Messages
Posted by Charles Givre <cg...@gmail.com>.
Hi Jinfeng,
That didn’t seem to do the trick. Any other suggestions?
> On Feb 26, 2017, at 23:23, Jinfeng Ni <jn...@apache.org> 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 <cg...@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"}
>>
>>
>>
>>
Re: Excessive Logging Messages
Posted by Charles Givre <cg...@gmail.com>.
Hi Jinfeng,
That didn’t seem to do the trick. Any other suggestions?
> On Feb 26, 2017, at 23:23, Jinfeng Ni <jn...@apache.org> 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 <cg...@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"}
>>
>>
>>
>>
Re: Excessive Logging Messages
Posted by Jinfeng Ni <jn...@apache.org>.
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 <cg...@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"}
>
>
>
>
Re: Excessive Logging Messages
Posted by Jinfeng Ni <jn...@apache.org>.
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 <cg...@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"}
>
>
>
>