Re: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Aviral Agarwal
he exception. >>> >>> >>> >>> *From:* Aviral Agarwal [mailto:aviral12...@gmail.com] >>> *Sent:* Wednesday, June 21, 2017 2:37 PM >>> *To:* user@spark.apache.org >>> *Subject:* JDBC RDD Timestamp Parsing Issue >>> >>> >

Re: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Eduardo Mello
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] >> *Sent:* Wednesday, June 21, 2017 2:37 PM >> *To:* user@spark.apac

RE: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Aviral Agarwal
* 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.SQLEx

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.Times

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. Any