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.