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"}
>>
>>
>>
>>
