dolthub / dolthub/dolt

Unable to `LOAD DATA LOCAL INFILE` in DoltSQL shell

Open
#10,636 0 comments 0 reactions 0 assignees View on GitHub
bug cli
Dominant language
Go
Stars
24.5k
Forks
873
Avg merge
1d 8h
Merged PRs (30d)
120

Description

I have a dolt sql-server running on port 3307 (`dolt sql-server --port 3307`).

When I try to load a CSV in the DoltSQL shell, I get the following error message:
```
tmp/main*> LOAD DATA LOCAL INFILE '/Users/amx/table1.csv' INTO TABLE table1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;
LOCAL supported only in sql-server mode
```

Contributor guide

No contributing guide indexed for this repository

Research direction

No source files or tests are named. Start by reproducing the issue with `dolt sql-server --port 3307`, then run the reported `LOAD DATA LOCAL INFILE` statement in the DoltSQL shell and trace the mode-handling entry point. Done means the command's behavior is corrected or its supported usage is made clear.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
cli, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.