Database Reference
In-Depth Information
*.sink.sql.class=org.apache.hadoop.metrics2.sink.SqlServerSink
namenode.sink.sql.databaseUrl=jdbc:sqlserver:
//[server]:[port];databaseName=HadoopMetrics;user=[user];password=
[password]
datanode.sink.sql.databaseUrl=jdbc:sqlserver:
//[server]:[port];databaseName=HadoopMetrics;user=[user];password=
[password]
jobtracker.sink.sql.databaseUrl=jdbc:sqlserver:
//[server]:[port];databaseName=HadoopMetrics;user=[user];password=
[password]
tasktracker.sink.sql.databaseUrl=jdbc:sqlserver:
//[server]:[port];databaseName=HadoopMetrics;user=[user];password=
[password]
maptask.sink.sql.databaseUrl=jdbc:sqlserver:
//[server]:[port];databaseName=HadoopMetrics;user=[user];password=
[password]
reducetask.sink.sql.databaseUrl=jdbc:sqlserver:
//[server]:[port];databaseName=HadoopMetrics;user=[user];password=
[password]
Figure 16.4
Completed hadoop-metrics2.properties file
2. Next, you need to update the Java classpath for each Hadoop service to
include the
metrics-sink.jar
and
sqljdbc4.jar
files. You can
find these files in the
{c:\hadoop\install\dir}\bin
folder. On
your single node cluster, you can find these files at
c:\hdp\hadoop\hadoop-1.2.0.1.3.0.0-380\bin\
. You will
need to update the historyserver, tasktracker, jobtracker, datanode,
namenode, and secondarynamenode files with the following
information:
