No authentication methods were found. Going without authentication
No authentication methods were found. Going without authentication
No authentication methods were found. Going without authentication
No authentication methods were found. Going without authentication
Task ID: 0 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 7 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 8 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 6 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 0 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 5 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 8 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 5 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 1 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 4 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 9 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 2 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 6 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 0 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 2 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 4 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 2 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 3 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 8 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 3 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 1 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 3 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 5 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 6 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 5 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 7 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 1 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 3 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 4 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 8 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 4 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 1 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 9 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 0 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 9 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 6 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 7 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 9 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 2 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 7 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 0 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 3 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 0 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 1 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 8 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 5 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 2 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 4 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 1 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 0 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 9 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 1 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 8 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 7 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 5 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q30: Группировка по нескольким полям
SELECT
    level,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY level, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 6 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 3 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:13:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q31: Аналогичная группировка с другими полями
SELECT
    request_id,
    client_ip,
COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
WHERE message <> ''
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 5 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 7 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 5 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:12:1: Error: At function: OrderedFlatMap, At function: TopSort
            <main>:9:6: Error: At function: AggregateMergeFinalize
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:9:6: Error: At function: CombineByKey, At lambda, At function: AsStruct, At tuple
                        [/lib/yql/aggregate.yqls:443:22-<main>:443:22]: Error: At function: FlatMap
                            <main>:8:9: Error: At function: SafeCast
                                <main>:8:13: Error: At function: JsonValue
                                    <main>:8:25: Error: At function: Member
                                        <main>:9:6: Error: At function: CastStruct, At function: CastStruct, At function: CastStruct
                                            <main>:9:6: Error: Failed to convert member with name: metadata from type Optional<Utf8> to type Optional<JsonDocument>

 Query text: 
-- Q32: Похожая группировка без фильтра
SELECT
    request_id,
    client_ip,
    COUNT(*) AS c,
    SUM(CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32)),
    AVG(CAST(JSON_VALUE(metadata, "$.response_time") AS DOUBLE))
FROM `log/log_column`
GROUP BY request_id, JSON_VALUE(metadata, "$.client_ip") AS client_ip
ORDER BY c DESC
LIMIT 10
Task ID: 9 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000
Task ID: 0 Status: GENERIC_ERROR <main>: Error: Execution, code: 1060
    <main>:3:1: Error: At tuple, At tuple, At tuple
        <main>:26:1: Error: At function: OrderedFlatMap, At function: Take, At function: Skip, At function: TopSort
            <main>:10:6: Error: At function: AggregateMergeFinalize, At function: AggregateCombine
                <main>:3:1: Error: At function: DqCnUnionAll, At function: TDqOutput, At function: DqStage, At lambda
                    <main>:10:6: Error: At function: FlatMap, At lambda, At function: Just, At function: AsStruct, At tuple
                        <main>:21:35: Error: At function: If
                            <main>:21:13: Error: At function: FlatMap, At function: JsonValue, At function: JsonValue, At function: JsonValue
                                <main>:17:16: Error: Expected Json, Json?, JsonDocument or JsonDocument?, but got: Optional<Utf8>

 Query text: 
-- Q39: Сложная группировка с множеством условий
SELECT
    traffic_source_id,
    search_engine_id,
    adv_engine_id,
    src,
    dst,
    COUNT(*) AS views
FROM `log/log_column`
WHERE service_name = 'service1'
    AND timestamp BETWEEN (CurrentUtcTimestamp() - Interval("P7D")) AND CurrentUtcTimestamp()
    AND CAST(JSON_VALUE(metadata, "$.is_refresh") AS Int32) = 0
GROUP BY
    JSON_VALUE(metadata, "$.traffic_source_id") AS traffic_source_id,
    JSON_VALUE(metadata, "$.search_engine_id") AS search_engine_id,
    JSON_VALUE(metadata, "$.adv_engine_id") AS adv_engine_id,
    CASE
        WHEN JSON_VALUE(metadata, "$.search_engine_id") = '0'
        AND JSON_VALUE(metadata, "$.adv_engine_id") = '0'
        THEN JSON_VALUE(metadata, "$.referer")
        ELSE ''
    END AS src,
    JSON_VALUE(metadata, "$.url") AS dst
ORDER BY views DESC
LIMIT 10
OFFSET 1000

No authentication methods were found. Going without authentication
No authentication methods were found. Going without authentication
No authentication methods were found. Going without authentication
contrib/tools/python3/Lib/tempfile.py:940: ResourceWarning: Implicitly cleaning up <TemporaryDirectory '/home/runner/.ya/build/build_root/dyq9/002e17/ydb/tests/stress/log/tests/test-results/py3test/tmp5atrz9m6'>
