pingcap/tidb

Lightning, optimize error: table '%s' schema not found

Open

#29,885 opened on Nov 17, 2021

View on GitHub
 (2 comments) (0 reactions) (0 assignees)Go (40,090 stars) (6,186 forks)batch import
component/lightninghelp wantedseverity/moderatetype/bug

Description

Enhancement

Lightning from v5.0.2 , still can not locate the problem by reporting an error. When importing in csv format and the file name is incorrect, an error is reported table not found in schema, it is recommended to report a complete error: file cant match table

https://github.com/pingcap/br/pull/1114/files

Contributor guide

Tech stack
go
Domain
backenddatabasetooling
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
under 1 hour
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Go programmingFamiliarity with TiDB Lightning
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
85
Research direction
Look at the linked PR (https://github.com/pingcap/br/pull/1114/files) to understand the current error handling in Lightning's CSV import. The error message is likely generated in the Lightning codebase under the 'lightning' directory. Search for the string 'table schema not found' to locate the relevant code. Update the error to provide a more descriptive message indicating the filename mismatch.