CSV Import fails

Answered

Trying to import a 6 column CSV into a Azure SQL database table via the DataGrip import feature.

I'm setting all columns to VARCHAR(MAX) datatype as I have no need for typing in a quick bit of analysis I want to do.

Import creates the table fine then fails with error:

class java.lang.String cannot be cast to class java.lang.Number

I'm not trying to cast any string field as a number so this is confusing.

Anyone encountered this before? Thanks.

3 comments
Avatar
Yuriy Vinogradov
Comment actions Permalink

This should be fixed in latest version, please update to 2021.3.4 or try [EAP].

1
Comment actions Permalink

Thanks Yuriy. I am on 2021.3.4 

DataGrip 2021.3.4
Build #DB-213.6777.22, built on January 19, 2022
Licensed to ...
Subscription is active until November 4, 2022.
Runtime version: 11.0.13+7-b1751.25 x86_64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
macOS 10.15.7
GC: G1 Young Generation, G1 Old Generation
Memory: 2048M
Cores: 4
Non-Bundled Plugins:
    bundled-datagrip-help (213.6777.22)

I'll try the EAP release later on.

 

 

0
Comment actions Permalink

Hi, it didn't work with 2021.3.4  but I can confirm that for me EAP worked

0

Please sign in to leave a comment.