RE: Error - loading data into tables

2013-10-01 Thread Manickam P
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?

Re: Error - loading data into tables

2013-10-01 Thread Nitin Pawar
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 manicka...@outlook.com wrote: Hi Pawar, I

RE: Error - loading data into tables

2013-10-01 Thread Manickam P
Thanks Pawar. Thanks,Manickam P Date: Tue, 1 Oct 2013 13:18:24 +0530 Subject: Re: Error - loading data into tables From: nitinpawar...@gmail.com To: manicka...@outlook.com; d...@hive.apache.org CC: user@hive.apache.org Manickam, I am really not sure if hive supports Federated namespaces yet. I

Looking for help related to HUE

2013-10-01 Thread shouvanik.haldar
Hi Nitin, Can you please help me with HUE issue. I am not able to create table in HUE using HCatalog? Thanks, Shouvanik This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you

HCatalog in Hive 0.11

2013-10-01 Thread Tomás Fernández Pena
Hi I've just downloaded the tarball of hive 0.11. I'm trying to run the hcat_server.sh, put I got an error: $ ./hcat_server.sh start Started metastore server init, testing if initialized correctly... Metastore startup failed, see /home/ec2-user/hive-0.11.0-bin/hcatalog/sbin/../var/log/hcat.err

Dealing with duplicate rows in Hive

2013-10-01 Thread Philo Wang
Hi, I am using Hive 8.1.8 in EMR. We have an extremely large table (~50 columns) where the uniqueness key is a combination of 9 different columns. I want to filter out any duplicate rows based on these 9 columns while retaining the ability to select other columns on an ad hoc basis. I don’t

Running Hive JDBC Server1 and Server2 Concurrently

2013-10-01 Thread Xiu Guo
Hi, I understand in Hive 0.11 the default JDBC server is server2. Is it possible to run the old server1 and new server2 concurrently so it takes different version of client access? If possible, what should be added in hive-site.xml? Thank you! Xiu