If a BI query returns no data, check the engine log.
com.atscale.engine.core.Executor - Using fake mode: not actually running query Note:
- Though all Query engine types are set to Impala, the query execution states it's using Hive
2017-06-29 14:46:05,725 INFO [atscale-akka.actor.default-dispatcher-18]
{subqueryId=16e7ac84-180c-4d7a-a22c-0ddc0ab892c2, envId=prod, projectId=0bc2faaa-21f4-4c52-5fc8-e28a01cbad75,
user=lkermen2, orgId=default, queryId=c1354234-6d5f-40ab-9fe4-092ce0636e4e} com.atscale.engine.Queries
- Executing SQL Query (Hive-0.11):
Root cause: for the particular user, training mode is turned ON and thus the query doesn't return any data.
For example:
"lkermen2" : { "training_mode" : { "value" : true },
Also, in training mode, no SQL engine is picked and Hive is shown as a default placeholder.
Answer (resolution):
Turn off training mode for the particular user by following these steps:
1. Login to the Design Center as an Admin user.
2. Click on Admin --> Profile
3. Click on GO to enable the training mode.
4. Click DISABLE to turn off training mode.