RE: how can Combine between two dataset in on datset and execution more condition in the same time

2015-06-20 Thread hagersaleh
can combine between tow table but not use join -- View this message in context: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/how-can-Combine-between-two-dataset-in-on-datset-and-execution-more-condition-in-the-same-time-tp1605p1712.html Sent from the Apache Flink User Mai

RE: how can Combine between two dataset in on datset and execution more condition in the same time

2015-06-12 Thread Kruse, Sebastian
loveallah1...@yahoo.com] Sent: Donnerstag, 11. Juni 2015 22:34 To: user@flink.apache.org Subject: RE: how can Combine between two dataset in on datset and execution more condition in the same time apply not found in flink and how can execute this SELECT employees.last_name FROM employees E, department

RE: how can Combine between two dataset in on datset and execution more condition in the same time

2015-06-11 Thread hagersaleh
apply not found in flink and how can execute this SELECT employees.last_name FROM employees E, departments D WHERE (D.department_id = E.department_id AND E.job_id = 'AC_ACCOUNT' AND D.location = 2400) OR E.department_id = D.department_id AND E.salary > 6 AND D.location = 2400); -- Vi

RE: how can Combine between two dataset in on datset and execution more condition in the same time

2015-06-11 Thread Kruse, Sebastian
Hi, You might want to translate your SQL statement into an expression of the relational algebra at first [1]. This expression can be expressed with Flink's operators in a straight-forward manner. In the end, it will look something like this: Employees.filter(_.job_id = ...).join(departments.fil