U-SQL (Azure Data Lake language) script error

Question

Using sample script from a Data Lake Analytics tutorial, the following error occurs when building the script:

E_CSC_USER_SYNTAXERROR: syntax error. Expected one of: RETURN '[' ALTER COMBINE CREATE DECLARE DEPLOY DROP END EXTRACT IF INSERT OUTPUT PROCESS REDUCE REFERENCE RESOURCE SELECT SET TABLE TRUNCATE UPDATE USE USING VIEW identifier quoted-identifier variable ';' '('

The error line is the last line of the script. The script in the tutorial does end with an OUTPUT statement, which the syntax error is saying is expected.

Any thoughts?

Michael Rys · Accepted Answer · 2015-11-05 23:39:25Z

4

(Azure DL Team here as well): We identified the issues and are going to fix it. In the mean time:

Please split the script that does the create and load and then query into two scripts: one that does the create and load, and one that does the query.
The end of the definition of the TVF (before DROP TABLE IF EXISTS ) needs an END;

I hope this helps. Michael

answered Nov 5, 2015 at 23:39

Michael Rys

6,68417 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

saveenr · Accepted Answer · 2018-04-08 22:12:04Z

4

Looks like we may have an error in the example. We are investigating. Will update as soon as we learn more.

edited Apr 8, 2018 at 22:12

answered Nov 5, 2015 at 4:43

saveenr

8,6593 gold badges22 silver badges20 bronze badges

1 Comment

saveenr Over a year ago

The sample script has been fixed.

Collectives™ on Stack Overflow

U-SQL (Azure Data Lake language) script error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related