Thanks Ed! Appreciate your help. Ended up using the following which is almost similar to yours: SELECT REGEXP_EXTRACT((get_json_object(line,'$.result._raw')),'X_Requested_With=(\\w.+?)\\s',1)as X_INF_RequestID FROM tablename; ... View more

@Pardeep It's been a while of the post. I have been facing the same issue after I upgraded my hortonworks sandbox to HDP2.5. I tried the "mv VERSIONS VERSIONS.org" and restarted the hue but didn't work. I get the below when I restart My HUE shows up below when re-started Any help on this is greatly appreciated. Thanks! ... View more