Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> Self join issue

Copy link to this message
Self join issue

I just raised a ticket for a table with self join query. Table is created
with json serde provided by cloudera.

When  I run a single query on the table like select col from table where
col='xyz', this works perfectly fine with a mapreduce job.

but when I try to run the query of self join on the table it says serde not
found on query parsing.

i have mentioned the steps in detail on JIRA

Can somebody tell what's special when the query is parsed for join and
stand alone query?

Due to this issue, I have to create temporary tables and make sure I clean
them up myself after the jobs are over.

Nitin Pawar