{"action":"created","issue":{"url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/586","repository_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop","labels_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/586/labels{/name}","comments_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/586/comments","events_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/586/events","html_url":"https://github.com/elastic/elasticsearch-hadoop/issues/586","id":114288712,"number":586,"title":"java.lang.NoClassDefFoundError: org/apache/commons/httpclient/URIException","user":{"login":"michaelbironneau","id":7848020,"avatar_url":"https://avatars.githubusercontent.com/u/7848020?v=3","gravatar_id":"","url":"https://api.github.com/users/michaelbironneau","html_url":"https://github.com/michaelbironneau","followers_url":"https://api.github.com/users/michaelbironneau/followers","following_url":"https://api.github.com/users/michaelbironneau/following{/other_user}","gists_url":"https://api.github.com/users/michaelbironneau/gists{/gist_id}","starred_url":"https://api.github.com/users/michaelbironneau/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michaelbironneau/subscriptions","organizations_url":"https://api.github.com/users/michaelbironneau/orgs","repos_url":"https://api.github.com/users/michaelbironneau/repos","events_url":"https://api.github.com/users/michaelbironneau/events{/privacy}","received_events_url":"https://api.github.com/users/michaelbironneau/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/v2.1.3","name":"v2.1.3","color":"bfdadc"},{"url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/labels/v2.2.0-rc1","name":"v2.2.0-rc1","color":"bfdadc"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-10-30T15:11:42Z","updated_at":"2016-03-04T10:17:44Z","closed_at":"2016-01-08T19:56:50Z","body":"I can't get Hive to run an INSERT query into an external table stored in Elasticsearch. I'm using build elasticsearch-hadoop-2.2.0.BUILD-20151030.024731-132 with Elasticsearch 2.0 and Hive 1.2.1. The query is something like this:\r\n\r\n```\r\nadd jar hdfs:///tmp/elasticsearch-hadoop.jar;\r\nINSERT OVERWRITE TABLE [external table stored in Elasticsearch]\r\n    SELECT\r\n      [some columns]\r\nFROM [some table]\r\n```\r\n\r\nWhen I perform the INSERT query, I get the following exception:\r\n\r\n```Caused by: java.lang.RuntimeException: Map operator initialization failed\r\nat org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:247)\r\nat org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:147)\r\n... 14 more\r\nCaused by: java.lang.NoClassDefFoundError: org/apache/commons/httpclient/URIException\r\nat org.elasticsearch.hadoop.hive.HiveUtils.structObjectInspector(HiveUtils.java:57)\r\nat org.elasticsearch.hadoop.hive.EsSerDe.initialize(EsSerDe.java:82)\r\nat org.elasticsearch.hadoop.hive.EsSerDe.initialize(EsSerDe.java:97)\r\nat org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:356)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:363)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:482)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:439)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:376)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:482)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:439)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:376)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:482)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:439)\r\nat org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:376)\r\nat org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:232)\r\n... 15 more```\r\n\r\nIs there a compatibility problem with this version of Hive, or do I need to include a different JAR?\r\n\r\nThanks"},"comment":{"url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/comments/192221116","html_url":"https://github.com/elastic/elasticsearch-hadoop/issues/586#issuecomment-192221116","issue_url":"https://api.github.com/repos/elastic/elasticsearch-hadoop/issues/586","id":192221116,"user":{"login":"sasauz","id":897489,"avatar_url":"https://avatars.githubusercontent.com/u/897489?v=3","gravatar_id":"","url":"https://api.github.com/users/sasauz","html_url":"https://github.com/sasauz","followers_url":"https://api.github.com/users/sasauz/followers","following_url":"https://api.github.com/users/sasauz/following{/other_user}","gists_url":"https://api.github.com/users/sasauz/gists{/gist_id}","starred_url":"https://api.github.com/users/sasauz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sasauz/subscriptions","organizations_url":"https://api.github.com/users/sasauz/orgs","repos_url":"https://api.github.com/users/sasauz/repos","events_url":"https://api.github.com/users/sasauz/events{/privacy}","received_events_url":"https://api.github.com/users/sasauz/received_events","type":"User","site_admin":false},"created_at":"2016-03-04T10:17:44Z","updated_at":"2016-03-04T10:17:44Z","body":"@costin Thank you for your question. I have commons-httpclient-3.0.1.jar in hive/lib and commons-httpclient-**3.1** in hadoop/lib, but it still doesn't work. I add manually commons-httpclient-**3.1**.jar (from hdfs://user/oozie/share/lib) and elasticsearch-hive-2.2.0.jar every time when I run a query.\r\n\r\nI have now 3 servers in Hadoop-Cluster (Master1, Secondary Master2, and Slave1). Should I insert commons-httpclient-3.1.jar in hadoop/lib and hive/lib in all 3 servers? or only on Slave1? "}}