Not sure which version of CDH you met with this issue. Note that the hbase namespace table is a system table required for HBase to function properly.  This table is not handled with a higher priority than other tables as noted in HBASE-14190. If the HBase Master tries to split a WALs on dead or ghost Region Servers then the HBase Master might get stuck trying to split these WALs on invalid Region Servers. The HBase Master can also get stuck trying to split corrupt 83-byte or smaller WAL files on startup in which case just sidelining those blocking WAL files would help. So increasing the hbase.master.namespace.init.timeout may or may not help depending on whether the Master is stuck with any other tasks like WAL splitting.   Another workaround is to recreate the hbase:namespace table in which case it will get loaded quickly. ... View more

Hi,   Looks like there is a connectivity issue from the NM to the Oracle database.   Can you please run the below command from all the Node Managers.   Note:- You need to install telnet utility prior running this command.   ## telnet <oracle full hostname> <oracle port number>   Kindly check if all the NM are able to connect, If any of them is not able to connect then kindly check with network team.   Regards Nitish ... View more

Thank you very much for the detailed answer @mzkdm.   This is indeed a very interesting point. Do you think could make sense to have daily-based partitions, since my main ingestion workflow run once a day? And how can I force Hive or Impala users to use the last point-in-time data?   Thanks for the help! ... View more

10 hours is a long time for a refresh. Since this is a partitoned table, if you know the partitions being added then you could use the new "refresh table ... partition ..." syntax to only look at those partitons.   Alternatively, recover partitions is faster than refresh for partitioned tables if you're only adding new partitions (vs. updating existing ones): https://www.cloudera.com/documentation/enterprise/5-11-x/topics/impala_refresh.html   Regards, Mark ... View more

No, as CDH 5.7 includes Hive 1.1.0 plus backported fixes. But HPL/SQL is also available as a separate download and claims to work with any Hive version per their download page: http://www.hplsql.org/download ... View more