Import csv files

[syysummer]

ByConity 0.4.0 imports csv files through DBeaver tool, prompting that script parameters cannot be set
Can't set parameter at index 1 due to no JDBC style '?' placeholder found in the query

[nudles]

@syysummer can you share the table create sql and a sample of the csv file?

[syysummer]

@nudles
We exported the sql file and then imported the existing data into ByConity through a python script.
In version 0.3.2, we have tested that it is normal to import csv files in DBeaver. After the upgrade, we can no longer import csv files.

[nudles]

@syysummer
can you try to change these two settings to 1 for your byconity servers (via the configuration files)?

ByConity/src/Core/Settings.h

Line 375 in bfa389c

M(Bool, mysql_map_string_to_text_in_show_columns, false, "If enabled, String type will be mapped to TEXT in SHOW [FULL] COLUMNS, BLOB otherwise.", 0) \

[syysummer]

@nudles Hello,I have modified the configuration and still cannot import the csv file.

[nudles]

@syysummer you need to change the settings before launching byconity by updating the configuration file.
e.g., if you login as the 'default' user, then add the setting to
https://github.com/ByConity/ByConity/blob/master/docker/docker-compose/byconity-simple-cluster/users.yml#L7