R-help group,

I'm looking for some assistance on using an R-script to read STDIN from
hadoop.
Example, say I have two tables. One is a student table, the other is a class
roster table (tables join on student_id). Student SAT score is in the
student table, whether the student passed or not is in the roster table.

So to determine if a student passed or failed based on their SAT score, I'd
run this:
SELECT student.SAT, roster.pass FROM student JOIN roster ON
student.student_id=roster.student_id

Easy enough, but now I want to pass the results of this query through an
R-script so I can perform analysis on this. How would I go about passing the
results of a query as a STDIN in hadoop (aka what would the syntax look
like)?

Thanks,

	[[alternative HTML version deleted]]

