My memsql table have 10 column and incoming file can contain 5 column or any number on that day…how to load it using pipeline…it should load only specific column from file…
Hi Raja. I believe your case is analogous to one of our examples.
You can specify the incoming pipeline columns with
(t.col1, t.col2, @var, @) syntax, where
@ is a placeholder that can skip fields. Additionally you can use the
SET t.column=udf_function(@var) to set specific columns.