Ambari and ps command can show you that ZK service and ZK process is running on respective nodes, but only after "zkService.sh status" shows you that one node is the leader and the others are followers you can be absolutely certain that ZK is running and fully functional. You can run it using pdsh and targeting only ZK nodes. ... View more

Hi @R Wys, I just tried, but for me your regexp works as-is from Hive command line! Try testing only that part SELECT daily_date, regexp_replace(substr(from_unixtime(unix_timestamp(trim(daily_date),'dd/MM/yyyy')),0,7),"-","")as month FROM staging_table; Was that error with the command you posted, or with another version? Your posted version looks good, replace 0 by 1 as the substring starting index (as per specs), it works with 0 but better follow the specs. You can also try to escape "-" by "\-". Here is my result, note that my date-time field is in different format: hive> select s, regexp_replace(substr(from_unixtime(unix_timestamp(trim(s), 'yyyy-MM-dd')),0,7),"-","") as month from yr; OK s month 1975-01-01 00:00:00 197501 1999-10-12 199910 2016-03-22 10:20:30.155 201603 2001-07-07 11:00:05.0 200107 Time taken: 0.563 seconds, Fetched: 4 row(s) ... View more

Check which hosts are registerd with Ambari, from Ambari server run curl -u admin:admin http://localhost:8080/api/v1/clusters/CLUSTER_NAME/hosts My guess is that your Machine1 is there, registered as "machine1" (all lower-case letters). Then, try adding a new host "machine1". By the way, it's the best to avoid using capitals in host names. ... View more

Check your jobTracker setting in your job.properties, you had "jobTracker=hdp1.cidev:8050" in your question. And make sure you use "-conf job.properties" when you submit your job. ... View more