drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jinfeng Ni <...@apache.org>
Subject Re: Excessive Logging Messages
Date Mon, 27 Feb 2017 07:26:31 GMT
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 <cgivre@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 <jni@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 <cgivre@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"}
>>>
>>>
>>>
>>>
>

Mime
View raw message