Closed
Description
❌ 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