Athena

Query Log

• SELECT record FROM data_unified_impression WHERE log_date IN (20200228 ) AND json_extract(record, '$.data.impression_id') IS NULL

Reference

• json_extract_scalar(field, '$.foo["@bar"]') (always returns string)
• json_extract(field, '$.baz.biff') IS NULL works if .baz.biff is missing

function x(rw, r)
   local a = notes.readarticlefromfs(fss, f)

   local re = regexp.compile("json")
   local t = re:findallstringsubmatch("https?://www.imdb.com[^\s]+")
   local w = re:replaceallstringfunc(a:rawcontents(), function(s) return "xml" end)

   print(w)
end

function t(rw, r)
   local re = regexp.compile("json.*")
   local t = re:findallstringsubmatch("herp jsonfrew", -1)
   print(t[0][0])
end

function y(rw, r)
   -- docstr = http.get("http://now.frew.co/")
   -- doc = goquery.newdocumentfromstring(docstr)
   -- print(doc:find("h2#mothers-day"):text())
end