drill-dev 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 04:23:52 GMT
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