On Tue, Feb 3, 2009 at 5:49 PM, Amandeep Khurana <ama...@gmail.com> wrote:
> In the setInput(...) function in DBInputFormat, there are two sets of > arguments that one can use. > > 1. public static void *setInput*(JobConf > > a) In this, do we necessarily have to give all the fieldNames (which are > the > column names right?) that the table has, or do we need to specify only the > ones that we want to extract? You may specify only those columns that you are interested in. b) Do we have to have a orderBy or not necessarily? Does this relate to the > primary key in the table in any ways? Conditions and order by are not necessary. a) Is there any restriction on the kind of queries that this function > can take in the inputQuery string? I don't think so, but I don't use this method -- I just use the fieldNames and tableName method. > I am facing issues in getting this to work with an Oracle database and > have no idea of how to debug it (an email sent earlier). > Can anyone give me some inputs on this please? Create a new table that has one column, put about five entries into that table, then try to get a map job working that outputs the values to a text file. If that doesn't work, post your code and errors.
