Improvement
Assume that you have a Microsoft SQL Server 2016 with PolyBase feature installed. This improvement provides a way to configure logging for Hadoop bridge (java) log messages. You can control java logger logging level from a configuration file.
You can find polybase.log.level property in "<Sql Server installation path>\MSSQL\Binn\Polybase\Hadoop\conf\core-site.xml". Accordingly, you could change polybase logging level in the following location. The default logging level is WARNING.
<property>
<name>polybase.log.level</name>
<value>WARNING</value>
</property>
You can uncomment this property and set the value for this property from any of below values depending on your requirements. But the change will get affected only after restarting "SQL Server Polybase Data Movement" and "SQL Server Polybase Engine" services.
| Property Value | Description |
|---|---|
| ALL | ALL indicates that all messages should be logged. |
| CONFIG | CONFIG is a message level for static configuration messages. |
| FINE | FINE is a message level providing tracing information. |
| FINER | FINER indicates a fairly detailed tracing message. |
| FINEST | FINEST indicates a highly detailed tracing message. |
| INFO | INFO is a message level for informational messages. |
| OFF | OFF is a special level that can be used to turn off logging. |
| SEVERE | SEVERE is a message level indicating a serious failure. |
| WARNING | WARNING is a message level indicating a potential problem. |
Resolution
This improvement is included in the following cumulative update for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
References
Learn about the terminology that Microsoft uses to describe software updates.