Home Forums Hive / HCatalog Delimiter fail

Tagged: 

This topic contains 1 reply, has 2 voices, and was last updated by  tedr 1 year, 1 month ago.

  • Creator
    Topic
  • #26112

    Hi!
    Loading a, comma delimited, file into HCatalog. I run into problems when a row contain un unintended comma;
    1005475-7 ,HÄGG,KARL-HENRIK ,0000000000,000000001,000000000014900,P

    It’s the comma after HÄGG that I want to ignore.
    In QlikView I use fixed length to sort this issue. How solve this in HCatalog?
    Running Oracle VirtualBox and Sandbox.

    regards
    thomas

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #26274

    tedr
    Member

    Hi Thomas,

    If you are able to do so, enclose the data that you wish to contain the comma in quotes. or possibly change from comma separated to tab separated.

    Thanks,
    Ted.

    Collapse
Viewing 1 replies (of 1 total)