i am unable to execute a hql script through beeline. i am trying to perform insert overwrite into a partitioned table by using the below query format getting out of memory error .the table has more than 80 million records. Please help me to resolve this issue.    SET hive.tez.container.size=24576; SET hive.tez.java.opts=-Xmx22528m; insert overwrite table xyz select * from xzy where trim(upper(name))!= 'test' OR trim(upper(loc))!= 'abc'; insert overwrite table def select * from def  where trim(upper(name))!= 'test' OR trim(upper(loc))!= 'abc'; ... View more