search

apla / node-clickhouse

Yandex ClickHouse driver for nodejs
MIT License
216 stars 50 forks source link

How to import the csv file which the columns are different with the datables table #24

Closed gclinux closed 5 years ago

gclinux commented 5 years ago

csv file： A,B,C,D,E A,B,C,D,E

table： A,E,D

nezed commented 5 years ago

Setting input_format_skip_unknown_fields to true may help you https://clickhouse.yandex/docs/en/operations/settings/settings/#input-format-skip-unknown-fields

Add this to queryOptions

nezed commented 5 years ago

Looks like solved.

shubham696 commented 2 years ago

@gclinux @nezed how you wrote infile query. Im not able to use infile, can you post your clickhouse query you run for this