Re: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Aviral Agarwal
This woks. Thanks ! - Aviral Agarwal On Wed, Jun 21, 2017 at 6:07 PM, Eduardo Mello wrote: > You can add "?zeroDateTimeBehavior=convertToNull" to the connection > string. > > On Wed, Jun 21, 2017 at 9:04 AM, Aviral Agarwal > wrote: > >> The

Re: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Eduardo Mello
You can add "?zeroDateTimeBehavior=convertToNull" to the connection string. On Wed, Jun 21, 2017 at 9:04 AM, Aviral Agarwal wrote: > The exception is happening in JDBC RDD code where getNext() is called to > get the next row. > I do not have access to the result set. I am

RE: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Aviral Agarwal
The exception is happening in JDBC RDD code where getNext() is called to get the next row. I do not have access to the result set. I am operating on a DataFrame. Thanks and Regards, Aviral Agarwal On Jun 21, 2017 17:19, "Mahesh Sawaiker" wrote: > This has to do

RE: JDBC RDD Timestamp Parsing Issue

2017-06-21 Thread Mahesh Sawaiker
This has to do with how you are creating the timestamp object 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] Sent: