There is a problem when I run a hql for create a cache table . create table zzmm1_cached TBLPROPERTIES ("shark.cache" = "true") as select * from (select a.*,b.* from zzmm1 a left outer join zyd b where a.city_id=1 ) c it show me [Hive Error]: Query returned non-zero code: 12, cause: FAILED: Hive Internal Error: java.lang.NullPointerException(null)
but if I remove where condition , it runs well . create table zzmm1_cached TBLPROPERTIES ("shark.cache" = "true") as select * from (select a.*,b.* from zzmm1 a left outer join zyd b ) c I want to know why the shark interpreter could't explain where condition in the subquery ? THX ! leosand...@gmail.com