Glue crawler ignores Int/Long with trailing whitespaces

0

We have incoming file with the fixed length field length (.dat). For example: |2|123 |AWS |0505 |3 When Glue Crawler crawles the file, it ignores all the int/long values that have trailing spaces. In this case 123 value won't appear in the result when querying created table in athena. I have tried to create the custom classifier to remove the white spaces however there is no specific custom Quote symbol that I can provide in the config to make crawler pick it up instead of default csv one. Any help would be appreciated

Aucune réponse

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions