Improvement: A way to configure logging for Hadoop bridge in PolyBase in SQL Server 2016

Applies to: SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 Enterprise

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 thehotfixes and all the security fixes that were included with the previouscumulative update. Check out the latest cumulative updates for SQL Server:

References


Learn about the terminology thatMicrosoft uses to describe software updates.