Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Test failure: test_sql_execution_partial #333

Closed
github-actions bot opened this issue Nov 19, 2024 · 0 comments · Fixed by #350
Closed

Test failure: test_sql_execution_partial #333

github-actions bot opened this issue Nov 19, 2024 · 0 comments · Fixed by #350
Labels
bug Something isn't working

Comments

@github-actions
Copy link

❌ 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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

0 participants