[ https://issues.apache.org/jira/browse/HIVE-8189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yongzhi Chen updated HIVE-8189: ------------------------------- Attachment: HIVE-8189.1.patch Need code review. The patch is for trunk, Problem: 1) Predicates are used to filter out regions in hbase which do not need to 2) The predicates are sticking around in the jobConf from table with predic Solution: removing the predicates before we reset them we remove this bad stat > A select statement with a subquery is failing with HBaseSerde > ------------------------------------------------------------- > > Key: HIVE-8189 > URL: https://issues.apache.org/jira/browse/HIVE-8189 > Project: Hive > Issue Type: Bug > Affects Versions: 0.12.0, 0.13.1 > Reporter: Yongzhi Chen > Attachments: HIVE-8189.1.patch, hbase_ppd_join.q > > > Hive tables in the query are hbase tables, and the subquery is a join > statement. > When > set hive.optimize.ppd=true; > and > set hive.auto.convert.join=false; > The query does not return data. > While hive.optimize.ppd=true and hive.auto.convert.join=true return values > back. See attached query file. -- This message was sent by Atlassian JIRA (v6.3.4#6332)