diff options
| author | Kapil Viren Ahuja <k.v.ahuja@gmail.com> | 2017-03-04 12:40:09 +0530 |
|---|---|---|
| committer | Kapil Viren Ahuja <k.v.ahuja@gmail.com> | 2017-03-04 12:40:09 +0530 |
| commit | 6c8bbce9c961b9876a93a8aac7e4b4276978ca59 (patch) | |
| tree | 91d61940c3dcb65f72d0405e110e35e4b4747f57 /queries/match.sql | |
| parent | 2ba860f0452ce4147b845db75d79014d059c27ec (diff) | |
| download | processor-6c8bbce9c961b9876a93a8aac7e4b4276978ca59.tar.gz processor-6c8bbce9c961b9876a93a8aac7e4b4276978ca59.zip | |
Fixed the last match cols which was sending this job into a hung state without throwing any exception.
Diffstat (limited to 'queries/match.sql')
| -rw-r--r-- | queries/match.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/queries/match.sql b/queries/match.sql index 0b992f9..fc8ab7e 100644 --- a/queries/match.sql +++ b/queries/match.sql @@ -4,7 +4,7 @@ match.id AS "api_id", (match.data->'data'->'attributes'->>'createdAt')::timestamp as "created_at", (match.data->'data'->'attributes'->>'duration')::int AS "duration", match.data->'data'->'attributes'->>'gameMode' AS "game_mode", -COALESCE(NULLIF(match.data->'data'->'attributes'->>'patch_version', '2.2'), '0') AS "patch_version", +COALESCE(NULLIF(match.data->'data'->'attributes'->>'patch_version', ''), '2.2') AS "patch_version", match.data->'data'->'attributes'->>'shardId' AS "shard_id", match.data->'data'->'attributes'->'stats'->>'endGameReason' AS "end_game_reason", match.data->'data'->'attributes'->'stats'->>'queue' AS "queue", |