Can't insert values without columns?

Hi,
I cannot figure out what this error mean and how to avoid it.

I get error Can't insert values without columns.

I am just following the tutorial and importing a CSV file in an existing table.

As you see the values are mapped correctly to the columns of the existing table.

I also tried to delete the two superflous formats (TSV) and keep only CSV.

5
14 comments

Could you provide a sample DDL & CSV?

1

I send it to your mail.

 

0

I am also running into this problem. I have a table created in postgres with 15 or so columns of 'text' and a CSV that should be UTF-8, first row is header.

 

Did you all identify what the problem was?

0

vasily chernov

I have the same issue. Two columns: Id, Name.

Very simple CSV, 3 rows as shows "Data preview"

"DDL Preview" shows nothing (empty tab)

 

 

0

I have got the same problem.

0

@Adrian Księżarczyk, @Miroslav Valent,

Could you provide a sample DDL for you data sources and specify database engine you work with?

0

My DB engine is PostgreSQL 12. DLL preview is empty.

 

1

I have got the same problem.

0

So am I. Did anyone find a solution to this?!

0

The fix will be available in the nearest DataGrip 2020.1 EAP.

2

I am facing same issue, when will be 2020.1 EAP available ?

0

I get error Can't insert values without columns.

 

0

Please sign in to leave a comment.