none
Unexpected number of columns in input stream when querying Table valued function

    Question

  • I have created table valued function based on TSV file. I can succesfully see name EmotionView in Data Explorer. How ever when I make query to the function.
    I'm totally lost why I get error about unexpected number of columns. 

    QUERY:
    @tvf = [EmotionDB].[dbo].[EmotionView]();

    OUTPUT @tvf
        TO "/Outputs/EmotionDB.dbo.EmotionView.tsv"
        USING Outputters.Csv();

    ERROR:

    VertexFailedFast: Vertex failed with a fail-fast error
    E_RUNTIME_USER_EXTRACT_UNEXPECTED_NUMBER_COLUMNS: Unexpected number of columns in input stream.
    DESCRIPTION
    Vertex failure triggered quick job abort. Vertex failed: SV1_Extract[0][0] with error: Vertex user code error.
    RESOLUTION
    DETAILS

    Vertex SV1_Extract[0][0].v1 {20390CDE-BA71-4A86-A7DD-1378CEE4272A} failed 

    Error:
    Vertex user code error


    Kenny_I

    Tuesday, December 6, 2016 12:13 PM

All replies