Copied whole data folder from original Hive project
Ensured hive conf file ( hive-site.xml ) is copied into test resources. This was one main cause of Test Constructor failure.
Within Test Code , forced flag of standAloneServer to be true ; to succeed connect to Hive server of Hortonworks Sandbox
Found the following :

When upload files through Hadoop , it is actually through HDFS and "LOAD DATA LOCAL INPATH" doesn't work with the paths as seen in FileBrowser.
And if used without LOCAL it succeeds but get file MOVED causing rest of Test to fail.

To have the path specified in hive-site.xml at property "test.data.files" works , must upload files via SFTP.

Now in state that only one test method fails : "testDatabaseMetaData" at asserting Hive Version equality