{"action":"closed","number":789,"pull_request":{"url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls/789","id":59377813,"html_url":"https://github.com/telefonicaid/fiware-cygnus/pull/789","diff_url":"https://github.com/telefonicaid/fiware-cygnus/pull/789.diff","patch_url":"https://github.com/telefonicaid/fiware-cygnus/pull/789.patch","issue_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues/789","number":789,"state":"closed","locked":false,"title":"bug/781_avoid_generalized_hive_encoding","user":{"login":"frbattid","id":3865056,"avatar_url":"https://avatars.githubusercontent.com/u/3865056?v=3","gravatar_id":"","url":"https://api.github.com/users/frbattid","html_url":"https://github.com/frbattid","followers_url":"https://api.github.com/users/frbattid/followers","following_url":"https://api.github.com/users/frbattid/following{/other_user}","gists_url":"https://api.github.com/users/frbattid/gists{/gist_id}","starred_url":"https://api.github.com/users/frbattid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frbattid/subscriptions","organizations_url":"https://api.github.com/users/frbattid/orgs","repos_url":"https://api.github.com/users/frbattid/repos","events_url":"https://api.github.com/users/frbattid/events{/privacy}","received_events_url":"https://api.github.com/users/frbattid/received_events","type":"User","site_admin":false},"body":"* Fixes issue #781 (into develop)\r\n* 100% unit tests passed:\r\n```\r\nTests run: 80, Failures: 0, Errors: 0, Skipped: 0\r\n```\r\n* (unofficial) e2e tests passed:\r\n\r\nSubscription:\r\n\r\n```\r\n{\r\n  \"subscriptionId\" : \"51c0ac9ed714fb3b37d7d5a8\",\r\n  \"originator\" : \"localhost\",\r\n  \"contextResponses\" : [\r\n    {\r\n      \"contextElement\" : {\r\n        \"attributes\" : [\r\n          {\r\n            \"name\" : \"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\",\r\n            \"type\" : \"centigrade\",\r\n            \"value\" : \"10.673299789428711\",\r\n            \"metadatas\": [{\"name\":\"dofTimestamp\",\"type\":\"ms\",\"value\":\"2016-02-08T23:00:00.000Z\"},{\"name\":\"tag\",\"type\":\"text\",\"value\":\"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\"},{\"name\":\"description\",\"type\":\"text\",\"value\":\"Electrical heat load\"},{\"name\":\"quality\",\"type\":\"0:GOOD, +0:ERROR\",\"value\":\"10813440\"},{\"name\":\"max\",\"type\":\"max\",\"value\":\"null\"},{\"name\":\"min\",\"type\":\"min\",\"value\":\"null\"},{\"name\":\"lcl\",\"type\":\"lcl\",\"value\":\"null\"},{\"name\":\"ucl\",\"type\":\"ucl\",\"value\":\"null\"}]\r\n          }\r\n        ],\r\n        \"type\" : \"ETS\",\r\n        \"isPattern\" : \"false\",\r\n        \"id\" : \"ORL.SOU.DH.SSTA10\"\r\n      },\r\n      \"statusCode\" : {\r\n        \"code\" : \"200\",\r\n        \"reasonPhrase\" : \"OK\"\r\n      }\r\n    }\r\n  ]\r\n}\r\n```\r\n\r\n`json-row`:\r\n\r\n```\r\ntime=2016-02-15T17:06:27.686CET | lvl=INFO | trans=1455552357-95-0000000000 | svc=test | subsvc=hdfs | function=persistAggregation | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[937] : [hdfs-sink] Persisting data at OrionHDFSSink. HDFS file (test/hdfs/orl.sou.dh.ssta10_ets/orl.sou.dh.ssta10_ets.txt), Data ({\"recvTimeTs\":\"1455552370\",\"recvTime\":\"2016-02-15T16:06:10.819Z\",\"fiwareServicePath\":\"hdfs\",\"entityId\":\"ORL.SOU.DH.SSTA10\",\"entityType\":\"ETS\",\"attrName\":\"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\",\"attrType\":\"centigrade\",\"attrValue\":\"10.673299789428711\",\"attrMd\":[{\"name\":\"dofTimestamp\",\"type\":\"ms\",\"value\":\"2016-02-08T23:00:00.000Z\"},{\"name\":\"tag\",\"type\":\"text\",\"value\":\"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\"},{\"name\":\"description\",\"type\":\"text\",\"value\":\"Electrical heat load\"},{\"name\":\"quality\",\"type\":\"0:GOOD, +0:ERROR\",\"value\":\"10813440\"},{\"name\":\"max\",\"type\":\"max\",\"value\":\"null\"},{\"name\":\"min\",\"type\":\"min\",\"value\":\"null\"},{\"name\":\"lcl\",\"type\":\"lcl\",\"value\":\"null\"},{\"name\":\"ucl\",\"type\":\"ucl\",\"value\":\"null\"}]})\r\ntime=2016-02-15T17:06:28.339CET | lvl=INFO | trans=1455552357-95-0000000000 | svc=test | subsvc=hdfs | function=provisionHiveTable | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[988] : Creating Hive external table 'frb_test_hdfs_orl_sou_dh_ssta10_ets_row' in database 'default'\r\n..\r\n$ hadoop fs -cat test/hdfs/orl.sou.dh.ssta10_ets/orl.sou.dh.ssta10_ets.txt\r\n{\"recvTimeTs\":\"1455552370\",\"recvTime\":\"2016-02-15T16:06:10.819Z\",\"fiwareServicePath\":\"hdfs\",\"entityId\":\"ORL.SOU.DH.SSTA10\",\"entityType\":\"ETS\",\"attrName\":\"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\",\"attrType\":\"centigrade\",\"attrValue\":\"10.673299789428711\",\"attrMd\":[{\"name\":\"dofTimestamp\",\"type\":\"ms\",\"value\":\"2016-02-08T23:00:00.000Z\"},{\"name\":\"tag\",\"type\":\"text\",\"value\":\"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\"},{\"name\":\"description\",\"type\":\"text\",\"value\":\"Electrical heat load\"},{\"name\":\"quality\",\"type\":\"0:GOOD, +0:ERROR\",\"value\":\"10813440\"},{\"name\":\"max\",\"type\":\"max\",\"value\":\"null\"},{\"name\":\"min\",\"type\":\"min\",\"value\":\"null\"},{\"name\":\"lcl\",\"type\":\"lcl\",\"value\":\"null\"},{\"name\":\"ucl\",\"type\":\"ucl\",\"value\":\"null\"}]}\r\n..\r\nhive> describe frb_test_hdfs_orl_sou_dh_ssta10_ets_row;\r\nOK\r\nrecvtimets          \tbigint              \tfrom deserializer   \r\nrecvtime            \tstring              \tfrom deserializer   \r\nfiwareservicepath   \tstring              \tfrom deserializer   \r\nentityid            \tstring              \tfrom deserializer   \r\nentitytype          \tstring              \tfrom deserializer   \r\nattrname            \tstring              \tfrom deserializer   \r\nattrtype            \tstring              \tfrom deserializer   \r\nattrvalue           \tstring              \tfrom deserializer   \r\nattrmd              \tarray<struct<name:string,type:string,value:string>>\tfrom deserializer   \r\nTime taken: 0.254 seconds, Fetched: 9 row(s)\r\nhive> select * from frb_test_hdfs_orl_sou_dh_ssta10_ets_row;\r\nOK\r\n1455552370\t2016-02-15T16:06:10.819Z\thdfs\tORL.SOU.DH.SSTA10\tETS\tORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\tcentigrade\t10.673299789428711\t[{\"name\":\"dofTimestamp\",\"type\":\"ms\",\"value\":\"2016-02-08T23:00:00.000Z\"},{\"name\":\"tag\",\"type\":\"text\",\"value\":\"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\"},{\"name\":\"description\",\"type\":\"text\",\"value\":\"Electrical heat load\"},{\"name\":\"quality\",\"type\":\"0:GOOD, +0:ERROR\",\"value\":\"10813440\"},{\"name\":\"max\",\"type\":\"max\",\"value\":\"null\"},{\"name\":\"min\",\"type\":\"min\",\"value\":\"null\"},{\"name\":\"lcl\",\"type\":\"lcl\",\"value\":\"null\"},{\"name\":\"ucl\",\"type\":\"ucl\",\"value\":\"null\"}]\r\nTime taken: 0.742 seconds, Fetched: 1 row(s)\r\n```\r\n\r\n`json-column`:\r\n\r\n```\r\ntime=2016-02-15T17:31:28.120CET | lvl=INFO | trans=1455553857-232-0000000000 | svc=test | subsvc=hdfs | function=persistAggregation | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[937] : [hdfs-sink] Persisting data at OrionHDFSSink. HDFS file (test/hdfs/orl.sou.dh.ssta10_ets/orl.sou.dh.ssta10_ets.txt), Data ({\"recvTime\":\"2016-02-15T16:31:01.972Z\",\"fiwareServicePath\":\"hdfs\",\"entityId\":\"ORL.SOU.DH.SSTA10\",\"entityType\":\"ETS\", \"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\":\"10.673299789428711\", \"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_md\":[{\"name\":\"dofTimestamp\",\"type\":\"ms\",\"value\":\"2016-02-08T23:00:00.000Z\"},{\"name\":\"tag\",\"type\":\"text\",\"value\":\"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\"},{\"name\":\"description\",\"type\":\"text\",\"value\":\"Electrical heat load\"},{\"name\":\"quality\",\"type\":\"0:GOOD, +0:ERROR\",\"value\":\"10813440\"},{\"name\":\"max\",\"type\":\"max\",\"value\":\"null\"},{\"name\":\"min\",\"type\":\"min\",\"value\":\"null\"},{\"name\":\"lcl\",\"type\":\"lcl\",\"value\":\"null\"},{\"name\":\"ucl\",\"type\":\"ucl\",\"value\":\"null\"}]})\r\ntime=2016-02-15T17:31:28.947CET | lvl=INFO | trans=1455553857-232-0000000000 | svc=test | subsvc=hdfs | function=provisionHiveTable | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[988] : Creating Hive external table 'frb_test_hdfs_orl_sou_dh_ssta10_ets_column' in database 'default'\r\n..\r\n$ hadoop fs -cat test/hdfs/orl.sou.dh.ssta10_ets/orl.sou.dh.ssta10_ets.txt\r\n{\"recvTime\":\"2016-02-15T16:31:01.972Z\",\"fiwareServicePath\":\"hdfs\",\"entityId\":\"ORL.SOU.DH.SSTA10\",\"entityType\":\"ETS\", \"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\":\"10.673299789428711\", \"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_md\":[{\"name\":\"dofTimestamp\",\"type\":\"ms\",\"value\":\"2016-02-08T23:00:00.000Z\"},{\"name\":\"tag\",\"type\":\"text\",\"value\":\"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\"},{\"name\":\"description\",\"type\":\"text\",\"value\":\"Electrical heat load\"},{\"name\":\"quality\",\"type\":\"0:GOOD, +0:ERROR\",\"value\":\"10813440\"},{\"name\":\"max\",\"type\":\"max\",\"value\":\"null\"},{\"name\":\"min\",\"type\":\"min\",\"value\":\"null\"},{\"name\":\"lcl\",\"type\":\"lcl\",\"value\":\"null\"},{\"name\":\"ucl\",\"type\":\"ucl\",\"value\":\"null\"}]}\r\n..\r\nhive> describe frb_test_hdfs_orl_sou_dh_ssta10_ets_column;                                                                                                                           OK                                                                                                                                                                                   recvtime                string                  from deserializer                        \r\nfiwareservicepath   \tstring              \tfrom deserializer   \r\nentityid            \tstring              \tfrom deserializer   \r\nentitytype          \tstring              \tfrom deserializer   \r\norl_sou_dh_ssta10_t_hvac_heatload\tstring              \tfrom deserializer   \r\norl_sou_dh_ssta10_t_hvac_heatload_md\tarray<struct<name:string,type:string,value:string>>\tfrom deserializer   \r\nTime taken: 0.174 seconds, Fetched: 6 row(s)\r\nhive> select ORL_SOU_DH_SSTA10_T_HVAC_HeatLoad from frb_test_hdfs_orl_sou_dh_ssta10_ets_column;   \r\nTotal jobs = 1\r\nLaunching Job 1 out of 1\r\nNumber of reduce tasks is set to 0 since there's no reduce operator\r\nStarting Job = job_201507101501_42469, Tracking URL = http://cosmosmaster-gi:50030/jobdetails.jsp?jobid=job_201507101501_42469\r\nKill Command = /usr/lib/hadoop-0.20/bin/hadoop job  -kill job_201507101501_42469\r\nHadoop job information for Stage-1: number of mappers: 1; number of reducers: 0\r\n2016-02-16 07:39:31,001 Stage-1 map = 0%,  reduce = 0%\r\n2016-02-16 07:39:34,014 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 0.87 sec\r\n2016-02-16 07:39:35,020 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 0.87 sec\r\nMapReduce Total cumulative CPU time: 870 msec\r\nEnded Job = job_201507101501_42469\r\nMapReduce Jobs Launched: \r\nJob 0: Map: 1   Cumulative CPU: 0.87 sec   HDFS Read: 1573 HDFS Write: 38 SUCCESS\r\nTotal MapReduce CPU Time Spent: 870 msec\r\nOK\r\n10.673299789428711\r\nTime taken: 7.255 seconds, Fetched: 1 row(s)\r\nhive> select ORL_SOU_DH_SSTA10_T_HVAC_HeatLoad_md from frb_test_hdfs_orl_sou_dh_ssta10_ets_column;\r\nTotal jobs = 1\r\nLaunching Job 1 out of 1\r\nNumber of reduce tasks is set to 0 since there's no reduce operator\r\nStarting Job = job_201507101501_42470, Tracking URL = http://cosmosmaster-gi:50030/jobdetails.jsp?jobid=job_201507101501_42470\r\nKill Command = /usr/lib/hadoop-0.20/bin/hadoop job  -kill job_201507101501_42470\r\nHadoop job information for Stage-1: number of mappers: 1; number of reducers: 0\r\n2016-02-16 07:39:57,088 Stage-1 map = 0%,  reduce = 0%\r\n2016-02-16 07:39:59,099 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 0.8 sec\r\n2016-02-16 07:40:00,108 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 0.8 sec\r\nMapReduce Total cumulative CPU time: 800 msec\r\nEnded Job = job_201507101501_42470\r\nMapReduce Jobs Launched: \r\nJob 0: Map: 1   Cumulative CPU: 0.8 sec   HDFS Read: 1573 HDFS Write: 416 SUCCESS\r\nTotal MapReduce CPU Time Spent: 800 msec\r\nOK\r\n[{\"name\":\"dofTimestamp\",\"type\":\"ms\",\"value\":\"2016-02-08T23:00:00.000Z\"},{\"name\":\"tag\",\"type\":\"text\",\"value\":\"ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\"},{\"name\":\"description\",\"type\":\"text\",\"value\":\"Electrical heat load\"},{\"name\":\"quality\",\"type\":\"0:GOOD, +0:ERROR\",\"value\":\"10813440\"},{\"name\":\"max\",\"type\":\"max\",\"value\":\"null\"},{\"name\":\"min\",\"type\":\"min\",\"value\":\"null\"},{\"name\":\"lcl\",\"type\":\"lcl\",\"value\":\"null\"},{\"name\":\"ucl\",\"type\":\"ucl\",\"value\":\"null\"}]\r\nTime taken: 7.007 seconds, Fetched: 1 row(s)\r\n```\r\n\r\n`csv-row`:\r\n\r\n```\r\ntime=2016-02-16T07:59:04.893CET | lvl=INFO | trans=1455605914-357-0000000000 | svc=test | subsvc=hdfs | function=persistAggregation | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[937] : [hdfs-sink] Persisting data at OrionHDFSSink. HDFS file (test/hdfs/orl.sou.dh.ssta10_ets/orl.sou.dh.ssta10_ets.txt), Data (1455605927,2016-02-16T06:58:47.598Z,hdfs,ORL.SOU.DH.SSTA10,ETS,ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad,centigrade,10.673299789428711,hdfs:///user/frb/test/hdfs/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade.txt)\r\ntime=2016-02-16T07:59:06.555CET | lvl=INFO | trans=1455605914-357-0000000000 | svc=test | subsvc=hdfs | function=provisionHiveTable | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[988] : Creating Hive external table 'frb_test_hdfs_orl_sou_dh_ssta10_ets_row' in database 'default'\r\n..\r\n$ hadoop fs -cat test/hdfs/orl.sou.dh.ssta10_ets/orl.sou.dh.ssta10_ets.txt\r\n1455605927,2016-02-16T06:58:47.598Z,hdfs,ORL.SOU.DH.SSTA10,ETS,ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad,centigrade,10.673299789428711,hdfs:///user/frb/test/hdfs/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade.txt\r\n$ hadoop fs -cat test/hdfs/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade.txt\r\n1455605927598,dofTimestamp,ms,2016-02-08T23:00:00.000Z\r\n1455605927598,tag,text,ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\r\n1455605927598,description,text,Electrical heat load\r\n1455605927598,quality,0:GOOD, +0:ERROR,10813440\r\n1455605927598,max,max,null\r\n1455605927598,min,min,null\r\n1455605927598,lcl,lcl,null\r\n1455605927598,ucl,ucl,null\r\n..\r\nhive> describe frb_test_hdfs_orl_sou_dh_ssta10_ets_row;\r\nOK\r\nrecvtimets          \tbigint              \t                    \r\nrecvtime            \tstring              \t                    \r\nfiwareservicepath   \tstring              \t                    \r\nentityid            \tstring              \t                    \r\nentitytype          \tstring              \t                    \r\nattrname            \tstring              \t                    \r\nattrtype            \tstring              \t                    \r\nattrvalue           \tstring              \t                    \r\nattrmdfile          \tstring              \t                    \r\nTime taken: 0.278 seconds, Fetched: 9 row(s)\r\nhive> select * from frb_test_hdfs_orl_sou_dh_ssta10_ets_row;\r\nOK\r\n1455605927\t2016-02-16T06:58:47.598Z\thdfs\tORL.SOU.DH.SSTA10\tETS\tORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\tcentigrade\t10.673299789428711\thdfs:///user/frb/test/hdfs/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade.txt\r\nTime taken: 0.469 seconds, Fetched: 1 row(s)\r\n```\r\n\r\n`csv-column`:\r\n\r\n```\r\ntime=2016-02-16T08:09:21.953CET | lvl=INFO | trans=1455606529-775-0000000000 | svc=test | subsvc=hdfs | function=persistAggregation | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[937] : [hdfs-sink] Persisting data at OrionHDFSSink. HDFS file (test/hdfs/orl.sou.dh.ssta10_ets/orl.sou.dh.ssta10_ets.txt), Data (2016-02-16T07:08:55.878Z,hdfs,ORL.SOU.DH.SSTA10,ETS,10.673299789428711,hdfs:///user/frb/test/hdfs/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade.txt)\r\ntime=2016-02-16T08:09:22.738CET | lvl=INFO | trans=1455606529-775-0000000000 | svc=test | subsvc=hdfs | function=persistMDAggregations | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[955] : [hdfs-sink] Persisting metadata at OrionHDFSSink. HDFS file (test/hdfs/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade.txt), Data (1455606535878,dofTimestamp,ms,2016-02-08T23:00:00.000Z\r\n1455606535878,tag,text,ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\r\n1455606535878,description,text,Electrical heat load\r\n1455606535878,quality,0:GOOD, +0:ERROR,10813440\r\n1455606535878,max,max,null\r\n1455606535878,min,min,null\r\n1455606535878,lcl,lcl,null\r\n1455606535878,ucl,ucl,null)\r\ntime=2016-02-16T08:09:23.270CET | lvl=INFO | trans=1455606529-775-0000000000 | svc=test | subsvc=hdfs | function=provisionHiveTable | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[988] : Creating Hive external table 'frb_test_hdfs_orl_sou_dh_ssta10_ets_column' in database 'default'\r\n..\r\n$ hadoop fs -cat test/hdfs/orl.sou.dh.ssta10_ets/orl.sou.dh.ssta10_ets.txt\r\n2016-02-16T07:08:55.878Z,hdfs,ORL.SOU.DH.SSTA10,ETS,10.673299789428711,hdfs:///user/frb/test/hdfs/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade.txt\r\n$ hadoop fs -cat test/hdfs/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade.txt\r\n1455606535878,dofTimestamp,ms,2016-02-08T23:00:00.000Z\r\n1455606535878,tag,text,ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad\r\n1455606535878,description,text,Electrical heat load\r\n1455606535878,quality,0:GOOD, +0:ERROR,10813440\r\n1455606535878,max,max,null\r\n1455606535878,min,min,null\r\n1455606535878,lcl,lcl,null\r\n1455606535878,ucl,ucl,null\r\n..\r\nhive> describe frb_test_hdfs_orl_sou_dh_ssta10_ets_column;\r\nOK\r\nrecvtime            \tstring              \t                    \r\nfiwareservicepath   \tstring              \t                    \r\nentityid            \tstring              \t                    \r\nentitytype          \tstring              \t                    \r\norl_sou_dh_ssta10_t_hvac_heatload\tstring              \t                    \r\norl_sou_dh_ssta10_t_hvac_heatload_md_file\tstring              \t                    \r\nTime taken: 0.223 seconds, Fetched: 6 row(s)\r\nhive> select * from frb_test_hdfs_orl_sou_dh_ssta10_ets_column;\r\nOK\r\n2016-02-16T07:08:55.878Z\thdfs\tORL.SOU.DH.SSTA10\tETS\t10.673299789428711\thdfs:///user/frb/test/hdfs/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade/orl.sou.dh.ssta10_ets_ORL.SOU.DH.SSTA10.T.HVAC.HeatLoad_centigrade.txt\r\nTime taken: 0.426 seconds, Fetched: 1 row(s)\r\n```\r\n* Assignee @pcoello25 ","created_at":"2016-02-15T15:27:26Z","updated_at":"2016-02-16T07:25:39Z","closed_at":"2016-02-16T07:25:39Z","merged_at":"2016-02-16T07:25:39Z","merge_commit_sha":"9e6dc18cec1399031b2ef7ba3c05be387a68795a","assignee":{"login":"pcoello25","id":15360342,"avatar_url":"https://avatars.githubusercontent.com/u/15360342?v=3","gravatar_id":"","url":"https://api.github.com/users/pcoello25","html_url":"https://github.com/pcoello25","followers_url":"https://api.github.com/users/pcoello25/followers","following_url":"https://api.github.com/users/pcoello25/following{/other_user}","gists_url":"https://api.github.com/users/pcoello25/gists{/gist_id}","starred_url":"https://api.github.com/users/pcoello25/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pcoello25/subscriptions","organizations_url":"https://api.github.com/users/pcoello25/orgs","repos_url":"https://api.github.com/users/pcoello25/repos","events_url":"https://api.github.com/users/pcoello25/events{/privacy}","received_events_url":"https://api.github.com/users/pcoello25/received_events","type":"User","site_admin":false},"milestone":null,"commits_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls/789/commits","review_comments_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls/789/comments","review_comment_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls/comments{/number}","comments_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues/789/comments","statuses_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/statuses/5c5681540023047cca6ed248ac8e02633c175bfe","head":{"label":"telefonicaid:bug/781_avoid_generalized_hive_encoding","ref":"bug/781_avoid_generalized_hive_encoding","sha":"5c5681540023047cca6ed248ac8e02633c175bfe","user":{"login":"telefonicaid","id":968363,"avatar_url":"https://avatars.githubusercontent.com/u/968363?v=3","gravatar_id":"","url":"https://api.github.com/users/telefonicaid","html_url":"https://github.com/telefonicaid","followers_url":"https://api.github.com/users/telefonicaid/followers","following_url":"https://api.github.com/users/telefonicaid/following{/other_user}","gists_url":"https://api.github.com/users/telefonicaid/gists{/gist_id}","starred_url":"https://api.github.com/users/telefonicaid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/telefonicaid/subscriptions","organizations_url":"https://api.github.com/users/telefonicaid/orgs","repos_url":"https://api.github.com/users/telefonicaid/repos","events_url":"https://api.github.com/users/telefonicaid/events{/privacy}","received_events_url":"https://api.github.com/users/telefonicaid/received_events","type":"Organization","site_admin":false},"repo":{"id":16607947,"name":"fiware-cygnus","full_name":"telefonicaid/fiware-cygnus","owner":{"login":"telefonicaid","id":968363,"avatar_url":"https://avatars.githubusercontent.com/u/968363?v=3","gravatar_id":"","url":"https://api.github.com/users/telefonicaid","html_url":"https://github.com/telefonicaid","followers_url":"https://api.github.com/users/telefonicaid/followers","following_url":"https://api.github.com/users/telefonicaid/following{/other_user}","gists_url":"https://api.github.com/users/telefonicaid/gists{/gist_id}","starred_url":"https://api.github.com/users/telefonicaid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/telefonicaid/subscriptions","organizations_url":"https://api.github.com/users/telefonicaid/orgs","repos_url":"https://api.github.com/users/telefonicaid/repos","events_url":"https://api.github.com/users/telefonicaid/events{/privacy}","received_events_url":"https://api.github.com/users/telefonicaid/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/telefonicaid/fiware-cygnus","description":"FI-WARE connectors","fork":false,"url":"https://api.github.com/repos/telefonicaid/fiware-cygnus","forks_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/forks","keys_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/keys{/key_id}","collaborators_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/teams","hooks_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/hooks","issue_events_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues/events{/number}","events_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/events","assignees_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/assignees{/user}","branches_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/branches{/branch}","tags_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/tags","blobs_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/refs{/sha}","trees_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/trees{/sha}","statuses_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/statuses/{sha}","languages_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/languages","stargazers_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/stargazers","contributors_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/contributors","subscribers_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/subscribers","subscription_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/subscription","commits_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/commits{/sha}","git_commits_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/commits{/sha}","comments_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/comments{/number}","issue_comment_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues/comments{/number}","contents_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/contents/{+path}","compare_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/compare/{base}...{head}","merges_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/merges","archive_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/downloads","issues_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues{/number}","pulls_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls{/number}","milestones_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/milestones{/number}","notifications_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/labels{/name}","releases_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/releases{/id}","deployments_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/deployments","created_at":"2014-02-07T07:57:41Z","updated_at":"2016-01-25T19:36:12Z","pushed_at":"2016-02-16T07:25:39Z","git_url":"git://github.com/telefonicaid/fiware-cygnus.git","ssh_url":"git@github.com:telefonicaid/fiware-cygnus.git","clone_url":"https://github.com/telefonicaid/fiware-cygnus.git","svn_url":"https://github.com/telefonicaid/fiware-cygnus","homepage":"","size":93412,"stargazers_count":20,"watchers_count":20,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":17,"mirror_url":null,"open_issues_count":72,"forks":17,"open_issues":72,"watchers":20,"default_branch":"master"}},"base":{"label":"telefonicaid:develop","ref":"develop","sha":"ecc1d245f6e44247c4679c2f87e894701ec2eee0","user":{"login":"telefonicaid","id":968363,"avatar_url":"https://avatars.githubusercontent.com/u/968363?v=3","gravatar_id":"","url":"https://api.github.com/users/telefonicaid","html_url":"https://github.com/telefonicaid","followers_url":"https://api.github.com/users/telefonicaid/followers","following_url":"https://api.github.com/users/telefonicaid/following{/other_user}","gists_url":"https://api.github.com/users/telefonicaid/gists{/gist_id}","starred_url":"https://api.github.com/users/telefonicaid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/telefonicaid/subscriptions","organizations_url":"https://api.github.com/users/telefonicaid/orgs","repos_url":"https://api.github.com/users/telefonicaid/repos","events_url":"https://api.github.com/users/telefonicaid/events{/privacy}","received_events_url":"https://api.github.com/users/telefonicaid/received_events","type":"Organization","site_admin":false},"repo":{"id":16607947,"name":"fiware-cygnus","full_name":"telefonicaid/fiware-cygnus","owner":{"login":"telefonicaid","id":968363,"avatar_url":"https://avatars.githubusercontent.com/u/968363?v=3","gravatar_id":"","url":"https://api.github.com/users/telefonicaid","html_url":"https://github.com/telefonicaid","followers_url":"https://api.github.com/users/telefonicaid/followers","following_url":"https://api.github.com/users/telefonicaid/following{/other_user}","gists_url":"https://api.github.com/users/telefonicaid/gists{/gist_id}","starred_url":"https://api.github.com/users/telefonicaid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/telefonicaid/subscriptions","organizations_url":"https://api.github.com/users/telefonicaid/orgs","repos_url":"https://api.github.com/users/telefonicaid/repos","events_url":"https://api.github.com/users/telefonicaid/events{/privacy}","received_events_url":"https://api.github.com/users/telefonicaid/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/telefonicaid/fiware-cygnus","description":"FI-WARE connectors","fork":false,"url":"https://api.github.com/repos/telefonicaid/fiware-cygnus","forks_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/forks","keys_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/keys{/key_id}","collaborators_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/teams","hooks_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/hooks","issue_events_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues/events{/number}","events_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/events","assignees_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/assignees{/user}","branches_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/branches{/branch}","tags_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/tags","blobs_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/refs{/sha}","trees_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/trees{/sha}","statuses_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/statuses/{sha}","languages_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/languages","stargazers_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/stargazers","contributors_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/contributors","subscribers_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/subscribers","subscription_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/subscription","commits_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/commits{/sha}","git_commits_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/git/commits{/sha}","comments_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/comments{/number}","issue_comment_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues/comments{/number}","contents_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/contents/{+path}","compare_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/compare/{base}...{head}","merges_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/merges","archive_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/downloads","issues_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues{/number}","pulls_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls{/number}","milestones_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/milestones{/number}","notifications_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/labels{/name}","releases_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/releases{/id}","deployments_url":"https://api.github.com/repos/telefonicaid/fiware-cygnus/deployments","created_at":"2014-02-07T07:57:41Z","updated_at":"2016-01-25T19:36:12Z","pushed_at":"2016-02-16T07:25:39Z","git_url":"git://github.com/telefonicaid/fiware-cygnus.git","ssh_url":"git@github.com:telefonicaid/fiware-cygnus.git","clone_url":"https://github.com/telefonicaid/fiware-cygnus.git","svn_url":"https://github.com/telefonicaid/fiware-cygnus","homepage":"","size":93412,"stargazers_count":20,"watchers_count":20,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":17,"mirror_url":null,"open_issues_count":72,"forks":17,"open_issues":72,"watchers":20,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls/789"},"html":{"href":"https://github.com/telefonicaid/fiware-cygnus/pull/789"},"issue":{"href":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues/789"},"comments":{"href":"https://api.github.com/repos/telefonicaid/fiware-cygnus/issues/789/comments"},"review_comments":{"href":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls/789/comments"},"review_comment":{"href":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/telefonicaid/fiware-cygnus/pulls/789/commits"},"statuses":{"href":"https://api.github.com/repos/telefonicaid/fiware-cygnus/statuses/5c5681540023047cca6ed248ac8e02633c175bfe"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"pcoello25","id":15360342,"avatar_url":"https://avatars.githubusercontent.com/u/15360342?v=3","gravatar_id":"","url":"https://api.github.com/users/pcoello25","html_url":"https://github.com/pcoello25","followers_url":"https://api.github.com/users/pcoello25/followers","following_url":"https://api.github.com/users/pcoello25/following{/other_user}","gists_url":"https://api.github.com/users/pcoello25/gists{/gist_id}","starred_url":"https://api.github.com/users/pcoello25/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pcoello25/subscriptions","organizations_url":"https://api.github.com/users/pcoello25/orgs","repos_url":"https://api.github.com/users/pcoello25/repos","events_url":"https://api.github.com/users/pcoello25/events{/privacy}","received_events_url":"https://api.github.com/users/pcoello25/received_events","type":"User","site_admin":false},"comments":1,"review_comments":0,"commits":4,"additions":31,"deletions":27,"changed_files":3}}