none
External table error RRS feed

  • Question

  • Hello Team,

    I am getting the below error when querying the external table:

    Msg 107090, Level 16, State 1, Line 8
    HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: MalformedInputException: Input length = 1

    This is my table defination:

    CREATE EXTERNAL TABLE [ExtPB].[UnicodeTest]
    (
    [Test] NVARCHAR(50) NOT NULL
    )
    WITH (DATA_SOURCE = [AEAPBlobStorage],LOCATION = N'/Test/Unicode/',FILE_FORMAT = [CapPipeDelimited],REJECT_TYPE = VALUE,REJECT_VALUE = 0)

    And the file contains the value:

    Test
    Østfold HF
    Ministère Etrangères
    läns landsting

    So can any one help me understand what the error is?


    Monday, July 15, 2019 12:34 PM

Answers

  • Hello Angoyal,

    Thank you for your input.

    The issue was due to file coding being ANSI rather than UTF 8.

    I updated the file type to UTF 8 and it worked.

    • Marked as answer by Nandan Hegde Tuesday, July 16, 2019 11:07 AM
    Tuesday, July 16, 2019 6:58 AM

All replies

  • Hi Nandan,

    This error seems due to Unicode characters in the input file. Could you please try this with normal strings in input and try to create the table. Just to make sure that this issue is due to the Unicode characters only.

    Tuesday, July 16, 2019 6:14 AM
    Moderator
  • Hello Angoyal,

    Thank you for your input.

    The issue was due to file coding being ANSI rather than UTF 8.

    I updated the file type to UTF 8 and it worked.

    • Marked as answer by Nandan Hegde Tuesday, July 16, 2019 11:07 AM
    Tuesday, July 16, 2019 6:58 AM
  • Hi Nandan,

    I hope the information provided for your concern is helpful. Please "Mark as answer" if it was helpful, so that it can help the other users with same problem.

    If you need more information, please let us know.

    Tuesday, July 16, 2019 8:28 AM
    Moderator