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




Reply via email to