When I test the hadoop-vetica-connect by use the hadoop-vertica-example in "Programmer's Guide"!
Code: Select all
hadoop jar hadoop-vertica-example.jar com.vertica.hadoop.VerticaExample -libjars /opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/lib/hadoop/lib/hadoop-vertica.jar,/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/lib/hadoop/lib/vertica-jdk5-6.1.2-0.jar -Dmapred.vertica.hostnames=h02,h04,h05 -Dmapred.vertica.port=5433 -Dmapred.vertica.username=dbadmin -Dmapred.vertica.password=test -Dmapred.vertica.database=test
but I executed SQL
Code: Select all
test=> select * from mrtarget ;
a | b | c | d | f | t | v | z
---+---+---+---+---+---+---+---
(0 rows)
Code: Select all
2013-09-05 18:26:59.882 Init Session:0x7fd5dc00e8f0-d0000000001d7a [Txn] <INFO> Starting Commit: Txn: d0000000001d7a 'select ordinal_position, column_name, data_type, is_identity, data_type_name from v_catalog.odbc_columns where schema_name = ? and table_name = ? order by ordinal_position;'
2013-09-05 18:26:59.882 Init Session:0x7fd5dc00e8f0 [Txn] <INFO> Commit Complete: Txn: d0000000001d7a at epoch 0x54
2013-09-05 18:26:59.886 DistCall Dispatch:0x7fd5e000b7e0-c0000000001f33 [Txn] <INFO> Rollback Txn: c0000000001f33 'INSERT INTO public.mrtarget(a,b,c,d,f,t,v,z) VALUES(?,?,?,?,?,?,?,?)'
2013-09-05 18:26:59.936 Init Session:0x7fd5d