Re: Dealing with duplicate rows in Hive

So you have 50 columns and out of them you want to use 9 columns for finding unique rows? am i correct in assuming that you want to make a key of combination of these 9 columns so that you have just one row for a single combination of these 9 columns ? On Wed, Oct 2, 2013 at 6:07 AM, Philo Wang

Re: Running Hive JDBC Server1 and Server2 Concurrently

Thanks Mikhail! That answers my question~ On Tue, Oct 1, 2013 at 5:55 PM, Mikhail Antonov wrote: > I don't know what distribution are you using, but this might be helpful: > > > http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/CDH4-Installation-Guide/cdh4ig_topic_18_5.ht

Re: Running Hive JDBC Server1 and Server2 Concurrently

I don't know what distribution are you using, but this might be helpful: http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/CDH4-Installation-Guide/cdh4ig_topic_18_5.html -Mikhail Antonov 2013/10/1 Xiu Guo > Hi, > > I understand in Hive 0.11 the default JDBC server is

Running Hive JDBC Server1 and Server2 Concurrently

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

Dealing with duplicate rows in Hive

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 expec

HCatalog in Hive 0.11

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 $

Re: Doing FSCK throws error

total speculation here given there isn't much to go one. basically all we have here is an issue thrown by "DDLtask" - that's typically a method that is responsible for interrogating the meta store. So first thing is does the table exist? do a show tables. On Mon, Sep 30, 2013 at 10:10 AM, wro

Re: Looking for help related to HUE

Any error stack? exception ? On Tue, Oct 1, 2013 at 3:23 PM, wrote: > 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 f

Looking for help related to HUE

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 have

RE: Error - loading data into tables

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 h

Re: Error - loading data into tables

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 wrote: > Hi Pawar, > > I tried that option b

RE: Error - loading data into tables

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