Working workspaces are those which currently have valid qscript and we could render proper results
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Conditional Input.slam)),DirName(.tmp)),DirName(outfae59abe-799a-44e4-ae8d-86503c55b948)),FileName(cardfae59abe799a44e4ae8d86503c55b948)), args: Map(minage -> 40., maxage -> 55., state -> "CO", gender -> "both"), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Conditional%20Input.slam/.tmp/out77a0fabd-0848-4acc-9afe-bbffb4b4bf0e/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 646, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../outfae59abe-799a-44e4-ae8d-86503c55b948/`; CREATE FUNCTION ROUND2(:val, :n) BEGIN ROUND(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION CEIL2(:val, :n) BEGIN CEIL(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION FLOOR2(:val, :n) BEGIN FLOOR(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION card77a0fabd08484acc9afebbffb4b4bf0e(:minage, :gender, :maxage, :state) BEGIN tmp__0 := cardfae59abe799a44e4ae8d86503c55b948(:minage, :gender, :maxage, :state); SELECT AVG(weight) AS measure, city AS category, gender AS stack, null AS parallel FROM (tmp__0) AS tmp__1 GROUP BY gender, city ORDER BY gender ASC, city ASC END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Conditional%20Input.slam/.tmp/outb0a4c677-be0c-4ca7-8c3b-1b62704fdb65/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 346, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out77a0fabd-0848-4acc-9afe-bbffb4b4bf0e/`; CREATE FUNCTION cardb0a4c677be0c4ca78c3b1b62704fdb65(:gender, :chart, :filter, :minage, :maxage, :state) BEGIN tmp__0 := card77a0fabd08484acc9afebbffb4b4bf0e(:minage, :gender, :maxage, :state); CASE WHEN :chart = \"bar\" THEN SELECT * FROM (tmp__0) AS res WHERE :filter END END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Conditional Input.slam)),DirName(.tmp)),DirName(out77a0fabd-0848-4acc-9afe-bbffb4b4bf0e)),FileName(card77a0fabd08484acc9afebbffb4b4bf0e)), args: Map(state -> "CO", maxage -> 55., minage -> 40., gender -> "both"), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Data%20Types.slam/.tmp/outbe59bacf-de9b-410a-a92b-815d498b75ef/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 295, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION cardbe59bacfde9b410aa92b815d498b75ef(:types) BEGIN SELECT `_id` AS id, TYPE_OF(`_id`) AS id_Description, field1 AS F1, TYPE_OF(field1) AS F1_Description, field2 AS F2, TYPE_OF(field2) AS F2_Description, field3 AS F3, TYPE_OF(field3) AS F3_Description FROM :types END"}
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Data%20Types.slam/?q=IMPORT%20%60./.tmp/outbe59bacf-de9b-410a-a92b-815d498b75ef/%60%3B%20tmp__0%20%3A%3D%20cardbe59bacfde9b410aa92b815d498b75ef%28%3Atypes%29%3B%20SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%28tmp__0%29%20AS%20tmp__1&var.types=%60/hdfs/types.ldjson%60, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Data Types.slam)),DirName(.tmp)),DirName(outbe59bacf-de9b-410a-a92b-815d498b75ef)),FileName(cardbe59bacfde9b410aa92b815d498b75ef)), args: Map(types -> `/hdfs/types.ldjson`), offset: 0, limit: Some(10), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Flight%20Cost.slam/.tmp/oute81a0117-fd7e-4d43-9ba3-956a25e0fc8c, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 160, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"view":{"connectionUri":"sql2:?q=SELECT%20source%20AS%20Source%2C%20destination%20AS%20Destination%2C%20fuel%20AS%20Cost%20FROM%20%60/hdfs/flights.ldjson%60"}}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Flight%20Cost.slam/.tmp/out5408f04d-43ef-445b-b51c-e2cd37474a06sankey, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 625, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"view":{"connectionUri":"sql2:?q=CREATE%20FUNCTION%20ROUND2(:val%2C%20:n)%20BEGIN%20ROUND(:val%20*%2010.0%20%5E%20:n)%20/%2010.0%20%5E%20:n%20END%3B%20CREATE%20FUNCTION%20CEIL2(:val%2C%20:n)%20BEGIN%20CEIL(:val%20*%2010.0%20%5E%20:n)%20/%2010.0%20%5E%20:n%20END%3B%20CREATE%20FUNCTION%20FLOOR2(:val%2C%20:n)%20BEGIN%20FLOOR(:val%20*%2010.0%20%5E%20:n)%20/%2010.0%20%5E%20:n%20END%3B%20SELECT%20Source%20AS%20source%2C%20Destination%20AS%20target%2C%20SUM(Cost)%20AS%20weight%20FROM%20%60./oute81a0117-fd7e-4d43-9ba3-956a25e0fc8c%60%20GROUP%20BY%20Source%2C%20Destination%20ORDER%20BY%20Source%20ASC%2C%20Destination%20ASC"}}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Flight%20Cost.slam/.tmp/out3d65669e-df1e-44ca-bf96-96ce07a8b3a3, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 643, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"view":{"connectionUri":"sql2:?q=CREATE%20FUNCTION%20ROUND2(:val%2C%20:n)%20BEGIN%20ROUND(:val%20*%2010.0%20%5E%20:n)%20/%2010.0%20%5E%20:n%20END%3B%20CREATE%20FUNCTION%20CEIL2(:val%2C%20:n)%20BEGIN%20CEIL(:val%20*%2010.0%20%5E%20:n)%20/%2010.0%20%5E%20:n%20END%3B%20CREATE%20FUNCTION%20FLOOR2(:val%2C%20:n)%20BEGIN%20FLOOR(:val%20*%2010.0%20%5E%20:n)%20/%2010.0%20%5E%20:n%20END%3B%20SELECT%20DISTINCT%20row.Source%20AS%20Source%2C%20%5Brow.Destination...%5D%20AS%20Destination%2C%20%5Brow.Cost...%5D%20AS%20Cost%20FROM%20%60./oute81a0117-fd7e-4d43-9ba3-956a25e0fc8c%60%20AS%20row%20GROUP%20BY%20row.Source%20ORDER%20BY%20row.Source%20ASC"}}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Flight%20Cost.slam/.tmp/out30ffb2a3-1a17-4319-9af8-ddb237ebdac3/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 219, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card30ffb2a31a1743199af8ddb237ebdac3(:chart, :filter) BEGIN CASE WHEN :chart = \"sankey\" THEN SELECT * FROM `./../out5408f04d-43ef-445b-b51c-e2cd37474a06sankey` AS res WHERE :filter END END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20IOT%20Sensor%20Report.slam/.tmp/out1fe77130-a961-4a99-8ef4-efe3fd53a032/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 150, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card1fe77130a9614a998ef4efe3fd53a032(:sensors) BEGIN SELECT * FROM `/hdfs/timeseries.ldjson` WHERE sensor IN :sensors END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20IOT%20Sensor%20Report.slam/.tmp/out5f7e47d8-9ec4-4d45-82d0-12b561161736/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 573, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out1fe77130-a961-4a99-8ef4-efe3fd53a032/`; CREATE FUNCTION ROUND2(:val, :n) BEGIN ROUND(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION CEIL2(:val, :n) BEGIN CEIL(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION FLOOR2(:val, :n) BEGIN FLOOR(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION card5f7e47d89ec44d4582d012b561161736(:sensors) BEGIN tmp__0 := card1fe77130a9614a998ef4efe3fd53a032(:sensors); SELECT SUM(value) AS measure, dt AS dimension, sensor AS series FROM (tmp__0) AS tmp__1 GROUP BY sensor, dt ORDER BY sensor ASC, dt ASC END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Revenue%20Distribution.slam/.tmp/out232450fc-c9f2-4006-8ec9-295994d6443b, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 194, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"view":{"connectionUri":"sql2:?q=SELECT%20SUM(value)%20AS%20value%2C%20region%2C%20quarter%20FROM%20%60/hdfs/revenue.ldjson%60%20GROUP%20BY%20region%2C%20quarter%20ORDER%20BY%20quarter%20ASC"}}
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Revenue%20Distribution.slam/?q=SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%60./.tmp/out232450fc-c9f2-4006-8ec9-295994d6443b%60, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Revenue%20Distribution.slam/.tmp/out56274df6-a716-402b-b8e6-00a6001e1991boxplot, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 592, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"view":{"connectionUri":"sql2:?q=CREATE%20FUNCTION%20ROUND2(:val%2C%20:n)%20BEGIN%20ROUND(:val%20*%2010.0%20%5E%20:n)%20/%2010.0%20%5E%20:n%20END%3B%20CREATE%20FUNCTION%20CEIL2(:val%2C%20:n)%20BEGIN%20CEIL(:val%20*%2010.0%20%5E%20:n)%20/%2010.0%20%5E%20:n%20END%3B%20CREATE%20FUNCTION%20FLOOR2(:val%2C%20:n)%20BEGIN%20FLOOR(:val%20*%2010.0%20%5E%20:n)%20/%2010.0%20%5E%20:n%20END%3B%20SELECT%20DISTINCT%20value%20AS%20value%2C%20quarter%20AS%20dimension%2C%20region%20AS%20series%2C%20null%20AS%20parallel%20FROM%20%60/hdfs/revenue.ldjson%60%20ORDER%20BY%20region%20ASC%2C%20quarter%20ASC"}}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Revenue%20Distribution.slam/.tmp/out7fd6c5bf-8aee-4ac6-9bcf-4109449a1626/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 221, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card7fd6c5bf8aee4ac69bcf4109449a1626(:chart, :filter) BEGIN CASE WHEN :chart = \"boxplot\" THEN SELECT * FROM `./../out56274df6-a716-402b-b8e6-00a6001e1991boxplot` AS res WHERE :filter END END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Olympics%20Filter%20and%20Download.slam/.tmp/out04e4c8f9-2418-4020-ac19-f1255562eb23/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 110, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card04e4c8f924184020ac19f1255562eb23(:olympics) BEGIN SELECT * FROM :olympics END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Olympics Filter and Download.slam)),DirName(.tmp)),DirName(out04e4c8f9-2418-4020-ac19-f1255562eb23)),FileName(card04e4c8f924184020ac19f1255562eb23)), args: Map(olympics -> `/hdfs/olympics.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Olympics%20Filter%20and%20Download.slam/.tmp/oute35a2df4-7228-48cd-b0f7-64aeceb7d717/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 275, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out04e4c8f9-2418-4020-ac19-f1255562eb23/`; CREATE FUNCTION carde35a2df4722848cdb0f764aeceb7d717(:olympics, :selection) BEGIN tmp__0 := card04e4c8f924184020ac19f1255562eb23(:olympics); SELECT * FROM (tmp__0) AS res WHERE res.country IN :selection END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Olympics Filter and Download.slam)),DirName(.tmp)),DirName(oute35a2df4-7228-48cd-b0f7-64aeceb7d717)),FileName(carde35a2df4722848cdb0f764aeceb7d717)), args: Map(selection -> ("AUT"), olympics -> `/hdfs/olympics.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Olympics%20Filter%20and%20Download.slam/.tmp/out9b3aefb5-9e7d-4dae-a06b-1152dc93819d/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 302, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../oute35a2df4-7228-48cd-b0f7-64aeceb7d717/`; CREATE FUNCTION card9b3aefb59e7d4daea06b1152dc93819d(:olympics, :selection, :selection__1) BEGIN tmp__0 := carde35a2df4722848cdb0f764aeceb7d717(:olympics, :selection__1); SELECT * FROM (tmp__0) AS res WHERE res.type IN :selection END"}
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Olympics%20Filter%20and%20Download.slam/?q=IMPORT%20%60./.tmp/out9b3aefb5-9e7d-4dae-a06b-1152dc93819d/%60%3B%20tmp__0%20%3A%3D%20card9b3aefb59e7d4daea06b1152dc93819d%28%3Aolympics%2C%20%3Aselection%2C%20%3Aselection__1%29%3B%20SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%28tmp__0%29%20AS%20tmp__1&var.olympics=%60/hdfs/olympics.ldjson%60&var.selection=%28%22Gold%22%29&var.selection__1=%28%22AUT%22%29, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Olympics Filter and Download.slam)),DirName(.tmp)),DirName(out9b3aefb5-9e7d-4dae-a06b-1152dc93819d)),FileName(card9b3aefb59e7d4daea06b1152dc93819d)), args: Map(olympics -> `/hdfs/olympics.ldjson`, selection__1 -> ("AUT"), selection -> ("Gold")), offset: 0, limit: Some(10), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Olympics%20Search%20and%20Download.slam/.tmp/out323d3aa6-4228-4f23-a8db-bc0e3c2434f2/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 110, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card323d3aa642284f23a8dbbc0e3c2434f2(:olympics) BEGIN SELECT * FROM :olympics END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Olympics Search and Download.slam)),DirName(.tmp)),DirName(out323d3aa6-4228-4f23-a8db-bc0e3c2434f2)),FileName(card323d3aa642284f23a8dbbc0e3c2434f2)), args: Map(olympics -> `/hdfs/olympics.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Olympics%20Search%20and%20Download.slam/.tmp/out65d6987e-6819-4d7b-8492-484ce0dcc2b5/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 362, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out323d3aa6-4228-4f23-a8db-bc0e3c2434f2/`; CREATE FUNCTION card65d6987e68194d7b8492484ce0dcc2b5(:olympics, :`distinct`, :filter) BEGIN tmp__0 := card323d3aa642284f23a8dbbc0e3c2434f2(:olympics); CASE WHEN :`distinct` THEN SELECT DISTINCT * FROM (tmp__0) AS tmp__1 WHERE :filter ELSE SELECT * FROM (tmp__0) AS tmp__2 WHERE :filter END END"}
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Olympics%20Search%20and%20Download.slam/?q=IMPORT%20%60./.tmp/out65d6987e-6819-4d7b-8492-484ce0dcc2b5/%60%3B%20tmp__0%20%3A%3D%20card65d6987e68194d7b8492484ce0dcc2b5%28%3Aolympics%2C%20%3A%60distinct%60%2C%20%3Afilter%29%3B%20SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%28tmp__0%29%20AS%20tmp__1&var.olympics=%60/hdfs/olympics.ldjson%60&var.distinct=false&var.filter=%28%28%28SEARCH%28city%2C%20%22%5E.%2ANOR.%2A%24%22%2C%20true%29%29%20OR%20%28%28SEARCH%28country%2C%20%22%5E.%2ANOR.%2A%24%22%2C%20true%29%29%29%20OR%20%28%28SEARCH%28discipline%2C%20%22%5E.%2ANOR.%2A%24%22%2C%20true%29%29%29%20OR%20%28%28SEARCH%28event%2C%20%22%5E.%2ANOR.%2A%24%22%2C%20true%29%29%29%20OR%20%28%28SEARCH%28gender%2C%20%22%5E.%2ANOR.%2A%24%22%2C%20true%29%29%29%20OR%20%28%28SEARCH%28sport%2C%20%22%5E.%2ANOR.%2A%24%22%2C%20true%29%29%29%20OR%20%28%28SEARCH%28type%2C%20%22%5E.%2ANOR.%2A%24%22%2C%20true%29%29%29%20OR%20%28%28SEARCH%28year%2C%20%22%5E.%2ANOR.%2A%24%22%2C%20true%29%29%29%29%29, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Olympics Search and Download.slam)),DirName(.tmp)),DirName(out65d6987e-6819-4d7b-8492-484ce0dcc2b5)),FileName(card65d6987e68194d7b8492484ce0dcc2b5)), args: Map(olympics -> `/hdfs/olympics.ldjson`, filter -> (((SEARCH(city, "^.*NOR.*$", true)) OR ((SEARCH(country, "^.*NOR.*$", true))) OR ((SEARCH(discipline, "^.*NOR.*$", true))) OR ((SEARCH(event, "^.*NOR.*$", true))) OR ((SEARCH(gender, "^.*NOR.*$", true))) OR ((SEARCH(sport, "^.*NOR.*$", true))) OR ((SEARCH(type, "^.*NOR.*$", true))) OR ((SEARCH(year, "^.*NOR.*$", true))))), distinct -> false), offset: 0, limit: Some(10), format: JsonContentType(Readable,SingleArray,None)
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/?q=SELECT%20state_list%5B%2A%5D%20FROM%20%3Astates%20ORDER%20BY%20state_list%5B%2A%5D%20ASC&var.patients=%60/hdfs/patients3.ldjson%60&var.states=%60/hdfs/states.ldjson%60, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=precise, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/?q=SELECT%20state_list%5B%2A%5D%20FROM%20%3Astates%20ORDER%20BY%20state_list%5B%2A%5D%20ASC&var.patients=%60/hdfs/patients3.ldjson%60&var.states=%60/hdfs/states.ldjson%60, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=precise, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/.tmp/out80986bd0-f918-45f3-8abf-bb1ebbd3c9fc/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 250, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card80986bd0f91845f38abfbb1ebbd3c9fc(:state1, :patients, :states) BEGIN SELECT COUNT(*) AS cnt, loc[1] AS lat, loc[0] AS lng FROM :patients WHERE state = :state1 GROUP BY loc[1], loc[0] ORDER BY loc[1] ASC, loc[0] ASC END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/.tmp/out330e1e61-20d5-4614-9316-8780cb446d82/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 216, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card330e1e6120d5461493168780cb446d82(:state1, :patients, :states) BEGIN SELECT COUNT(*) AS Cnt, city FROM :patients WHERE state = :state1 GROUP BY city ORDER BY COUNT(*) DESC LIMIT 10 END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/.tmp/outd386f1d1-89a5-4b03-add2-cce867fccd0b/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 216, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION cardd386f1d189a54b03add2cce867fccd0b(:state2, :patients, :states) BEGIN SELECT COUNT(*) AS Cnt, city FROM :patients WHERE state = :state2 GROUP BY city ORDER BY COUNT(*) DESC LIMIT 10 END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/.tmp/out6cb90341-de5c-4018-ac6b-155195f19555/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 250, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card6cb90341de5c4018ac6b155195f19555(:state2, :patients, :states) BEGIN SELECT COUNT(*) AS cnt, loc[1] AS lat, loc[0] AS lng FROM :patients WHERE state = :state2 GROUP BY loc[1], loc[0] ORDER BY loc[1] ASC, loc[0] ASC END"}
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/?q=IMPORT%20%60./.tmp/out80986bd0-f918-45f3-8abf-bb1ebbd3c9fc/%60%3B%20tmp__0%20%3A%3D%20card80986bd0f91845f38abfbb1ebbd3c9fc%28%3Astate1%2C%20%3Apatients%2C%20%3Astates%29%3B%20SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%28tmp__0%29%20AS%20tmp__1&var.state1=%22FL%22&var.patients=%60/hdfs/patients3.ldjson%60&var.states=%60/hdfs/states.ldjson%60, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/?q=IMPORT%20%60./.tmp/out330e1e61-20d5-4614-9316-8780cb446d82/%60%3B%20tmp__0%20%3A%3D%20card330e1e6120d5461493168780cb446d82%28%3Astate1%2C%20%3Apatients%2C%20%3Astates%29%3B%20SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%28tmp__0%29%20AS%20tmp__1&var.state1=%22FL%22&var.patients=%60/hdfs/patients3.ldjson%60&var.states=%60/hdfs/states.ldjson%60, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/?q=IMPORT%20%60./.tmp/outd386f1d1-89a5-4b03-add2-cce867fccd0b/%60%3B%20tmp__0%20%3A%3D%20cardd386f1d189a54b03add2cce867fccd0b%28%3Astate2%2C%20%3Apatients%2C%20%3Astates%29%3B%20SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%28tmp__0%29%20AS%20tmp__1&var.state2=%22WY%22&var.patients=%60/hdfs/patients3.ldjson%60&var.states=%60/hdfs/states.ldjson%60, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/?q=IMPORT%20%60./.tmp/out6cb90341-de5c-4018-ac6b-155195f19555/%60%3B%20tmp__0%20%3A%3D%20card6cb90341de5c4018ac6b155195f19555%28%3Astate2%2C%20%3Apatients%2C%20%3Astates%29%3B%20SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%28tmp__0%29%20AS%20tmp__1&var.state2=%22WY%22&var.patients=%60/hdfs/patients3.ldjson%60&var.states=%60/hdfs/states.ldjson%60, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(outd386f1d1-89a5-4b03-add2-cce867fccd0b)),FileName(cardd386f1d189a54b03add2cce867fccd0b)), args: Map(state2 -> "WY", patients -> `/hdfs/patients3.ldjson`, states -> `/hdfs/states.ldjson`), offset: 0, limit: Some(10), format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(out330e1e61-20d5-4614-9316-8780cb446d82)),FileName(card330e1e6120d5461493168780cb446d82)), args: Map(state1 -> "FL", patients -> `/hdfs/patients3.ldjson`, states -> `/hdfs/states.ldjson`), offset: 0, limit: Some(10), format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(out80986bd0-f918-45f3-8abf-bb1ebbd3c9fc)),FileName(card80986bd0f91845f38abfbb1ebbd3c9fc)), args: Map(state1 -> "FL", patients -> `/hdfs/patients3.ldjson`, states -> `/hdfs/states.ldjson`), offset: 0, limit: Some(10), format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(out6cb90341-de5c-4018-ac6b-155195f19555)),FileName(card6cb90341de5c4018ac6b155195f19555)), args: Map(state2 -> "WY", patients -> `/hdfs/patients3.ldjson`, states -> `/hdfs/states.ldjson`), offset: 0, limit: Some(10), format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(out80986bd0-f918-45f3-8abf-bb1ebbd3c9fc)),FileName(card80986bd0f91845f38abfbb1ebbd3c9fc)), args: Map(state1 -> "FL", patients -> `/hdfs/patients3.ldjson`, states -> `/hdfs/states.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(out6cb90341-de5c-4018-ac6b-155195f19555)),FileName(card6cb90341de5c4018ac6b155195f19555)), args: Map(state2 -> "WY", patients -> `/hdfs/patients3.ldjson`, states -> `/hdfs/states.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/.tmp/out20e910e3-2500-48db-a82b-39c1007b89d5/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 596, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out80986bd0-f918-45f3-8abf-bb1ebbd3c9fc/`; CREATE FUNCTION ROUND2(:val, :n) BEGIN ROUND(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION CEIL2(:val, :n) BEGIN CEIL(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION FLOOR2(:val, :n) BEGIN FLOOR(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION card20e910e3250048dba82b39c1007b89d5(:state1, :patients, :states) BEGIN tmp__0 := card80986bd0f91845f38abfbb1ebbd3c9fc(:state1, :patients, :states); SELECT lat AS lat, lng AS lng, SUM(cnt) AS intensity FROM (tmp__0) AS tmp__1 GROUP BY lat, lng ORDER BY lat ASC, lng ASC END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Heatmap%20State%20Comparison.slam/.tmp/out13c43325-ec73-4945-b5ee-6b0df4bc35c3/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 596, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out6cb90341-de5c-4018-ac6b-155195f19555/`; CREATE FUNCTION ROUND2(:val, :n) BEGIN ROUND(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION CEIL2(:val, :n) BEGIN CEIL(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION FLOOR2(:val, :n) BEGIN FLOOR(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION card13c43325ec734945b5ee6b0df4bc35c3(:state2, :patients, :states) BEGIN tmp__0 := card6cb90341de5c4018ac6b155195f19555(:state2, :patients, :states); SELECT lat AS lat, lng AS lng, SUM(cnt) AS intensity FROM (tmp__0) AS tmp__1 GROUP BY lat, lng ORDER BY lat ASC, lng ASC END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(out20e910e3-2500-48db-a82b-39c1007b89d5)),FileName(card20e910e3250048dba82b39c1007b89d5)), args: Map(states -> `/hdfs/states.ldjson`, state1 -> "FL", patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(out13c43325-ec73-4945-b5ee-6b0df4bc35c3)),FileName(card13c43325ec734945b5ee6b0df4bc35c3)), args: Map(state2 -> "WY", states -> `/hdfs/states.ldjson`, patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(out20e910e3-2500-48db-a82b-39c1007b89d5)),FileName(card20e910e3250048dba82b39c1007b89d5)), args: Map(states -> `/hdfs/states.ldjson`, state1 -> "FL", patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Heatmap State Comparison.slam)),DirName(.tmp)),DirName(out13c43325-ec73-4945-b5ee-6b0df4bc35c3)),FileName(card13c43325ec734945b5ee6b0df4bc35c3)), args: Map(state2 -> "WY", states -> `/hdfs/states.ldjson`, patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Markers%20-%20Texas.slam/.tmp/out19e98100-e65a-4a91-80f4-cc0f3987fe4b/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 231, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card19e98100e65a4a9180f4cc0f3987fe4b(:patients) BEGIN SELECT COUNT(*) AS cnt, loc[1] AS lat, loc[0] AS lng FROM :patients WHERE state = \"TX\" GROUP BY loc[1], loc[0] ORDER BY loc[1] ASC, loc[0] ASC END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Markers - Texas.slam)),DirName(.tmp)),DirName(out19e98100-e65a-4a91-80f4-cc0f3987fe4b)),FileName(card19e98100e65a4a9180f4cc0f3987fe4b)), args: Map(patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%93%20-%20Geo%20Markers%20-%20Texas.slam/.tmp/out776146cd-a75e-402d-b981-4bcdd48a7253/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 567, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out19e98100-e65a-4a91-80f4-cc0f3987fe4b/`; CREATE FUNCTION ROUND2(:val, :n) BEGIN ROUND(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION CEIL2(:val, :n) BEGIN CEIL(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION FLOOR2(:val, :n) BEGIN FLOOR(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION card776146cda75e402db9814bcdd48a7253(:patients) BEGIN tmp__0 := card19e98100e65a4a9180f4cc0f3987fe4b(:patients); SELECT lat AS lat, lng AS lng, null AS series, null AS size FROM (tmp__0) AS tmp__1 GROUP BY lat, lng ORDER BY lat ASC, lng ASC END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Markers - Texas.slam)),DirName(.tmp)),DirName(out776146cd-a75e-402d-b981-4bcdd48a7253)),FileName(card776146cda75e402db9814bcdd48a7253)), args: Map(patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✓ - Geo Markers - Texas.slam)),DirName(.tmp)),DirName(out776146cd-a75e-402d-b981-4bcdd48a7253)),FileName(card776146cda75e402db9814bcdd48a7253)), args: Map(patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%93%20-%20Markdown%20Examples.slam/?q=SELECT%20DISTINCT%20%28city%29%20FROM%20%60/hdfs/patients3.ldjson%60%20WHERE%20state%20%3D%20%22TX%22%20ORDER%20BY%20city%20ASC, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=precise, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
Those are workspaces that are (in majorty) blocked mostly by current QScript issues. Some of them generate partial calls, so I include them here. Note however that those might not be complete (but in most cases they will be)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Customer%20Orders%20by%20State%20(form%20element).slam/.tmp/outc33d0862-b9b7-4985-981e-6e89de1cf5c0/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 155, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION cardc33d0862b9b74985981e6e89de1cf5c0(:ordered_items, :customers, :inventory_items, :orders) BEGIN SELECT * FROM :customers END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✗ - Customer Orders by State (form element).slam)),DirName(.tmp)),DirName(outc33d0862-b9b7-4985-981e-6e89de1cf5c0)),FileName(cardc33d0862b9b74985981e6e89de1cf5c0)), args: Map(inventory_items -> `/hdfs/inventory_items.ldjson`, orders -> `/hdfs/orders.ldjson`, ordered_items -> `/hdfs/ordered_items.ldjson`, customers -> `/hdfs/customers.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Customer%20Orders%20by%20State%20(form%20element).slam/.tmp/out74dd3b74-7b70-4081-bf0e-b57dc41f108d/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 361, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../outc33d0862-b9b7-4985-981e-6e89de1cf5c0/`; CREATE FUNCTION card74dd3b747b704081bf0eb57dc41f108d(:ordered_items, :customers, :inventory_items, :orders, :selection) BEGIN tmp__0 := cardc33d0862b9b74985981e6e89de1cf5c0(:ordered_items, :customers, :inventory_items, :orders); SELECT * FROM (tmp__0) AS res WHERE res.state IN :selection END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Customer%20Orders%20by%20State%20(form%20element).slam/.tmp/out4ab45ad9-0bff-4e27-8dfa-3604ef435fc7/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 898, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out74dd3b74-7b70-4081-bf0e-b57dc41f108d/`; CREATE FUNCTION card4ab45ad90bff4e278dfa3604ef435fc7(:ordered_items, :customers, :inventory_items, :orders, :selection) BEGIN tmp__0 := card74dd3b747b704081bf0eb57dc41f108d(:ordered_items, :customers, :inventory_items, :orders, :selection); SELECT o.order_key AS OrderKey, o.purchase_date AS PurchaseDate, c.last_name || \", \" || c.first_name AS Name, c.city AS City, c.state AS State, i.clothing_size AS Size, i.clothing_type AS Type, i.clothing_color AS Color, i.price AS UnitPrice, oi.qty AS Quantity, i.price * oi.qty AS PricePaid, SUM(i.price * oi.qty) AS TotalPaid, i.clothing_brand AS Brand FROM (tmp__0) AS c INNER JOIN :orders AS o ON c.customer_key = o.customer_key INNER JOIN :ordered_items AS oi ON oi.order_key = o.order_key INNER JOIN :inventory_items AS i ON i.item_key = oi.item_key GROUP BY i.price * oi.qty END"}
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%97%20-%20Customer%20Orders%20by%20State%20(form%20element).slam/?q=IMPORT%20%60./.tmp/out4ab45ad9-0bff-4e27-8dfa-3604ef435fc7/%60%3B%20tmp__0%20%3A%3D%20card4ab45ad90bff4e278dfa3604ef435fc7%28%3Aordered_items%2C%20%3Acustomers%2C%20%3Ainventory_items%2C%20%3Aorders%2C%20%3Aselection%29%3B%20SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%28tmp__0%29%20AS%20tmp__1&var.ordered_items=%60/hdfs/ordered_items.ldjson%60&var.customers=%60/hdfs/customers.ldjson%60&var.inventory_items=%60/hdfs/inventory_items.ldjson%60&var.orders=%60/hdfs/orders.ldjson%60&var.selection=%28%22AK%22%29, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Game%20Comparison.slam/.tmp/out3fbecc90-932c-4f3d-aaa1-2366669d2854/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 331, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card3fbecc90932c4f3daaa12366669d2854(:genre, :name, :games, :maxlimit, :minreviews, :score) BEGIN SELECT A_Name AS Game, B_Released AS ReleaseDate, C_Recommendations AS Reviews, D_Metacritic AS Score, PriceInitial AS Price FROM `/hdfs/steamgames.ldjson` ORDER BY A_Name ASC LIMIT INTEGER(:maxlimit) END"}
/execute (GET): req: Request(method=GET, uri=/hdfs/workspaces/%E2%9C%97%20-%20Game%20Comparison.slam/?q=IMPORT%20%60./.tmp/out3fbecc90-932c-4f3d-aaa1-2366669d2854/%60%3B%20tmp__0%20%3A%3D%20card3fbecc90932c4f3daaa12366669d2854%28%3Agenre%2C%20%3Aname%2C%20%3Agames%2C%20%3Amaxlimit%2C%20%3Aminreviews%2C%20%3Ascore%29%3B%20SELECT%20COUNT%28%2A%29%20AS%20count%20FROM%20%28tmp__0%29%20AS%20tmp__1&var.name=%22%22&var.genre=%22All%22&var.games=%60/hdfs/steamgames.ldjson%60&var.maxlimit=%2220%22&var.minreviews=0&var.score=0, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Accept: application/json;mode=readable, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>)), offset: None, limit: None
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✗ - Game Comparison.slam)),DirName(.tmp)),DirName(out3fbecc90-932c-4f3d-aaa1-2366669d2854)),FileName(card3fbecc90932c4f3daaa12366669d2854)), args: Map(name -> "", genre -> "All", maxlimit -> "20", score -> 0, minreviews -> 0, games -> `/hdfs/steamgames.ldjson`), offset: 10, limit: Some(10), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/oute69ccb8f-7064-43c4-9ba4-e407cf1d8e6e/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 247, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION carde69ccb8f706443c49ba4e407cf1d8e6e(:patients, :timeseries) BEGIN SELECT COUNT(*) AS cnt, state, gender FROM :patients WHERE LIKE(codes[*].`desc`, \"%flu%\", \"\\\\\") GROUP BY state, gender ORDER BY COUNT(*) DESC END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/out7f8b3a9e-051f-4894-b6cc-857b67dc4ba8/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 542, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card7f8b3a9e051f4894b6cc857b67dc4ba8(:patients, :timeseries) BEGIN SELECT COUNT(*) AS Visits, TO_STRING(DATE_PART(\"year\", TIMESTAMP(last_visit))) || \"-Q\" || TO_STRING((DATE_PART(\"quarter\", TIMESTAMP(last_visit))) - (DATE_PART(\"quarter\", TIMESTAMP(last_visit)) % 1)) AS QUARTER FROM :patients GROUP BY TO_STRING(DATE_PART(\"year\", TIMESTAMP(last_visit))) || \"-Q\" || TO_STRING((DATE_PART(\"quarter\", TIMESTAMP(last_visit))) - (DATE_PART(\"quarter\", TIMESTAMP(last_visit)) % 1)) ORDER BY QUARTER ASC END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/out41ce866c-e378-4864-8a65-f1c88a3ffdcf/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 210, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card41ce866ce37848648a65f1c88a3ffdcf(:patients, :timeseries) BEGIN SELECT COUNT(*) AS cnt, city FROM :patients WHERE state = \"NY\" GROUP BY city ORDER BY COUNT(*) DESC LIMIT 10 END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/out199b2e30-5995-45c8-8b48-cee3fd2a2b79/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 141, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"CREATE FUNCTION card199b2e30599545c88b48cee3fd2a2b79(:patients, :timeseries) BEGIN SELECT dt, sensor, value FROM :timeseries END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✗ - Dashboard Example.slam)),DirName(.tmp)),DirName(oute69ccb8f-7064-43c4-9ba4-e407cf1d8e6e)),FileName(carde69ccb8f706443c49ba4e407cf1d8e6e)), args: Map(timeseries -> `/hdfs/timeseries.ldjson`, patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✗ - Dashboard Example.slam)),DirName(.tmp)),DirName(out7f8b3a9e-051f-4894-b6cc-857b67dc4ba8)),FileName(card7f8b3a9e051f4894b6cc857b67dc4ba8)), args: Map(timeseries -> `/hdfs/timeseries.ldjson`, patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✗ - Dashboard Example.slam)),DirName(.tmp)),DirName(out41ce866c-e378-4864-8a65-f1c88a3ffdcf)),FileName(card41ce866ce37848648a65f1c88a3ffdcf)), args: Map(timeseries -> `/hdfs/timeseries.ldjson`, patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✗ - Dashboard Example.slam)),DirName(.tmp)),DirName(out199b2e30-5995-45c8-8b48-cee3fd2a2b79)),FileName(card199b2e30599545c88b48cee3fd2a2b79)), args: Map(timeseries -> `/hdfs/timeseries.ldjson`, patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: Some(300), format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/out1b5f9e6b-519b-409d-8df3-2ff325dedcad/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 601, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out199b2e30-5995-45c8-8b48-cee3fd2a2b79/`; CREATE FUNCTION ROUND2(:val, :n) BEGIN ROUND(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION CEIL2(:val, :n) BEGIN CEIL(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION FLOOR2(:val, :n) BEGIN FLOOR(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION card1b5f9e6b519b409d8df32ff325dedcad(:patients, :timeseries) BEGIN tmp__0 := card199b2e30599545c88b48cee3fd2a2b79(:patients, :timeseries); SELECT SUM(value) AS measure, dt AS dimension, sensor AS series FROM (tmp__0) AS tmp__1 GROUP BY sensor, dt ORDER BY sensor ASC, dt ASC END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/out7f1f04aa-6ef4-4e61-a4a8-759eeb886579/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 325, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out1b5f9e6b-519b-409d-8df3-2ff325dedcad/`; CREATE FUNCTION card7f1f04aa6ef44e61a4a8759eeb886579(:chart, :filter, :patients, :timeseries) BEGIN tmp__0 := card1b5f9e6b519b409d8df32ff325dedcad(:patients, :timeseries); CASE WHEN :chart = \"area\" THEN SELECT * FROM (tmp__0) AS res WHERE :filter END END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/out90913f70-5862-4d48-b3f1-753e8487055f/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 599, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out41ce866c-e378-4864-8a65-f1c88a3ffdcf/`; CREATE FUNCTION ROUND2(:val, :n) BEGIN ROUND(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION CEIL2(:val, :n) BEGIN CEIL(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION FLOOR2(:val, :n) BEGIN FLOOR(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION card90913f7058624d48b3f1753e8487055f(:patients, :timeseries) BEGIN tmp__0 := card41ce866ce37848648a65f1c88a3ffdcf(:patients, :timeseries); SELECT city AS category, SUM(cnt) AS measure, null AS donut, null AS parallel FROM (tmp__0) AS tmp__1 GROUP BY city ORDER BY city ASC END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✗ - Dashboard Example.slam)),DirName(.tmp)),DirName(out1b5f9e6b-519b-409d-8df3-2ff325dedcad)),FileName(card1b5f9e6b519b409d8df32ff325dedcad)), args: Map(timeseries -> `/hdfs/timeseries.ldjson`, patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)
[Stage 62:==============================================> (4 + 1) / 5]/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/out6af94e57-522c-41c8-a5c1-e5794534cad2/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 324, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out90913f70-5862-4d48-b3f1-753e8487055f/`; CREATE FUNCTION card6af94e57522c41c8a5c1e5794534cad2(:patients, :chart, :filter, :timeseries) BEGIN tmp__0 := card90913f7058624d48b3f1753e8487055f(:patients, :timeseries); CASE WHEN :chart = \"pie\" THEN SELECT * FROM (tmp__0) AS res WHERE :filter END END"}
[Stage 64:> (0 + 4) / 5]/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✗ - Dashboard Example.slam)),DirName(.tmp)),DirName(out90913f70-5862-4d48-b3f1-753e8487055f)),FileName(card90913f7058624d48b3f1753e8487055f)), args: Map(timeseries -> `/hdfs/timeseries.ldjson`, patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/outa985be40-4bfe-4078-b43e-9e1109cc0e97/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 624, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../oute69ccb8f-7064-43c4-9ba4-e407cf1d8e6e/`; CREATE FUNCTION ROUND2(:val, :n) BEGIN ROUND(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION CEIL2(:val, :n) BEGIN CEIL(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION FLOOR2(:val, :n) BEGIN FLOOR(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION carda985be404bfe4078b43e9e1109cc0e97(:patients, :timeseries) BEGIN tmp__0 := carde69ccb8f706443c49ba4e407cf1d8e6e(:patients, :timeseries); SELECT SUM(cnt) AS measure, state AS category, gender AS stack, null AS parallel FROM (tmp__0) AS tmp__1 GROUP BY gender, state ORDER BY gender ASC, state ASC END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/outff57c293-e2d6-4274-9525-fd3323946fca/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 628, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../out7f8b3a9e-051f-4894-b6cc-857b67dc4ba8/`; CREATE FUNCTION ROUND2(:val, :n) BEGIN ROUND(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION CEIL2(:val, :n) BEGIN CEIL(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION FLOOR2(:val, :n) BEGIN FLOOR(:val * 10.0 ^ :n) / 10.0 ^ :n END; CREATE FUNCTION cardff57c293e2d642749525fd3323946fca(:patients, :timeseries) BEGIN tmp__0 := card7f8b3a9e051f4894b6cc857b67dc4ba8(:patients, :timeseries); SELECT QUARTER AS dimension, SUM(Visits) AS measure1, null AS size, null AS measure2, null AS series FROM (tmp__0) AS tmp__1 GROUP BY QUARTER ORDER BY QUARTER ASC END"}
/mount (PUT) req: Request(method=PUT, uri=/hdfs/workspaces/%E2%9C%97%20-%20Dashboard%20Example.slam/.tmp/out99533051-7315-4219-9d50-37a95152a7ed/, headers=Headers(Host: serv1.demo.slamdata.com, Connection: keep-alive, Content-Length: 325, Origin: http://serv1.demo.slamdata.com, User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36, Content-Type: text/plain;charset=UTF-8, Accept: */*, Referer: http://serv1.demo.slamdata.com/files/workspace.html, Accept-Encoding: gzip, deflate, Accept-Language: en-US,en;q=0.8,pl;q=0.6, Cookie: <REDACTED>))
body: {"module":"IMPORT `./../outff57c293-e2d6-4274-9525-fd3323946fca/`; CREATE FUNCTION card99533051731542199d5037a95152a7ed(:chart, :filter, :patients, :timeseries) BEGIN tmp__0 := cardff57c293e2d642749525fd3323946fca(:patients, :timeseries); CASE WHEN :chart = \"line\" THEN SELECT * FROM (tmp__0) AS res WHERE :filter END END"}
/invoke (GET): format FileIn(DirIn(DirIn(DirIn(DirIn(DirIn(Root,DirName(hdfs)),DirName(workspaces)),DirName(✗ - Dashboard Example.slam)),DirName(.tmp)),DirName(outff57c293-e2d6-4274-9525-fd3323946fca)),FileName(cardff57c293e2d642749525fd3323946fca)), args: Map(timeseries -> `/hdfs/timeseries.ldjson`, patients -> `/hdfs/patients3.ldjson`), offset: 0, limit: None, format: JsonContentType(Readable,SingleArray,None)