If you are using Hive 1.3 you can use quarter() built in function.  Since you are using String data type for date  looks like you can use em .    Reference  -  https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF   int quarter(date/timestamp/string) Returns the quarter of the year for a date, timestamp, or string in the range 1 to 4 (as of Hive 1.3.0) Example: quarter('2015-04-08') = 2. ... View more

I am sorry confused here you intial problem is  quote from ur post "This host is not in contact with the Host Monitor." now you say  HOST MONITOR service and other datanode (existing) is working fine - can i assume that the problem is solved or you have new problem arising .    also please share the host monitor and cm agent logs .  ... View more

  <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://localhost/storage.castrading.com</value> </property>   Could you please try the above . Also it clear tells that USER APP does dont have privilege in storage.castrading.com  . I see you have created USER hive and give privilege to  storage.castrading.com. use hive user you should be able to supress this error.   Copying it from your post . I dont see USER APP in the below    mysql> select user,host from mysql.user; +------------+------------------------+ | user | host | +------------+------------------------+ | | % | | % | % | | retail_dba | % | | root | % | | root | 127.0.0.1 | | retail_dba | 192.168.0.227 | | root | 192.168.0.227 | | root | localhost | | root | sotrage.castrading.com | | hive | storage.castrading.com | | root | storage.castrading.com | ... View more

Host Monitor come under the Cloudera manger server  , you could restart    sudo service cloudera-scm-server restart    to see if that fix the issue.  ... View more

Can you restart the Cloudera Manager Agent on that host . to see if it could receive the heart beat ... View more

Whats the status of cloudera-scm-server-db and cloudera-scm-server ?  Please share your Cloudera Manager Agent logs and Host monitor logs for more insight . ... View more

Sqoop - Teradata connector pre requist  - u need a cloudera login u can create one for free.     https://www.cloudera.com/downloads/connectors/sqoop/teradata/1-6c5.html         U need Teradata login credentials . just register with them .    https://www.teradata.com/registration.aspx https://downloads.teradata.com/download/connectivity/jdbc-driver   https://downloads.teradata.com/download/connectivity/jdbc-driver ... View more

Sounds good . mate ... View more