Skip to content

Test failure: test_sql_execution_partial #333

Closed
@github-actions

Description

@github-actions
❌ test_sql_execution_partial: assert [(10103, 1011..., 10069), ...] == [(10282, 1017..., 10065), ...] (5.099s)
assert [(10103, 1011..., 10069), ...] == [(10282, 1017..., 10065), ...]
  
  At index 0 diff: (10103, 10110) != (10282, 10171)
  
  Full diff:
    [
        (
  -         10282,
  -         10171,
  -     ),
  -     (
  -         10110,
  ?            -
  +         10103,
  ?             +
            10110,
        ),
        (
  -         10103,
  ?           -
  +         10023,
  ?            +
            10023,
        ),
        (
  -         10022,
  -         10017,
  ?             -
  +         10001,
  ?            +
  +         10018,
        ),
        (
  +         10044,
  -         10110,
  ?             ^
  +         10111,
  ?             ^
  -         10282,
        ),
        (
  -         10009,
  ?           ^^
  +         10199,
  ?           ^^
  -         10065,
  ?            ^^
  +         10022,
  ?            ^^
        ),
        (
  -         10153,
  ?           ^^
  +         10023,
  ?           ^^
  -         10199,
  -     ),
  -     (
  -         10112,
            10069,
        ),
        (
  +         11371,
  -         10023,
  ?            ^
  +         10003,
  ?            ^
  -         10153,
        ),
        (
  +         11371,
  +         11201,
  +     ),
  +     (
  -         10012,
  ?             ^
  +         10014,
  ?             ^
  +         10023,
  +     ),
  +     (
            10003,
  +         11222,
        ),
    ]
04:48 DEBUG [databricks.sdk] Loaded from environment
04:48 DEBUG [databricks.sdk] Ignoring pat auth, because metadata-service is preferred
04:48 DEBUG [databricks.sdk] Ignoring basic auth, because metadata-service is preferred
04:48 DEBUG [databricks.sdk] Attempting to configure auth: metadata-service
04:48 INFO [databricks.sdk] Using Databricks Metadata Service authentication
[gw9] linux -- Python 3.10.15 /home/runner/work/lsql/lsql/.venv/bin/python
04:48 DEBUG [databricks.sdk] Loaded from environment
04:48 DEBUG [databricks.sdk] Ignoring pat auth, because metadata-service is preferred
04:48 DEBUG [databricks.sdk] Ignoring basic auth, because metadata-service is preferred
04:48 DEBUG [databricks.sdk] Attempting to configure auth: metadata-service
04:48 INFO [databricks.sdk] Using Databricks Metadata Service authentication
04:48 DEBUG [databricks.labs.lsql.core] Executing SQL statement: SELECT * FROM nyctaxi.trips LIMIT 10
04:48 DEBUG [databricks.sdk] POST /api/2.0/sql/statements/
> {
>   "catalog": "samples",
>   "format": "JSON_ARRAY",
>   "statement": "SELECT * FROM nyctaxi.trips LIMIT 10",
>   "warehouse_id": "DATABRICKS_WAREHOUSE_ID"
> }
< 200 OK
< {
<   "manifest": {
<     "chunks": [
<       {
<         "chunk_index": 0,
<         "row_count": 10,
<         "row_offset": 0
<       }
<     ],
<     "format": "JSON_ARRAY",
<     "schema": {
<       "column_count": 6,
<       "columns": [
<         {
<           "name": "tpep_pickup_datetime",
<           "position": 0,
<           "type_name": "TIMESTAMP",
<           "type_text": "TIMESTAMP"
<         },
<         "... (5 additional elements)"
<       ]
<     },
<     "total_chunk_count": 1,
<     "total_row_count": 10,
<     "truncated": false
<   },
<   "result": {
<     "chunk_index": 0,
<     "data_array": [
<       [
<         "2016-02-13T21:47:53.000Z",
<         "... (5 additional elements)"
<       ],
<       "... (9 additional elements)"
<     ],
<     "row_count": 10,
<     "row_offset": 0
<   },
<   "statement_id": "01efa631-7ad9-17a9-b776-6c034d9b6d26",
<   "status": {
<     "state": "SUCCEEDED"
<   }
< }
04:48 DEBUG [databricks.sdk] Loaded from environment
04:48 DEBUG [databricks.sdk] Ignoring pat auth, because metadata-service is preferred
04:48 DEBUG [databricks.sdk] Ignoring basic auth, because metadata-service is preferred
04:48 DEBUG [databricks.sdk] Attempting to configure auth: metadata-service
04:48 INFO [databricks.sdk] Using Databricks Metadata Service authentication
04:48 DEBUG [databricks.labs.lsql.core] Executing SQL statement: SELECT * FROM nyctaxi.trips LIMIT 10
04:48 DEBUG [databricks.sdk] POST /api/2.0/sql/statements/
> {
>   "catalog": "samples",
>   "format": "JSON_ARRAY",
>   "statement": "SELECT * FROM nyctaxi.trips LIMIT 10",
>   "warehouse_id": "DATABRICKS_WAREHOUSE_ID"
> }
< 200 OK
< {
<   "manifest": {
<     "chunks": [
<       {
<         "chunk_index": 0,
<         "row_count": 10,
<         "row_offset": 0
<       }
<     ],
<     "format": "JSON_ARRAY",
<     "schema": {
<       "column_count": 6,
<       "columns": [
<         {
<           "name": "tpep_pickup_datetime",
<           "position": 0,
<           "type_name": "TIMESTAMP",
<           "type_text": "TIMESTAMP"
<         },
<         "... (5 additional elements)"
<       ]
<     },
<     "total_chunk_count": 1,
<     "total_row_count": 10,
<     "truncated": false
<   },
<   "result": {
<     "chunk_index": 0,
<     "data_array": [
<       [
<         "2016-02-13T21:47:53.000Z",
<         "... (5 additional elements)"
<       ],
<       "... (9 additional elements)"
<     ],
<     "row_count": 10,
<     "row_offset": 0
<   },
<   "statement_id": "01efa631-7ad9-17a9-b776-6c034d9b6d26",
<   "status": {
<     "state": "SUCCEEDED"
<   }
< }
[gw9] linux -- Python 3.10.15 /home/runner/work/lsql/lsql/.venv/bin/python

Running from nightly #6

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions