Please note that the file upload size is limited by the /var/lib/ambary-server/resources and you'll definitely need USE permissions on 'default' as the procedure relies on 'create table as select' from an intermediate table stored in.
... View more
Edit the /etc/hive/conf/beeline-log4j.properties you created by copying from beeline-log4j.properties.template and specify log4j.rootLogger=DEBUG, console
... View more
Please, in the UI, choose | as Field Delimiter character and , as Escape Character and you'll be fine OR use the escape character for what it is designed for by rewriting your text file: abcdef|,ghijkl|,1234|,5678,,,
... View more
I would create a placeholder table on the new data as external with location in hdfs. Your procedure could drop additional files into that location. Subsequently an INSERT INTO query on that one would pull your (delta) updates in.
... View more
Unlike Ambari Predefined Alerts the alerts from e.g. Kafka, Storm, Ranger, Nifi are hard to find, let alone the documentation exists. Inspecting the ambari-alerts.log reveals to us snmp messages regarding them but this is not the way to 'reverse engineer' the definitions. The definition text from the UI is not always corresponding to what is available through said logfile so they are not usefull either. Does someone can guide me to the alert definitions for kafka_broker_process storm_supervisor_process storm_supervisor_process_percent storm_nimbus_process storm_server_process storm_drpc_server storm_webui nifi_status ranger_admin_process ranger_usersync_process Thanks and all the best.
... View more
The author describes his alert script as alerting for allocated space in specified mount points. It is clear (for me) that mountPoints in the alert script is just referring to, indeed, a filesystem mount point.
... View more
The docs available online have typo errors, and some are not displaying correctly, as for example: 'Oozie status' instead of 'Ozie Server Status'. Also wordcap is not respected everywhere in the docs...
... View more
