{"action":"closed","issue":{"url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/123","labels_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/123/labels{/name}","comments_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/123/comments","events_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/123/events","html_url":"https://github.com/rcongiu/Hive-JSON-Serde/issues/123","id":115932539,"number":123,"title":"org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.openx.data.jsonserde.JsonSerDe","user":{"login":"pmgriffin","id":432344,"avatar_url":"https://avatars.githubusercontent.com/u/432344?v=3","gravatar_id":"","url":"https://api.github.com/users/pmgriffin","html_url":"https://github.com/pmgriffin","followers_url":"https://api.github.com/users/pmgriffin/followers","following_url":"https://api.github.com/users/pmgriffin/following{/other_user}","gists_url":"https://api.github.com/users/pmgriffin/gists{/gist_id}","starred_url":"https://api.github.com/users/pmgriffin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pmgriffin/subscriptions","organizations_url":"https://api.github.com/users/pmgriffin/orgs","repos_url":"https://api.github.com/users/pmgriffin/repos","events_url":"https://api.github.com/users/pmgriffin/events{/privacy}","received_events_url":"https://api.github.com/users/pmgriffin/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-11-09T18:05:59Z","updated_at":"2015-12-16T02:43:55Z","closed_at":"2015-12-16T02:43:55Z","body":"Hi there,\r\n\r\ni'm hoping you'll be able to assist me please, i'm running HortonWorks HDP sandbox v2.3, have built your Serde using \"mvn -Phdp23 clean package\" and added the resulting JAR file on Hive shell as follows:\r\n\r\nhive> add JAR /home/trustev/json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar\r\n    > ;\r\nAdded [/home/trustev/json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar] to class path\r\nAdded resources: [/home/trustev/json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar]\r\nhive>\r\n\r\nMy table definition is as follows:\r\n\r\nCREATE EXTERNAL TABLE TestWithSerde(\r\nkey string,\r\nmyObj  \"my schema hidden for confidentiality\"\r\n)\r\nROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe';\r\nSTORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'\r\nWITH SERDEPROPERTIES ( \"mapping.ts\" = \"timestamp\" ) \r\nWITH SERDEPROPERTIES (\"hbase.columns.mapping\" = \":key,object:myval\")\r\nTBLPROPERTIES ('hbase.table.name' = 'Tbl_XXXX');\r\n\r\nAny help is greatly appreaciated.\r\n\r\nNote i restarted ambari in an attempt to ensure the jar was loaded but it did not resolve the issue.\r\n\r\nI built the Serde on windows and then deployed to CentOS 7 box ... would that have anything to do with it maybe? "}}