syslog-wrong-order.ksql

SELECT 
CONCAT (
    REGEXP_EXTRACT(
        '(<(?<priority>\\d+)>)\\d+: (?<host>([a-z0-9\\-]+)): ]: (?<date>([a-zA-Z]{3}\\s+\\d+\\s+\\d+:\\d+:\\d+)|([0-9T:Z\\-]+)): (?<message>.+)', 
        `rawMessage`, 1
    ),
    REGEXP_EXTRACT(
        '(<(?<priority>\\d+)>)\\d+: (?<host>([a-z0-9\\-]+)): ]: (?<date>([a-zA-Z]{3}\\s+\\d+\\s+\\d+:\\d+:\\d+)|([0-9T:Z\\-]+)): (?<message>.+)', 
        `rawMessage`, 5
    ),
    ' ',
    REGEXP_EXTRACT(
        '(<(?<priority>\\d+)>)\\d+: (?<host>([a-z0-9\\-]+)): ]: (?<date>([a-zA-Z]{3}\\s+\\d+\\s+\\d+:\\d+:\\d+)|([0-9T:Z\\-]+)): (?<message>.+)', 
        `rawMessage`, 3
    ),
    ' ',
    REGEXP_EXTRACT(
        '(<(?<priority>\\d+)>)\\d+: (?<host>([a-z0-9\\-]+)): ]: (?<date>([a-zA-Z]{3}\\s+\\d+\\s+\\d+:\\d+:\\d+)|([0-9T:Z\\-]+)): (?<message>.+)', 
        `rawMessage`, 8
    )
)

FROM MEAMD_NET_INITIAL LIMIT 4;