Categories
OAS and Apache Impala - not opening dashboard
Hi,
I have created a dashboard that fetches data from Apache Impala. However, I've noticed that the queries run quickly in Impala, but the dashboards are taking a long time to open.
Why might this be happening
Answers
-
@User_1X7K6 - Please make sure the version of Impala you are using is certified with OAS.
Reference:
Validate by simply pulling a single column and checking the query execution stats in session log to validate where the max time is spent to identify the bottle neck for starter.
1 -
Impala version is 3.2.
Where can I see the query execution stats in session log ?
0 -
@User_1X7K6 - It can be seen at the end of the session log. Please be informed query stats are recorded only if the query execution is successful.
0 -
I am not aware where session log is
0 -
@User_1X7K6 - Login as an Admin user. Go to Administration —> Manage Sessions. It will have all the logs listed for the analysis and dashboards run in recent times. Select the one you want to review and click on view log.
0 -
I can not find it.
0 -
Click on Session and Query Cache. Earlier suggested navigation is valid if you are navigating from Classic Analytics Home.
0 -
Click on View Log hyperlink under Action column and you can see the details. Also, when certification matrix says 2.7+ it means 3.2 version is uncertified.
Version Numbers logic explained:
"1.6+" means any version starting with 1 and is greater than or equal to (>=) 1.6 (for example, this includes version 1.8 but not version 2.4).
With same logic 3.2 is not a certified version.
Reference:
0 -
Oh, ok. I pressed the view logs but the info is very poor. No duration or steps.
0 -
@User_1X7K6 - You can increase the logging level, please find the details for the same in below document:
0
