Loading CSV using U-SQL is working but select is not working

Question

I am reading a csv file using

@serch=
       EXTRACT
         col1 int,
         col2 string,
         col3 string
FROM @"/datalake/in/in.csv"
    USING Extractors.Csv();

OUTPUT @serch
    TO  @"/datalake/output/out.csv"
      USING Outputters.Csv();

It is working fine but when we will do

select * from @serch or select col1,col2 from @serch

it is not working

Can you paste details of the error it is giving you?

saveenr
– saveenr

2017-05-17 14:15:31 +00:00
Commented May 17, 2017 at 14:15 — saveenr
– saveenr, Commented May 17, 2017 at 14:15

Igor · Accepted Answer · 2017-05-17 14:26:40Z

1

would be good if you can paste complete statement that is failing for you. Based on what you posted above, looks like you are missing rowset variable. so, your code should be something like @r = SELECT * ... followed by OUTPUT statement.

Furthermore, today, ADLA does not support interactive queries capabilities that allows returning results back to client or user. If that was the intent of your query above, that does not work today. So, the only way to get results is to output rowsets to files. Once interactive is supported, you would be able to do something like you outlined above.

hope this explains and clarifies, Igor

answered May 17, 2017 at 14:26

Igor

512 bronze badges

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

Collectives™ on Stack Overflow

Loading CSV using U-SQL is working but select is not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related