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
Post a Comment