{"action":"created","issue":{"url":"https://api.github.com/repos/cloudera/hue/issues/160","labels_url":"https://api.github.com/repos/cloudera/hue/issues/160/labels{/name}","comments_url":"https://api.github.com/repos/cloudera/hue/issues/160/comments","events_url":"https://api.github.com/repos/cloudera/hue/issues/160/events","html_url":"https://github.com/cloudera/hue/issues/160","id":60820824,"number":160,"title":"Visually differentiate between null values and \"NULL\" strings","user":{"login":"mkrcah","id":5685134,"avatar_url":"https://avatars.githubusercontent.com/u/5685134?v=3","gravatar_id":"","url":"https://api.github.com/users/mkrcah","html_url":"https://github.com/mkrcah","followers_url":"https://api.github.com/users/mkrcah/followers","following_url":"https://api.github.com/users/mkrcah/following{/other_user}","gists_url":"https://api.github.com/users/mkrcah/gists{/gist_id}","starred_url":"https://api.github.com/users/mkrcah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkrcah/subscriptions","organizations_url":"https://api.github.com/users/mkrcah/orgs","repos_url":"https://api.github.com/users/mkrcah/repos","events_url":"https://api.github.com/users/mkrcah/events{/privacy}","received_events_url":"https://api.github.com/users/mkrcah/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-03-12T13:47:01Z","updated_at":"2015-03-13T05:43:02Z","closed_at":"2015-03-13T05:43:02Z","body":"The table with results of Hive/Impala queries currently shows `null` values and `\"NULL\"` strings identically. For example, results for the query `select null as c1, 'NULL' as c2;` looks as follows:\r\n\r\n![image](https://cloud.githubusercontent.com/assets/5685134/6618791/b47d6b2a-c8c5-11e4-8866-3612caabf9e9.png)\r\n\r\nIt would be great to have `null` values displayed differently, e.g. with a different colour, so it's easier to debug sql queries, ETL scripts, etc."},"comment":{"url":"https://api.github.com/repos/cloudera/hue/issues/comments/78815993","html_url":"https://github.com/cloudera/hue/issues/160#issuecomment-78815993","issue_url":"https://api.github.com/repos/cloudera/hue/issues/160","id":78815993,"user":{"login":"romainr","id":17945,"avatar_url":"https://avatars.githubusercontent.com/u/17945?v=3","gravatar_id":"","url":"https://api.github.com/users/romainr","html_url":"https://github.com/romainr","followers_url":"https://api.github.com/users/romainr/followers","following_url":"https://api.github.com/users/romainr/following{/other_user}","gists_url":"https://api.github.com/users/romainr/gists{/gist_id}","starred_url":"https://api.github.com/users/romainr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/romainr/subscriptions","organizations_url":"https://api.github.com/users/romainr/orgs","repos_url":"https://api.github.com/users/romainr/repos","events_url":"https://api.github.com/users/romainr/events{/privacy}","received_events_url":"https://api.github.com/users/romainr/received_events","type":"User","site_admin":false},"created_at":"2015-03-13T05:43:02Z","updated_at":"2015-03-13T05:43:02Z","body":"Yes, see with them or maybe do something like \"if(boolean testCondition, T valueTrue, T valueFalseOrNull)\" to detect the real NULLs https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF"}}