azure-samples/academic-knowledge-analytics-visualization

Various examples to perform big data analytics over Microsoft Academic Graph and visualize the results.

academic-knowledge-analytics-visualization's Issues

File not found: samples/CreateDatabase.usql

This issue is for a: (mark with an x)

- [ ] bug report -> please search issues before submitting
- [ ] feature request
- [x] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

Browse the repo.

Any log messages given by the failure

None

Expected/desired behavior

Find file "samples/CreateDatabase.usql"

OS and Version?

Windows 10

Versions

Mention any other details that might be useful

I am a newbie of MAG and I am struggle searching file "samples/CreateDatabase.usql" mentioned in step 2 of Create database from MAG data before running analytics examples in README.md.

It says:

Copy code in samples/CreateDatabase.usql and paste into the code block.

After searching the whole repo, I am sure this file doesn't exist. So where can I find it ?

Documentation and script comment request for CreateDatabase.usql

This issue is for a: (mark with an x)

- [ ] bug report -> please search issues before submitting
- [ ] feature request
- [x] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

In File CreateDatabase.usql
DECLARE @DATAVERSION string = "mag-##DatasetVersion##";
DECLARE @blobAccount string = "##YourBlobAccount##";
DECLARE @uriPrefix string = "wasb://" + @DATAVERSION + "@" + @blobAccount + "/";

Any log messages given by the failure

Failure message in Visual Studio on does not exist.

Expected/desired behavior

Suggestion to please update the walkthrough and a comment in the script that the user should replace the text so that the uri prefix will build e.g.

DECLARE @DATAVERSION string = "mag-2019-01-25";
DECLARE @blobAccount string = "mymagblob";
DECLARE @uriPrefix string = "wasb://" + @DATAVERSION + "@" + @blobAccount + "/";

OS and Version?

Windows 7, 8 or 10. Linux (which distribution). macOS (Yosemite? El Capitan? Sierra?)

Windows Standard E2s v3 (2 vcpus, 16 GB memory)

Versions

Mention any other details that might be useful

For those users who have never used Azure or Visual Studio before but want to start using MAG, the samples are really important. However, it would be helpful if they could be a little bit clearer for newbies. For example, build and then submit a script. The documentation request above relates to a gotcha for a visual studio novice. A comment flag in the build dbase script might be enough... but for complete newcomers a few more very basic sentences in the samples docs would be a real help.

Many thanks!

Paul

PaperAuthorAffiliations from CreateDatabase.usql fails with never MAG versions

This issue is for a: (mark with an x)

- [X] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

Run CreateDatabase.usql from 00. Common Scripts with recent MAG versions

The code that's used to create the PaperAuthorAffiliations table is responsible and sufficient to trigger the error described below.

Any log messages given by the failure

Vertex failed
Vertex SV25_Extract_Partition[38]
VertexFailedFast: Vertex failed with a fail-fast error
E_RUNTIME_USER_EXTRACT_ROW_DELIMITER_EXPECTED: Too many columns in input record.

Description
Expected row delimiter in input record after processing 1 record(s) in the vertex' input split. Expected 5 column(s) but encountered more data.

Row Delimiter: 0x0
Column Delimiter: 0x9
HEX: 52 C3 B8 79 09 0D 0A 32 39 31 37 34 33 30 31 36 39 09 32 39 31 36 39 39 30 39 35 34 09 09 36 09 43 2E 20 53 63 68 6F 6C 7A 65 09 ### 0D 0A 32 39 31 37 34 33 30 31 37 30 09 32 31 31 30 32 31 33 34 36 34 09 31 37 33
TEXT: R..y\t\r\n2917430169\t2916990954\t\t6\tC. Scholze\t ### \r\n2917430170\t2110213464\t173

I managed to narrow it down to the PaperAuthorAffiliations table creation. All other tables are created fine. The oldest MAG version I have access to works (2019-03-11), all others fail. See below

Expected/desired behavior

Successful completion on all MAG versions

OS and Version?

Azure Portal

Versions

• mag-2019-04-11: Fails
• mag-2019-04-01: Fails
• mag-2019-03-22: Fails
• mag-2019-03-11: Works

Mention any other details that might be useful

NA

The 'plug in' requires Visual Studio 2015

Hello, guys!

I followed the instruction get Visual Studio 2017 and Plug in for Visual Studio 2015 downloaded. When I tried to install the plug in, I was told that 'The pluginvrequires Visual Studio 2015'. Should I download Visual Studio 2015 instead 2017?

Thanks in advance!

Please provide us with the following information:

This issue is for a: (mark with an x)

- [ ] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

Any log messages given by the failure

Expected/desired behavior

OS and Version?

Windows 7, 8 or 10. Linux (which distribution). macOS (Yosemite? El Capitan? Sierra?)

Versions

Mention any other details that might be useful

---

Thanks! We'll be in touch soon.