Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Error - loading data into tables


+
Manickam P 2013-09-30, 13:43
+
Nitin Pawar 2013-09-30, 16:23
+
Manickam P 2013-10-01, 07:29
Copy link to this message
-
Re: Error - loading data into tables
Nitin Pawar 2013-10-01, 07:48
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
>
> 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 <[EMAIL PROTECTED]>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
+
Manickam P 2013-10-01, 09:29