Re: Error - loading data into tables

[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

[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