Hi When the dataFrame will load the table into memory when it reads from HIVe/Phoenix or from any database. These are two points where need one info , when tables will be loaded into memory or cached when at point 1 or point 2 below.
1. DataFrame df = sContext.load("jdbc","(select * from employee) as employee); 2.sContext.sql("select * from employee where wmpid="!");