none
Basic question - extracting a tab delimited file

    Question

  • Hi all,

    This is a basic question (new to u-sql) but i spent hours today trying to figure it out. I uploaded a simple tab delimited file (no header row) and tried to import it into a table. 

    I played with a lot of different Extractor options like Text(), Tsv(), with different parameters.

    @stock = 
    EXTRACT id int,
    item string
    FROM @"/retail/stock.txt"
    USING Extractors.Text(delimiter: '\t', silent:true);
    INSERT INTO sales.stock
    SELECT * FROM @stock;

    But it always return this Vertex user code error

    Vertex SV1_Extract_Partition[0].v1 {6C16D5EC-D23E-4A45-A3F2-0C5BF6D8D435} failed 

    Error:
    Vertex user code error

    exitcode=CsExitCode_StillActive Errorsnippet=An error occurred while processing adl://datastore1.azuredatalakestore.net/retail/stock.txt

    Could someone please shed some light on this? Thanks a lot!!


    Thursday, August 3, 2017 10:04 PM

All replies