How to connect Vertica to hadoop.
Posted: Thu Apr 25, 2013 3:37 am
I have downloaded the hadoop connnectors and examples. Also the hadoop is running. how can i connect to hadoop/how to test the examples.
I gave like as below as job,
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=192.168.x.x -Dmapred.vertica.port=5433
-Dmapred.vertica.username=hdfs -Dmapred.vertica.database=HADOOP
-Dmapred.vertica.debug=1
it show the error as,
Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: [Vertica][VJDBC](100176) Failed to connect to host 192.168.x.x on port 5433. Reason: Connection timed out:connect
How to resolve this.
I gave like as below as job,
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=192.168.x.x -Dmapred.vertica.port=5433
-Dmapred.vertica.username=hdfs -Dmapred.vertica.database=HADOOP
-Dmapred.vertica.debug=1
it show the error as,
Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: [Vertica][VJDBC](100176) Failed to connect to host 192.168.x.x on port 5433. Reason: Connection timed out:connect
How to resolve this.