AWS glue header doesn't work properly

0

Hello. I am using aws glue, but the aws glue header does not automatically recognize it. In other words, the header is included in the data and the query does not work properly. The header is Korean, and I tried classfier, but it didn't work. Is there a solution?

plus. I use Athena to get the result.

질문됨 2년 전862회 조회
1개 답변
0

The classifier has an option to enter the column names if your columns are not dynamic. Enter image description here Enter image description here

If that would not work, you could try one of the following:

  • Change the column names in the Data Catalog, set the SchemaChangePolicy to LOG, and set the partition output configuration to InheritFromTable for future crawler runs.
    
  • Create a custom grok classifier to parse the data and assign the columns that you want.
    
profile pictureAWS
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠