{"action":"created","issue":{"url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/703","repository_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop","labels_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/703/labels{/name}","comments_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/703/comments","events_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/703/events","html_url":"https://github.com/elastic/elasticsearch-hadoop/issues/703","id":135061077,"number":703,"title":"Issue connecting to ES Found","user":{"login":"driadi","id":9815020,"avatar_url":"https://avatars.githubusercontent.com/u/9815020?v=3","gravatar_id":"","url":"https://api.github.com/users/driadi","html_url":"https://github.com/driadi","followers_url":"https://api.github.com/users/driadi/followers","following_url":"https://api.github.com/users/driadi/following{/other_user}","gists_url":"https://api.github.com/users/driadi/gists{/gist_id}","starred_url":"https://api.github.com/users/driadi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/driadi/subscriptions","organizations_url":"https://api.github.com/users/driadi/orgs","repos_url":"https://api.github.com/users/driadi/repos","events_url":"https://api.github.com/users/driadi/events{/privacy}","received_events_url":"https://api.github.com/users/driadi/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/labels/hive","name":"hive","color":"02d7e1"},{"url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/labels/spark","name":"spark","color":"006b75"},{"url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/labels/v2.2.1","name":"v2.2.1","color":"bfdadc"},{"url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/labels/v2.3.0-m1","name":"v2.3.0-m1","color":"bfdadc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-02-20T11:03:35Z","updated_at":"2016-04-06T17:25:52Z","closed_at":null,"body":"I am trying to integrate ES Found and Hadoop with this Hive create table definition below: \r\n```\r\nCREATE EXTERNAL TABLE es_event ( ... )\r\nSTORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'\r\nTBLPROPERTIES('es.resource' = 'test',\r\n'es.index.auto.create' = 'true',\r\n'es.nodes' = 'found-host:9200';\r\n```\r\n\r\nHowever I am always getting `EsHadoopInvalidRequest: null` every time I attempt to connect to the ES cluster and get the data. Looking closer to the code itself, it seems that the error is caused by **404 Not Found** response when the library attempts to hit the ES API oddly by using the IP address instead of the provided host name?\r\n\r\nManually hitting the same address (ie. x.x.x.x:9200) on the browser returns with the error like:\r\n`{\"ok\":false,\"message\":\"Unknown cluster.\"}`\r\n\r\nwhich I expected to return this instead:\r\n```\r\n{\r\n  \"status\" : 200,\r\n  \"name\" : \"instance-0000000000\",\r\n  \"cluster_name\" : \"xxx\",\r\n  \"version\" : {\r\n    \"number\" : \"1.7.5\",\r\n    \"build_hash\" : \"xxx\",\r\n    \"build_timestamp\" : \"2016-02-02T09:55:30Z\",\r\n    \"build_snapshot\" : false,\r\n    \"lucene_version\" : \"4.10.4\"\r\n  },\r\n  \"tagline\" : \"You Know, for Search\"\r\n}\r\n```\r\n\r\nAny idea what causes this issue? Perhaps there is a setting that I missed?\r\n\r\nThanks for the support."},"comment":{"url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/comments/206475583","html_url":"https://github.com/elastic/elasticsearch-hadoop/issues/703#issuecomment-206475583","issue_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/703","id":206475583,"user":{"login":"costin","id":76245,"avatar_url":"https://avatars.githubusercontent.com/u/76245?v=3","gravatar_id":"","url":"https://api.github.com/users/costin","html_url":"https://github.com/costin","followers_url":"https://api.github.com/users/costin/followers","following_url":"https://api.github.com/users/costin/following{/other_user}","gists_url":"https://api.github.com/users/costin/gists{/gist_id}","starred_url":"https://api.github.com/users/costin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/costin/subscriptions","organizations_url":"https://api.github.com/users/costin/orgs","repos_url":"https://api.github.com/users/costin/repos","events_url":"https://api.github.com/users/costin/events{/privacy}","received_events_url":"https://api.github.com/users/costin/received_events","type":"User","site_admin":false},"created_at":"2016-04-06T17:25:52Z","updated_at":"2016-04-06T17:25:52Z","body":"The issue of resolving the hostname to IPs has been fixed in master - if not set it will default to true (convert) for non-wan scenarios, false otherwise.\r\nI've just ran another test against Found/Cloud without any issues. Can you please try the [dev](https://www.elastic.co/guide/en/elasticsearch/hadoop/master/install.html#download-dev) build?"}}