dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Dolt does not work in WSL 2

Open Hydrocharged opened this issue 5 years ago • 1 comments

Dolt does not operate correctly under Windows Subsystem for Linux 2. If you plan to use WSL with Dolt, we recommend using WSL 1.

Known issues:

  • Piping files into SQL can cause pipe errors specifically with large files, i.e. dolt sql < file.sql

Hydrocharged avatar Nov 05 '20 00:11 Hydrocharged

I encountered an issue in WSL2 (Ubuntu 20.04.4 LTS (GNU/Linux 5.10.102.1-microsoft-standard-WSL2 x86_64). I exported a csv from excel with type "CSV UTF-8 (Comma delimited) (*.csv)". That results in this file: utf8-bom.csv

Which if I try to import gives:

dolt table import -c -pk=state state_populations utf8-bom.csv 
Error determining the output schema.
cause: provided primary key not found
When attempting to move data from csv file:utf8-bom.csv to state_populations, could not determine the output schema.
Schema File: ""
explicit pks: "state"

If I create a new text file with the same content: utf8.csv

It imports just fine:

dolt table import -c -pk=state state_populations utf8.csv 
Rows Processed: 17, Additions: 17, Modifications: 0, Had No Effect: 0
Import completed successfully.

mkerollos avatar Jun 02 '22 22:06 mkerollos