Unable to import table with more than 700 columns

Answered

Created October 11, 2022 05:55

Hi there,

I have a big table which actually has more than 700 columns. When I right-click import from file and select the file, table content doesn't map to the table, and it generates 0 rows. (screenshot below)

Then I extracted only a few columns to import as a test, it works fine.

Is there a setting for IntelliJ to limit the number of columns importing? Is there a way I could import this big file without splitting columns?

Thanks,

7 comments

Daniil

Created October 12, 2022 09:27

Hello,

Can you please collect the IDE logs (Help | Collect Logs and Diagnostic Data), upload it to https://uploads.jetbrains.com/ and provide its ID?

Taylor Shen

Created October 12, 2022 22:23

Hi Daniil,

Here is the ID: 2022_10_12_Q82DLTmgp6hXW1vBHn5UD4

Thank you for your help.

Daniil

Created October 14, 2022 09:57

Hi,

Is there a chance to update IntelliJ IDEA to the latest available version to see if it helps?

Taylor Shen

Created October 16, 2022 23:10

Hi,

Thanks for the advice. I have updated to the latest version but the issue still remains. I've uploaded the new logs to the link provided - ID: 2022_10_16_w1UBr4RRZ2sbHfPwUKvAqs.

Would be appreciate if you could help look into it

Daniil

Created October 19, 2022 11:04

Hello,

I see the following error in the logs:

Can't rollback changes with error records. Check connection and database settings and try again

Can you upload a file example to https://uploads.jetbrains.com/ and share DDL of the table? It looks like it contains some specific entries which cause an exception.

Taylor Shen

Created October 21, 2022 00:23

Hi,

I uploaded file example and DDL to the link provided. ID: 2022_10_21_Z6tMzHVezAAs5TJjF5F5pp.

This example table also causes the same error in the logs.

Daniil

Created October 25, 2022 09:56

I see the actual error after reproducing it:

[22023] PreparedStatement can have at most 65,535 parameters. Please consider using arrays, or splitting the query in several ones, or using COPY. Given query has 73,800 parameters.