Dear All,

In one of the PoCs, I have to export results generated in a Pig script to
mysql. For this I am using DBStorage. While there are no errors during the
execution and output logs shows the exact number of records written but
when i check in DB nothing is written into it. On debugging, I understood
the Prepared Statement is becoming NULL in CommitTask method.

Please suggest on how this can be resolved or any help in proceeding
further would be of great help.

thanks and regards,
Vijaya Bhaskar Peddinti

Can you provide script, sample data and logs. That may help to proceed with
debugging.

Ashutosh
On Fri, Nov 18, 2011 at 07:26, vijaya bhaskar peddinti <
[EMAIL PROTECTED]> wrote:

> Dear All,
>
> In one of the PoCs, I have to export results generated in a Pig script to
> mysql. For this I am using DBStorage. While there are no errors during the
> execution and output logs shows the exact number of records written but
> when i check in DB nothing is written into it. On debugging, I understood
> the Prepared Statement is becoming NULL in CommitTask method.
>
> Please suggest on how this can be resolved or any help in proceeding
> further would be of great help.
>
> thanks and regards,
> Vijaya Bhaskar Peddinti
>

Hi Ashutosh,

Please find attached pig query code, sample input and output. Input is lzo
compressed and is loaded using LzoProtoBufPigLoaders (elephantbird) .
I am using pig-0.8.0.jar.

thanks and regards,
Vijaya Bhaskar Peddinti

On Fri, Nov 18, 2011 at 10:28 PM, Ashutosh Chauhan <[EMAIL PROTECTED]>wrote:

> Can you provide script, sample data and logs. That may help to proceed with
> debugging.
>
> Ashutosh
> On Fri, Nov 18, 2011 at 07:26, vijaya bhaskar peddinti <
> [EMAIL PROTECTED]> wrote:
>
> > Dear All,
> >
> > In one of the PoCs, I have to export results generated in a Pig script to
> > mysql. For this I am using DBStorage. While there are no errors during
> the
> > execution and output logs shows the exact number of records written but
> > when i check in DB nothing is written into it. On debugging, I understood
> > the Prepared Statement is becoming NULL in CommitTask method.
> >
> > Please suggest on how this can be resolved or any help in proceeding
> > further would be of great help.
> >
> > thanks and regards,
> > Vijaya Bhaskar Peddinti
> >
>