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

Reply via email to