airbytehq / airbytehq/airbyte

[source-ms-sql] - Running a Select TOP 1024 with no filter

Đang mở
#74,887 2 bình luận 0 reaction 0 người được giao Xem trên GitHub
area/connectors autoteam community connectors/source/mssql needs-triage team/extensibility team/use type/bug
Ngôn ngữ chính
Python
Star
22.1k
Fork
5.3k
Chỉ số merge pull request
Chỉ số pull request đang chờ

Mô tả

### Connector Name

source-mssql

### Connector Version

4.3.5

### What step the error happened?

None

### Relevant information

My builds have slowed down significantly since upgrading to 4.3.5.
I have a table syncing on Incremental | Dedupe

For some reason a select TOP [column names] from [table] order by [column name] is occurring which is taking a very long time to run on my large table.

### Relevant log output

```shell
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcSelectQuerier$Result(hasNext):117 Received results from server.
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcSelectQuerier$Result(close):173 Closing SELECT MAX([DateTime]) FROM [rpt].[test]
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcPartitionsCreator(ensureCursorUpperBound):96 Maximum cursor column value in 'rpt.reporting_Reconciliation' is '"2026-03-16T03:03:41.067000"'.
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcPartitionsCreator(collectSample):108 Sampling stream 'rpt.test' at rate 1 / 65536.
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcSelectQuerier$Result():76 Querying SELECT TOP 1024 COLUMNS HERE FROM [rpt].[test] ORDER BY [DateTime]
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.j.JdbcConnectionFactory(get):44 Creating new connection for 'jdbc:sqlserver://############'.
```

### Contribute

- [ ] Yes, I want to contribute

---
**Internal Tracking:** https://github.com/airbytehq/oncall/issues/11627

Hướng dẫn đóng góp

Mở hướng dẫn đóng góp

Đánh giá

Issue này chưa được đánh giá.

Nhận issue mới trong hộp thư của bạn

Bản tóm tắt ngắn những issue GitHub phù hợp với người mới.