https://sourceforge.net/p/cloudbase/bugs/2/2009-02-17T05:01:32ZRecent changes to 2: 'ON DATA CONVERSION ERROR SKIP' does not work2009-02-17T05:01:32Z2009-02-17T05:01:32ZYoungWoo Kimhttps://sourceforge.net/u/warwithin/https://sourceforge.net070f2b62e3546fa47d9054bd993d1e356859feef

<div class="markdown_content"><p>I have a data conversion problem on 'ON ERROR' clause.<br /> I'd like to skip dirty rows using 'ON DATA CONVERSION ERROR SKIP' clause, but it doesnt work.</p> <p>DDL:<br /> create table MYLOGS<br /> (anonid int, query varchar, querytime datetime format 'yyyy-MM-dd<br /> HH:mm:ss', itemrank int, clickurl varchar )<br /> column sep '\t';</p> <p>Query:<br /> select<br /> year(querytime) as qy, month(querytime) as qm, count(*) as qcnt<br /> from MYLOGS<br /> group by qy, qm ON DATA CONVERSION ERROR SKIP<br /> ;</p> <p>On Reduce, I got an error:<br /> java.io.IOException: Could not convert to date:null<br /> at com.business.cloudbase.hadoop.job.AggFunHandler<br /> $AggFunReducer.reduce(Unknown Source)<br /> at com.business.cloudbase.hadoop.job.AggFunHandler<br /> $AggFunReducer.reduce(Unknown Source)<br /> at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:<br /> 318)<br /> at org.apache.hadoop.mapred.TaskTracker$Child.main<br /> (TaskTracker.java:2198)</p> <p>Thanks,<br /> Youngwoo</p></div>