ByConity icon indicating copy to clipboard operation
ByConity copied to clipboard

Published 20 hours ago • verified publisher icon ByConity

Import csv files

Open syysummer opened this issue 9 months ago • 3 comments

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 image image

syysummer avatar May 06 '24 10:05 syysummer

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

nudles avatar May 14 '24 03:05 nudles

@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.

syysummer avatar May 16 '24 08:05 syysummer

@syysummer can you try to change these two settings to 1 for your byconity servers (via the configuration files)? https://github.com/ByConity/ByConity/blob/bfa389c67b623640d20a2ef1b0097d05ba167d6d/src/Core/Settings.h#L375

nudles avatar May 17 '24 03:05 nudles

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

syysummer avatar May 20 '24 09:05 syysummer

@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

nudles avatar May 23 '24 02:05 nudles