hadoop pig:在条件上加入(例如tab1.COL1 LIKE(％tab2.col2％)) [英] hadoop pig : join on a condition (ex. tab1.COL1 LIKE (%tab2.col2%) )

问题描述

如何在PIG中的条件下实施联接? 等效的SQL示例:

How to implement a join on a condition in PIG? SQL equivalent Examples:

       select * from tab1, tab2 where instr(t1.col1,t2.col1 ) > 1 ;
       select * from tab1, tab2 where f(t1.col1) =f(t2.col1)  ;

非常感谢. 菲利波

推荐答案

尝试一下.

1.

Cross_Table = CROSS tab1, tab2;
Filter_Table = FILTER Cross_Table BY NOT(STARTSWITH(tab1::col1, tab2::col1));

2.

Join_Table = JOIN tab1 BY f(col1) INNER JOIN, tab2 BY f(col1); 

这篇关于hadoop pig:在条件上加入(例如tab1.COL1 LIKE(％tab2.col2％))的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！