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.