0

We're using a pre-built cloudera running on Azure, and whilst it seems to work quite well out of the box, there is one oddity that we've not yet figured out.

If you login to the cloudera manager, and click on the Impala service, then the queries tab, it never shows any completed queries. So it's hard to go and find the long running queries.

If you look whilst a query is actually running, you can see them in the list. So it seems to have some sort of very aggressive clearing down, but I can't find what parameter that might be.

Codek
  • 5,114
  • 3
  • 24
  • 38
  • Check this https://community.cloudera.com/t5/Cloudera-Manager-Installation/CM-don-t-show-Impala-queries/td-p/27680 – BruceWayne Oct 04 '16 at 05:45
  • Ah, yes that helped - post it as an answer and i'll accept it and add my detailed solution! – Codek Oct 05 '16 at 13:39

1 Answers1

1

The correction of hwclock time will resolve this issue

BruceWayne
  • 3,286
  • 4
  • 25
  • 35
  • 1
    Correct sort of - The link helped identify the issue. The issue wasnt hwclock, it was timezone. Details here: https://chrisjean.com/change-timezone-in-centos/ And to be precise the issue was on the data nodes, not the master node. Somehow our azure cluster had different timezone configured. – Codek Oct 10 '16 at 10:52