{"action":"created","issue":{"url":"https://api.github.com/repos/rbheemana/Cobol-to-Hive/issues/3","repository_url":"https://api.github.com/repos/rbheemana/Cobol-to-Hive","labels_url":"https://api.github.com/repos/rbheemana/Cobol-to-Hive/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/rbheemana/Cobol-to-Hive/issues/3/comments","events_url":"https://api.github.com/repos/rbheemana/Cobol-to-Hive/issues/3/events","html_url":"https://github.com/rbheemana/Cobol-to-Hive/issues/3","id":113807991,"number":3,"title":"(post comments) Cobol to Hive Serde blog","user":{"login":"rbheemana","id":12659735,"avatar_url":"https://avatars.githubusercontent.com/u/12659735?v=3","gravatar_id":"","url":"https://api.github.com/users/rbheemana","html_url":"https://github.com/rbheemana","followers_url":"https://api.github.com/users/rbheemana/followers","following_url":"https://api.github.com/users/rbheemana/following{/other_user}","gists_url":"https://api.github.com/users/rbheemana/gists{/gist_id}","starred_url":"https://api.github.com/users/rbheemana/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbheemana/subscriptions","organizations_url":"https://api.github.com/users/rbheemana/orgs","repos_url":"https://api.github.com/users/rbheemana/repos","events_url":"https://api.github.com/users/rbheemana/events{/privacy}","received_events_url":"https://api.github.com/users/rbheemana/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":49,"created_at":"2015-10-28T12:17:25Z","updated_at":"2016-08-18T01:11:32Z","closed_at":null,"body":""},"comment":{"url":"https://api.github.com/repos/rbheemana/Cobol-to-Hive/issues/comments/240596431","html_url":"https://github.com/rbheemana/Cobol-to-Hive/issues/3#issuecomment-240596431","issue_url":"https://api.github.com/repos/rbheemana/Cobol-to-Hive/issues/3","id":240596431,"user":{"login":"willddy","id":1769237,"avatar_url":"https://avatars.githubusercontent.com/u/1769237?v=3","gravatar_id":"","url":"https://api.github.com/users/willddy","html_url":"https://github.com/willddy","followers_url":"https://api.github.com/users/willddy/followers","following_url":"https://api.github.com/users/willddy/following{/other_user}","gists_url":"https://api.github.com/users/willddy/gists{/gist_id}","starred_url":"https://api.github.com/users/willddy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/willddy/subscriptions","organizations_url":"https://api.github.com/users/willddy/orgs","repos_url":"https://api.github.com/users/willddy/repos","events_url":"https://api.github.com/users/willddy/events{/privacy}","received_events_url":"https://api.github.com/users/willddy/received_events","type":"User","site_admin":false},"created_at":"2016-08-18T01:11:32Z","updated_at":"2016-08-18T01:11:32Z","body":"I have tested with below two tables. They all work fine.\nNote, ADD statement is only ok for each hive session. In order to use it globally, you need either add it manually where you query the table or add it globally, refer here https://www.cloudera.com/documentation/enterprise/5-4-x/topics/cm_mc_hive_udf.html <https://www.cloudera.com/documentation/enterprise/5-4-x/topics/cm_mc_hive_udf.html> \n\nADD JAR /home/vagrant/mainframe-serde-0.0.1-SNAPSHOT.jar;\nCREATE EXTERNAL TABLE test1\nROW FORMAT SERDE ‘your serve class' \nSTORED AS\nINPUTFORMAT 'org.apache.hadoop.mapred.FixedLengthInputFormat'\nOUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'\nLOCATION '/data/test1'\nTBLPROPERTIES ('cobol.layout.url'='/cpbk/test1/CTRL_DATA.COPYBOOK.TXT','fb.length'='68');\n\nADD JAR /home/vagrant/mainframe-serde-0.0.1-SNAPSHOT.jar;\nCREATE EXTERNAL TABLE test2\nROW FORMAT SERDE ‘your serve class' \nSTORED AS\nINPUTFORMAT 'org.apache.hadoop.mapred.FixedLengthInputFormat'\nOUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'\nLOCATION '/data/test2'\nTBLPROPERTIES ('cobol.layout.url'='/cpbk/test2/CTRL_DATA.COPYBOOK.TXT','fb.length'='68’);\n\n> On Aug 17, 2016, at 11:57 AM, josephlim75 <notifications@github.com> wrote:\n> \n> Hi All,\n> \n> @Mani <https://github.com/Mani>: It works for the way that you exit the CLI and enter again into the hive CLI. This way works. I think somehow the CLI initialize the hive session everything it initiate.\n> \n> The problem is more on using HUE, ZEPPELIN, AMBARI HIVE Views and all sort of the tools. When you first start using any of this tool, and let say you query Table A, somehow this is always cache. Therefore, when I describe Table B, it still give me Table A structure. When I restart the HIVE service, this time, I describe Table B for the first time, it shows me Table B structure. The moment I describe Table A structure, it is showing Table B structure.\n> \n> Is there a way from the tools or any configuration that it reinitialize or reset the cache ?\n> \n> —\n> You are receiving this because you commented.\n> Reply to this email directly, view it on GitHub <https://github.com/rbheemana/Cobol-to-Hive/issues/3#issuecomment-240458573>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABr_FSB2d3yL7dShYEMrI6muicS4NC7Yks5qgy-AgaJpZM4GXSfb>.\n> \n\n"}}
{"actor":{"display_login":"willddy"}}