"select * from mrtarget" return no data.

Moderator: NorbertKrupa

Post Reply
muaythai_duan
Newbie
Newbie
Posts: 18
Joined: Sun Aug 25, 2013 11:43 am

"select * from mrtarget" return no data.

Post by muaythai_duan » Thu Sep 05, 2013 3:51 am

hi,everyone:
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
Command executed successfully,tasktracker executed successfully in hadoop.
but I executed SQL

Code: Select all

test=> select * from mrtarget ;
 a | b | c | d | f | t | v | z 
---+---+---+---+---+---+---+---
(0 rows)
vertica log

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
Not select data.Can you give me some advise?I hope learn vertica from everyone.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: "select * from mrtarget" return no data.

Post by id10t » Fri Sep 06, 2013 4:52 pm

Hi!

Use the Vertica 6 Hadoop connector with only these version pairs:
• Hadoop 0.20.2 and Pig 0.7.0
• Hadoop 0.20.205.0 and Pig 0.9.1
• Hadoop 1.0.0 and Pig 0.9.2

or

viewtopic.php?f=31&t=556#p1827

Post Reply

Return to “Hadoop Connector”