We are seeing these alert daily on our cluster in Ambari. Is there a way to resolve this issue. I see because of too many queries submitted to cluster, this alert has been triggered. We have restarted head node all services, still alert remains. Is there a way to cleanup alert or clean up name node . ... View more

Hi, We are copying files from our upstream system which are in JSON GZ format. They are following a pattern for very daily slice say YYYYMMDDHH (2018053100) they are maintianing two folders DATA and METADATA. Where DATA holds actual data and METADATA holds RowCount of that day's data.We need to create external table on top of copied data, where it only consider *.json.gz extension files only, excluding other file extensions. We dont want to copy files into another location since they are large in size. We also tried INPUT_ FILENAME .... virtual column, it didn't work. Any suggesstion for this scnearios ? ... View more