vertica/Vertica-Hadoop-Connector — pull request #4 by ssathiyavageswaran (2013-02-04 19:58:49+00:00)
Title: Update VerticaConfiguration.java

Added JDBC debug logging options. Will be useful to get more information when a load fails from JDBC driver logs. Setting it to

0 (off) log nothing
1 (error) logs only errors
2 (warning) logs warnings
3 (info) logs general information, the queries that run and the protocol
messages between client& server
4 (debug) logs most, but not all, function entrances
5 (trace) is probably overkill. There isn't actually any additional
information logged, but with trace enabled, the SDK prints a whole stack
trace with every log message

Here is an example call:

sudo hadoop jar hadoop-vertica-example.jar com.vertica.hadoop.VerticaExample
-libjars /usr/lib/hadoop/lib/hadoop-vertica.jar,/usr/lib/hadoop/lib/vertica-jdk5.jar
-Dmapred.vertica.hostnames=host1,host2,host3,host4 -Dmapred.vertica.port=5435
-Dmapred.vertica.username=hdfs -Dmapred.vertica.database=HADOOP
-Dmapred.vertica.debug=1