If a query can not be answered by any cube, Kylin supports pushing down to SparkSql to query Hive data source.

Enable Query Pushdown


Do Query Pushdown

After Query Pushdown is configured, user is allowed to do flexible queries to the imported tables without available cubes.

If query is answered by backup engine, Is Query Push-Down is set to true in the log.