Re: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Aviral Agarwal
but you could surround the >>> parsing code with a try catch and then just ignore the exception. >>> >>> >>> >>> *From:* Aviral Agarwal [mailto:aviral12...@gmail.com] >>> *Sent:* Wednesday, June 21, 2017 2:37 PM >&

Re: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Eduardo Mello
from the >> resultset ( I guess). >> >> If you can provide more code it will help, but you could surround the >> parsing code with a try catch and then just ignore the exception. >> >> >> >> *From:* Aviral Agarwal [mailto:aviral12...@gmail.com] >&

RE: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Aviral Agarwal
rwal [mailto:aviral12...@gmail.com] > *Sent:* Wednesday, June 21, 2017 2:37 PM > *To:* user@spark.apache.org > *Subject:* JDBC RDD Timestamp Parsing Issue > > > > Hi, > > > > I am using JDBC RDD to read from a MySQL RDBMS. > > My spark job fails with th

RE: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Mahesh Sawaiker
: Wednesday, June 21, 2017 2:37 PM To: user@spark.apache.org Subject: JDBC RDD Timestamp Parsing Issue Hi, I am using JDBC RDD to read from a MySQL RDBMS. My spark job fails with the below error : java.sql.SQLException: Value '-00-00 00:00:00.000' can not be represented as java.sql.Timestamp Now

JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Aviral Agarwal
Hi, I am using JDBC RDD to read from a MySQL RDBMS. My spark job fails with the below error : java.sql.SQLException: Value '-00-00 00:00:00.000' can not be represented as java.sql.Timestamp Now instead of the whole job failing I want to skip this record and continue processing the rest.