Apache Pig Join returns empty -



Apache Pig Join returns empty -

i have simplified problem farther , here details:

in1.txt:

null null <=6.9 null null <7.0

in2.txt:

null null <=6.9null not-null <=6.9 null null <7.0 not-null null <7.0 in1 = load 'in1.txt' (f1:chararray, f2:chararray, f3:chararray); dump in1;

i see following: not sure why there additional empty fields!

(null null <=6.9,,) (null not-null <=6.9,,) (null null <7.0,,) (not-null null <7.0,,) in2 = load 'in2.txt' (a1:chararray, a2:chararray, a3:chararray); dump in2;

i see following: not sure why there additional empty fields!

(null null <=6.9 ,,) (null null <7.0 ,,) ins_joined = bring together in1 by(f1,f2,f3), in2 (a1,a2,a3); dump ins_joined;

i tried

this:ins_joined_one = bring together in1 by(f1), in2 (a1); dump ins_joined_one; dump ins_joined_one empty!

relation ins_joined empty. not sure going on. appreciate help.

your info not loaded properly, datas loaded single column , remaining columns empty, need load info this

in1 = load 'in1.txt' using pigstorage(' ') (f1:chararray, f2:chararray, f3:chararray); in2 = load 'in2.txt' using pigstorage(' ') (a1:chararray, a2:chararray, a3:chararray);

apache-pig

Comments

Popular posts from this blog

Delphi change the assembly code of a running process -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

C++ 11 "class" keyword -