@Jung Heedong Of course, it may be best to start a new post if you still have any issues, as it will have better visibility. You can tag users (ex. me) in posts by typing '@' followed by their username. That way we get notified when you post 🙂 ... View more

@Jung Heedong Please refer to this JIRA: https://issues.apache.org/jira/browse/KNOX-1074 You can try the following workaround, if you are unable to upgrade by making changes in service.xml and rewrite.xml. You'd find these at /var/lib/knox/data-<yourHDPversion>/services/ambariui/2.2.0/service.xml /var/lib/knox/data-<yourHDPversion>/services/ambariui/2.2.0/rewrite.xml Add the following rule in service.xml <route path="/ambari/api/v1/views/WORKFLOW_MANAGER/versions/**/instances/testwfm/resources/proxy/**"> <rewrite apply="AMBARI/ambari/api/outbound/workflowmanager" to="response.body"/> </route> And a rule in rewrite.xml <filter name="AMBARI/ambari/api/outbound/workflowmanager"> <content type="text/plain" asType="text/xml"> </content> </filter> (restart knox afterwards) Please take a moment to click accept answer, if this helped you. It will help others find the solution quickly, when looking for the same issue online. ... View more

@Jung Heedong Does accessing the workflow manager view work OK when you're bypassing knox and accessing via ambari directly? You may be running into a known issue, regarding WFM which results in the 'remote API failed' error if accessed through knox. This is resolved in HDP 3. ... View more

Hi @Sivakumar Mahalingam Try creating your table like this instead; CREATE TABLE IF NOT EXISTS employee2 (eid int, name String,salary String) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH SERDEPROPERTIES ("field.delim"="^A","line.delim" = '\n') STORED AS TEXTFILE; PS. If this helps to resolve your issue, please take a moment to click accept answer 🙂 ... View more

@Wil Don Glad to hear your issue got resolved 🙂 If you have a moment please click accept answer so that others will be able to find the solutions quickly when searching for the same issue on the community site ... View more