issues
search
databrickslabs
/
lsql
Lightweight SQL execution wrapper only on top of Databricks SDK
https://pypi.org/project/databricks-labs-lsql/
Other
14
stars
4
forks
source link
Test failure: `test_sql_execution`
#349
Closed
github-actions[bot]
closed
1 week ago
github-actions[bot]
commented
1 week ago
❌ test_sql_execution: assert [(10103, 1011..., 10069), ...] == [(10282, 1017..., 10065), ...] (1.362s)
``` 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 [gw7] 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 pickup_zip, dropoff_zip FROM nyctaxi.trips LIMIT 10 04:48 DEBUG [databricks.sdk] POST /api/2.0/sql/statements/ > { > "catalog": "samples", > "format": "JSON_ARRAY", > "statement": "SELECT pickup_zip, dropoff_zip 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": 2, < "columns": [ < { < "name": "pickup_zip", < "position": 0, < "type_name": "INT", < "type_text": "INT" < }, < "... (1 additional elements)" < ] < }, < "total_chunk_count": 1, < "total_row_count": 10, < "truncated": false < }, < "result": { < "chunk_index": 0, < "data_array": [ < [ < "10103", < "... (1 additional elements)" < ], < "... (9 additional elements)" < ], < "row_count": 10, < "row_offset": 0 < }, < "statement_id": "01efa631-7f60-1b86-bc24-57a108eb7f29", < "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 pickup_zip, dropoff_zip FROM nyctaxi.trips LIMIT 10 04:48 DEBUG [databricks.sdk] POST /api/2.0/sql/statements/ > { > "catalog": "samples", > "format": "JSON_ARRAY", > "statement": "SELECT pickup_zip, dropoff_zip 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": 2, < "columns": [ < { < "name": "pickup_zip", < "position": 0, < "type_name": "INT", < "type_text": "INT" < }, < "... (1 additional elements)" < ] < }, < "total_chunk_count": 1, < "total_row_count": 10, < "truncated": false < }, < "result": { < "chunk_index": 0, < "data_array": [ < [ < "10103", < "... (1 additional elements)" < ], < "... (9 additional elements)" < ], < "row_count": 10, < "row_offset": 0 < }, < "statement_id": "01efa631-7f60-1b86-bc24-57a108eb7f29", < "status": { < "state": "SUCCEEDED" < } < } [gw7] linux -- Python 3.10.15 /home/runner/work/lsql/lsql/.venv/bin/python ```
Running from
nightly #6
❌ test_sql_execution: assert [(10103, 1011..., 10069), ...] == [(10282, 1017..., 10065), ...] (1.362s)
``` 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 [gw7] 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 pickup_zip, dropoff_zip FROM nyctaxi.trips LIMIT 10 04:48 DEBUG [databricks.sdk] POST /api/2.0/sql/statements/ > { > "catalog": "samples", > "format": "JSON_ARRAY", > "statement": "SELECT pickup_zip, dropoff_zip 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": 2, < "columns": [ < { < "name": "pickup_zip", < "position": 0, < "type_name": "INT", < "type_text": "INT" < }, < "... (1 additional elements)" < ] < }, < "total_chunk_count": 1, < "total_row_count": 10, < "truncated": false < }, < "result": { < "chunk_index": 0, < "data_array": [ < [ < "10103", < "... (1 additional elements)" < ], < "... (9 additional elements)" < ], < "row_count": 10, < "row_offset": 0 < }, < "statement_id": "01efa631-7f60-1b86-bc24-57a108eb7f29", < "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 pickup_zip, dropoff_zip FROM nyctaxi.trips LIMIT 10 04:48 DEBUG [databricks.sdk] POST /api/2.0/sql/statements/ > { > "catalog": "samples", > "format": "JSON_ARRAY", > "statement": "SELECT pickup_zip, dropoff_zip 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": 2, < "columns": [ < { < "name": "pickup_zip", < "position": 0, < "type_name": "INT", < "type_text": "INT" < }, < "... (1 additional elements)" < ] < }, < "total_chunk_count": 1, < "total_row_count": 10, < "truncated": false < }, < "result": { < "chunk_index": 0, < "data_array": [ < [ < "10103", < "... (1 additional elements)" < ], < "... (9 additional elements)" < ], < "row_count": 10, < "row_offset": 0 < }, < "statement_id": "01efa631-7f60-1b86-bc24-57a108eb7f29", < "status": { < "state": "SUCCEEDED" < } < } [gw7] linux -- Python 3.10.15 /home/runner/work/lsql/lsql/.venv/bin/python ```Running from nightly #6