[ https://issues.apache.org/jira/browse/DRILL-792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli closed DRILL-792. ----------------------------------- Verified this. Thanks for the fix > Joining a hive table with parquet file is returning an empty result set > ----------------------------------------------------------------------- > > Key: DRILL-792 > URL: https://issues.apache.org/jira/browse/DRILL-792 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Parquet > Reporter: Rahul Challapalli > Assignee: Rahul Challapalli > Priority: Critical > Fix For: 0.5.0 > > Attachments: 792.ddl, rankings.parquet, rankings.txt, > uservisits.parquet, uservisits.txt > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)