hi, can we pick up a csv data irrespective of the mapping, e.g. i have 3 cols coming frm csv: name age sex i want csv to mysql i can do it the first tym but what if the column order is not constant. it can come in any sequence other tym like age sex name etc. can it be done by dynamic schema ? if so how ?
Hi
xdshi, I have a question related to dynamic schema. I am loading a file into mysql table. schema is defined as dynamic.
tfileinputdelimted-> tmap -> tmysqloutput
suppose, my input file has 2 columns- id , name. my table also has same columns. (ID int and Name String).
Problem is, when my ID is null in input file, my job is not inserting the records and throwing an error. (can not insert ' ' in a int column ). I think it is reading those null also as blank string (' ').
Is there any solution to this issue?
Thanks in advance.
