Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @dataVersion string = "mag-2019-03-22";
- DECLARE @blobAccount string = "<PLACEHOLDER>";
- DECLARE @uriPrefix string = "wasb://" + @dataVersion + "@" + @blobAccount + "/";
- DECLARE @typeCounts string = "/Output/TypeCounts.tsv";
- @Papers = Papers(@uriPrefix);
- @Types = SELECT
- DocType, COUNT(1) AS cnt
- FROM
- @Papers
- GROUP BY
- DocType;
- OUTPUT @Types TO @typeCounts
- USING Outputters.Tsv(quoting : false);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement