You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Manickam P <ma...@outlook.com> on 2013/09/30 15:43:08 UTC
Error - loading data into tables
Hi,
I'm getting the below error while loading the data into hive table. return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
I used " LOAD DATA INPATH '/home/storage/mount1/tabled.txt' INTO TABLE TEST;" this query to insert into table.
Thanks,
Manickam P
RE: Error - loading data into tables
Posted by Manickam P <ma...@outlook.com>.
Thanks Pawar.
Thanks,Manickam P
Date: Tue, 1 Oct 2013 13:18:24 +0530
Subject: Re: Error - loading data into tables
From: nitinpawar432@gmail.com
To: manickam.p@outlook.com; dev@hive.apache.org
CC: user@hive.apache.org
Manickam,
I am really not sure if hive supports Federated namespaces yet. I have cc'd dev list.
May be any of the core hive developers will be able to tell how to load data using hive on a federated hdfs.
On Tue, Oct 1, 2013 at 12:59 PM, Manickam P <ma...@outlook.com> wrote:
Hi Pawar,
I tried that option but not working. I have a federated HDFS cluster and given below is my core site xml.
I created the HDFS directory inside that /home/storage/mount1 and tried to load the file now also i'm getting the same error.
Can you pls tell me what mistake i'm doing here? bcoz i dont have any clue.
<configuration>
<property> <name>fs.default.name</name>
<value>viewfs:///</value> </property> <property>
<name>fs.viewfs.mounttable.default.link./home/storage/mount1</name> <value>hdfs://10.108.99.68:8020</value>
</property> <property> <name>fs.viewfs.mounttable.default.link./home/storage/mount2</name>
<value>hdfs://10.108.99.69:8020</value> </property>
</configuration>
Thanks,
Manickam Ppa
Date: Mon, 30 Sep 2013 21:53:03 +0530
Subject: Re: Error - loading data into tables
From: nitinpawar432@gmail.com
To: user@hive.apache.org
Is this /home/strorage/... a hdfs directory? I think its a normal filesystem directory.
Try running this load data local inpath '/home/storage/mount1/tabled.txt' INTO TABLE TEST;"
On Mon, Sep 30, 2013 at 7:13 PM, Manickam P <ma...@outlook.com> wrote:
Hi,
I'm getting the below error while loading the data into hive table. return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
I used " LOAD DATA INPATH '/home/storage/mount1/tabled.txt' INTO TABLE TEST;" this query to insert into table.
Thanks,
Manickam P
--
Nitin Pawar
--
Nitin Pawar
Re: Error - loading data into tables
Posted by Nitin Pawar <ni...@gmail.com>.
Manickam,
I am really not sure if hive supports Federated namespaces yet.
I have cc'd dev list.
May be any of the core hive developers will be able to tell how to load
data using hive on a federated hdfs.
On Tue, Oct 1, 2013 at 12:59 PM, Manickam P <ma...@outlook.com> wrote:
> Hi Pawar,
>
> I tried that option but not working. I have a federated HDFS cluster and
> given below is my core site xml.
>
> I created the HDFS directory inside that /home/storage/mount1 and tried to
> load the file now also i'm getting the same error.
>
> Can you pls tell me what mistake i'm doing here? bcoz i dont have any clue.
>
>
> *<configuration>*
> * *
> * <property>*
> * <name>fs.default.name</name>*
> * <value>viewfs:///</value>*
> * </property>*
> * <property>*
> * <name>fs.viewfs.mounttable.default.link./home/storage/mount1</name>*
> * <value>hdfs://10.108.99.68:8020</value>*
> * </property>*
> * <property>*
> * <name>fs.viewfs.mounttable.default.link./home/storage/mount2</name>*
> * <value>hdfs://10.108.99.69:8020</value>*
> * </property> *
> *</configuration>*
>
>
> Thanks,
> Manickam Ppa
>
> ------------------------------
> Date: Mon, 30 Sep 2013 21:53:03 +0530
> Subject: Re: Error - loading data into tables
> From: nitinpawar432@gmail.com
> To: user@hive.apache.org
>
>
> Is this /home/strorage/... a hdfs directory?
> I think its a normal filesystem directory.
>
> Try running this
> load data local inpath '*/home/storage/mount1/tabled.txt' INTO TABLE TEST;
> *"
>
>
> On Mon, Sep 30, 2013 at 7:13 PM, Manickam P <ma...@outlook.com>wrote:
>
> Hi,
>
> I'm getting the below error while loading the data into hive table.
> *return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask*
> *
> *
> I used "* LOAD DATA INPATH '/home/storage/mount1/tabled.txt' INTO TABLE
> TEST;*" this query to insert into table.
>
>
> Thanks,
> Manickam P
>
>
>
>
> --
> Nitin Pawar
>
--
Nitin Pawar
Re: Error - loading data into tables
Posted by Nitin Pawar <ni...@gmail.com>.
Manickam,
I am really not sure if hive supports Federated namespaces yet.
I have cc'd dev list.
May be any of the core hive developers will be able to tell how to load
data using hive on a federated hdfs.
On Tue, Oct 1, 2013 at 12:59 PM, Manickam P <ma...@outlook.com> wrote:
> Hi Pawar,
>
> I tried that option but not working. I have a federated HDFS cluster and
> given below is my core site xml.
>
> I created the HDFS directory inside that /home/storage/mount1 and tried to
> load the file now also i'm getting the same error.
>
> Can you pls tell me what mistake i'm doing here? bcoz i dont have any clue.
>
>
> *<configuration>*
> * *
> * <property>*
> * <name>fs.default.name</name>*
> * <value>viewfs:///</value>*
> * </property>*
> * <property>*
> * <name>fs.viewfs.mounttable.default.link./home/storage/mount1</name>*
> * <value>hdfs://10.108.99.68:8020</value>*
> * </property>*
> * <property>*
> * <name>fs.viewfs.mounttable.default.link./home/storage/mount2</name>*
> * <value>hdfs://10.108.99.69:8020</value>*
> * </property> *
> *</configuration>*
>
>
> Thanks,
> Manickam Ppa
>
> ------------------------------
> Date: Mon, 30 Sep 2013 21:53:03 +0530
> Subject: Re: Error - loading data into tables
> From: nitinpawar432@gmail.com
> To: user@hive.apache.org
>
>
> Is this /home/strorage/... a hdfs directory?
> I think its a normal filesystem directory.
>
> Try running this
> load data local inpath '*/home/storage/mount1/tabled.txt' INTO TABLE TEST;
> *"
>
>
> On Mon, Sep 30, 2013 at 7:13 PM, Manickam P <ma...@outlook.com>wrote:
>
> Hi,
>
> I'm getting the below error while loading the data into hive table.
> *return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask*
> *
> *
> I used "* LOAD DATA INPATH '/home/storage/mount1/tabled.txt' INTO TABLE
> TEST;*" this query to insert into table.
>
>
> Thanks,
> Manickam P
>
>
>
>
> --
> Nitin Pawar
>
--
Nitin Pawar
RE: Error - loading data into tables
Posted by Manickam P <ma...@outlook.com>.
Hi Pawar,
I tried that option but not working. I have a federated HDFS cluster and given below is my core site xml.
I created the HDFS directory inside that /home/storage/mount1 and tried to load the file now also i'm getting the same error.
Can you pls tell me what mistake i'm doing here? bcoz i dont have any clue.
<configuration> <property> <name>fs.default.name</name> <value>viewfs:///</value> </property> <property> <name>fs.viewfs.mounttable.default.link./home/storage/mount1</name> <value>hdfs://10.108.99.68:8020</value> </property> <property> <name>fs.viewfs.mounttable.default.link./home/storage/mount2</name> <value>hdfs://10.108.99.69:8020</value> </property> </configuration>
Thanks,
Manickam Ppa
Date: Mon, 30 Sep 2013 21:53:03 +0530
Subject: Re: Error - loading data into tables
From: nitinpawar432@gmail.com
To: user@hive.apache.org
Is this /home/strorage/... a hdfs directory? I think its a normal filesystem directory.
Try running this load data local inpath '/home/storage/mount1/tabled.txt' INTO TABLE TEST;"
On Mon, Sep 30, 2013 at 7:13 PM, Manickam P <ma...@outlook.com> wrote:
Hi,
I'm getting the below error while loading the data into hive table. return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
I used " LOAD DATA INPATH '/home/storage/mount1/tabled.txt' INTO TABLE TEST;" this query to insert into table.
Thanks,
Manickam P
--
Nitin Pawar
Re: Error - loading data into tables
Posted by Nitin Pawar <ni...@gmail.com>.
Is this /home/strorage/... a hdfs directory?
I think its a normal filesystem directory.
Try running this
load data local inpath '*/home/storage/mount1/tabled.txt' INTO TABLE TEST;*"
On Mon, Sep 30, 2013 at 7:13 PM, Manickam P <ma...@outlook.com> wrote:
> Hi,
>
> I'm getting the below error while loading the data into hive table.
> *return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask*
> *
> *
> I used "* LOAD DATA INPATH '/home/storage/mount1/tabled.txt' INTO TABLE
> TEST;*" this query to insert into table.
>
>
> Thanks,
> Manickam P
>
--
Nitin Pawar