You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Abhishek Parolkar <ab...@viki.com> on 2012/02/20 06:29:09 UTC

Re: Hive CLI (v0.8.1) -f option returns if even if just single query fails

Hi,
  I have a big list of data to be loaded into hive and I create a .hql file
with all load statements.

Problem number 1.)  This fails with exception in copy files

Failed with exception copyFiles: error while checking/creating destination
directory!!!
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.MoveTask
Here is what hive.log says (http://pastie.org/private/nxsvlhbunirhtcwscovzug
)


Problem number 2.) even if one among all queries fail it should still go
ahead and execute further queries, is there a way to not exit if the one of
the statement in HQL file has failed?

Is there any other way I could bulk load the data into hive table?

-v_abhi_v

Re: Hive CLI (v0.8.1) -f option returns if even if just single query fails

Posted by Edward Capriolo <ed...@gmail.com>.

Are you sure that /user/hive/warehouse exists and you have the proper
authority to write data to it?

On Mon, Feb 20, 2012 at 12:29 AM, Abhishek Parolkar <ab...@viki.com> wrote:
> Hi,
>   I have a big list of data to be loaded into hive and I create a .hql file
> with all load statements.
>
> Problem number 1.)  This fails with exception in copy files
>
> Failed with exception copyFiles: error while checking/creating destination
> directory!!!
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.MoveTask
> Here is what hive.log says
> (http://pastie.org/private/nxsvlhbunirhtcwscovzug)
>
>
> Problem number 2.) even if one among all queries fail it should still go
> ahead and execute further queries, is there a way to not exit if the one of
> the statement in HQL file has failed?
>
> Is there any other way I could bulk load the data into hive table?
>
> -v_abhi_v
>
>
>