Hi,
I am following the steps here to compute author h index from the Microsoft Academic Graph: tutorial-usql-hindex. I already have a version of the data in my Azure Storage Account and I set up a Data Lake Analytics Account. I also added my Azure Storage Account as a source for my Data Lake Analytics Account.
Now, when I try running a job with the script provided, I get the following errors:
E_CSC_USER_DDLENTITYDOESNOTEXIST: Table Valued Function 'master.dbo.Affiliations' does not exist. Line 6
E_CSC_USER_DDLENTITYDOESNOTEXIST: Table Valued Function 'master.dbo.Authors' does not exist.Line 7
E_CSC_USER_DDLENTITYDOESNOTEXIST: Table Valued Function 'master.dbo.Papers' does not exist. Line 8
E_CSC_USER_DDLENTITYDOESNOTEXIST: Table Valued Function 'master.dbo.PaperAuthorAffiliations' does not exist. Line 9
I am following the instructions exactly how the page describes and I am not sure what is wrong. This worked for me a couple months ago completely fine.
I believe this errors results from these lines (6,7,8,9) of the script provided:
DECLARE @dataVersion string = "<MagContainer>";
DECLARE @blobAccount string = "<AzureStorageAccount>";
DECLARE @uriPrefix string = "wasb://" + @dataVersion + "@" + @blobAccount + "/";
DECLARE @outAuthorHindex string = "/Output/AuthorHIndex.tsv";
@Affiliations = Affiliations(@uriPrefix);
@Authors = Authors(@uriPrefix);
@Papers = Papers(@uriPrefix);
@PaperAuthorAffiliations = PaperAuthorAffiliations(@uriPrefix);
I am replacing <MagContainer> and <AzureStorageAccount> with my own values, and I'm confused on why I am still getting the errors.