partition projection doesn't work... [ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal error

0

I have this table:

  RetsIncomingTable:
    Type: AWS::Glue::Table
    Properties:
      CatalogId: !Ref AWS::AccountId
      DatabaseName: !Ref TheDatabase
      TableInput:
        Name: incoming
        TableType: EXTERNAL_TABLE
        Parameters: 
          classification: json
          projection.enabled: 'true'
          projection.partition_id.type: 'injected'
          storage.location.template: !Sub 's3://${Bucket}/incoming/${!partition_id}/'
        PartitionKeys:
          - Name: partition_id
            Type: string
        StorageDescriptor:
          Columns:
            - Name: systemid
              Type: string
            - Name: eventTimestamp
              Type: string
            - Name: eventType
              Type: string
            - Name: source
              Type: string
            - Name: updtDate
              Type: string
            - Name: rawdata
              Type: string
            - Name: media
              Type: string
          InputFormat: org.apache.hadoop.hive.ql.io.HiveInputFormat
          OutputFormat: org.apache.hadoop.hive.ql.io.HiveOutputFormat
          SerdeInfo:
            SerializationLibrary: org.openx.data.jsonserde.JsonSerDe
            Parameters:
              'serialization.format': '1'
          Location: !Sub 's3://${Bucket}/incoming/'

when I do select * from incoming where partition_id = 'xx', I get:

[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal error while executing this query. Please contact AWS support for further assistance. You will not be charged for this query. We apologize for the inconvenience. This query ran against the "test-xyz" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: ee7d1d16-da1f-42bc-97eb-c70ac1d3a4d3

What's causing this, and how can I fix it?

AlexR
feita há 2 meses149 visualizações
Sem respostas

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas