Re: Need error logging advice on batch processing

[neelima g]

Brotanek,

*hive -f file.txt hiveconf hive.cli.errors.ignore=true 2&> file.log*

*and then grep for keywords *Exception**


Have you ever tried capturing what all hive queries failed i.e entire
query.I am looking for line number of query in file or queries failed?


Errors are in the format like :

* FAILED: SemanticException [Error 10072]: Database does not exist: x*

Please suggest if anyone know solution.


Neelima


On Mon, Nov 28, 2016 at 7:59 AM, Brotanek, Jan <jan.brota...@adastragrp.com>
wrote:

> Hello,
>
>
>
> you can log like this:
>
>
>
> hive -f file.txt hiveconf hive.cli.errors.ignore=true 2&> file.log
>
> and then grep for keywords **Exception**
>
>
>
>
>
> *From:* neelima g [mailto:nling...@gmail.com]
> *Sent:* pondělí 28. listopadu 2016 16:15
> *To:* user@hive.apache.org
> *Subject:* Need error logging advice on batch processing
>
>
>
> Hi,
>
>
>
> I want to run batch mode task like and i am using *hiveconf
> hive.cli.errors.ignore=true*
>
>
>
> hive -f file.txt hiveconf hive.cli.errors.ignore=true
>
>
>
> And my requirement is find what all queries failed after execution. Is
> that possible ? And i have create statements in the queries..it is DDL.
>
>
>

Need error logging advice on batch processing

[neelima g]

Hi,

I want to run batch mode task like and i am using *hiveconf
hive.cli.errors.ignore=true*

hive -f file.txt hiveconf hive.cli.errors.ignore=true

And my requirement is find what all queries failed after execution. Is that
possible ? And i have create statements in the queries..it is DDL.

Re: Need advice on tracing errors with batch mode

[neelima g]

Hi,

I want to run batch mode task like and i am using *hiveconf
hive.cli.errors.ignore=true*

hive -f file.txt hiveconf hive.cli.errors.ignore=true


And my requirement is find what all queries failed after execution. Is that
possible ? And i have create statements in the queries..it is DDL.

Neelima

On Wed, Nov 23, 2016 at 3:17 PM, neelima g <nling...@gmail.com> wrote:

> Hi,
>
> I want to run batch mode task like and i am using *hiveconf
> hive.cli.errors.ignore=true*
>
>
> hive -f file.txt hiveconf hive.cli.errors.ignore=true
>
>
>
> And my requirement is find what all queries failed after execution. Is
> that possible ?
>
> Neelima
>

Need advice on tracing errors with batch mode

[neelima g]

Hi,

I want to run batch mode task like and i am using *hiveconf
hive.cli.errors.ignore=true*


hive -f file.txt hiveconf hive.cli.errors.ignore=true



And my requirement is find what all queries failed after execution. Is that
possible ?

Neelima