SELECT queries that access both Analytics Engine and traditional Ingres tables cannot execute. To cross join data in traditional Ingres and Analytics Engine you have to move the data either into traditional Ingres or into Analytics Engine using INSERT…SELECT or CREATE TABLE AS SELECT.