[DRILL-792] Joining a hive table with parquet file is returning an empty result set

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Storage - Parquet
• Assignee: Rahul Kumar Challapalli
• Reporter: Rahul Kumar Challapalli
• Created: 20/May/14 22:17
• Updated: 15/Apr/15 20:51
• Resolved: 16/Aug/14 00:28

Description

git.commit.id.abbrev=70fab8c

1. Joining a hive table with parquet results in an empty output. Check below query
select rankings.pageRank pagerank from `dfs/parquet/rankings/` rankings inner join hive.uservisits uservisits on rankings.pageURL = uservisits.destinationurl

2. Joining hive table with hive table seems to work fine
select rankings.pagerank pagerank from hive.rankings rankings inner join hive.uservisits uservisits on rankings.pageurl = uservisits.destinationurl

I attached the parquet and text files required along with the required hive ddl. Let me know if you need more information.