What do you mean by "Select runs fine" - is it using number of reducers
that you set?
It might help if you could show actual query.
On 13.01.2012 00:03, Koert Kuipers wrote:
I tried set mapred.reduce.tasks = xyz; hive ignored it.
Selects run fine. The query uses 44 mappers.
On Thu, Jan 12, 2012 at 6:00 PM, Wojciech Langiewicz
<wlangiew...@gmail.com>wrote:
Hello,
Have you tried running only select, without creating table? What are
results?
How did you tried to set number of reducers? Have you used this:
set mapred.reduce.tasks = xyz;
How many mappers does this query use?
On 12.01.2012 23:53, Koert Kuipers wrote:
I am running a basic join of 2 tables and it will only run with 1 reducer.
why is that? i tried to set the number of reducers and it didn't work.
hive
just ignored it.
create table z as select x.* from table1 x join table2 y where (
x.col1 = y.col1 and
x.col2 = y.col2 and
x.col3 = y.col3 and
x.col4 = y.col4 and
x.col5 = y.col5
);
both tables are backed by multiple files / blocks / chunks
--
Wojciech Langiewicz
