Full outer join have problem

Hi, Full outer join is not working as it should work in hive 0.4.1. I tried few query with full outer join in Hive. It should suppose to first filter the rows by where clause, then It should go for join table. But every time it takes full rows for join after it goes for filter . Hence I can

Problem to fetch data

Hi , I am running some query on hive with syntax of "insert overwrite local". If I am querying on small data set it is storing data on my local system. if I am querying on larger data set it is not storing data in my local, But that data I am able to see in hive scratch directory. Any idea wha

Issue with map join

Hi, I am trying to running some MAPJOIN queries. When I am placing single table in MAP JOIN it works fine,But when I run same query with two tables on MAPJOIN it gives error. Can any tell me what could be the problem? Here is the error log which I am getting from job tracker. java.lang.RuntimeE

Re: Issue with map join

rq_dt STRING) ROW FORMAT SERDE 'com.inmobi.dw.datastore.hive.MySerDe' STORED AS SEQUENCEFILE; Thanks, Jaydep On Friday 24 December 2010 12:23 AM, Namit Jain wrote: Can you send the exact query along with the schema of the tables ? On 12/23/10 1:48 AM, "jaydeep vishwakarma" wrote: Hi, I am

Re: Issue with map join

serde with mapjoin. Is there any thing by that we can tell mapjoin use Serde. Or Mapjoin has not implemented for more than one table on Serde. Regards, Jaydeep On Thursday 23 December 2010 03:18 PM, jaydeep vishwakarma wrote: Hi, I am trying to running some MAPJOIN queries. When I am placing