Re: Hive 0.7.1 authorization woes

what is your unix name on that machine? can u do a whoami? On Thu, Aug 25, 2011 at 5:15 PM, Alex Holmes wrote: > Here's the hive-site.xml file (I use the same file for both the client > and remote metastore).  We're using mysql as the metastore DB. > > > > > > >  hive.security.authorization.e

Re: Hive 0.7.1 authorization woes

Here's the hive-site.xml file (I use the same file for both the client and remote metastore). We're using mysql as the metastore DB. hive.security.authorization.enabled true hive.metastore.local false hive.metastore.uris thrift://localhost:9083 javax.jdo.option.Connection

Re: Hive 0.7.1 authorization woes

Hi, hive> CREATE TABLE pokes2 (foo INT, bar STRING); OK hive> LOAD DATA LOCAL INPATH '/app/hadoop/hive1.in' OVERWRITE INTO TABLE pokes2; OK hive> grant select on table pokes2 to user hduser; OK hive> set hive.security.authorization.enabled=true; hive> show grant user hduser on table pokes2; OK da

Re:Issues Integrating HBASE with HIVE

0 down vote favorite I am able to create tables in HIVE. I have a problem with integrating HIVE and HBASE. I am following this doc. https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration My versions are: Hadoop 0.20.2 Hive 0.7.1 Hbase 0.20.6 hive> CREATE TABLE hbase_table_1(

Re: Understanding distributed Hive server and Hive Metastore setup

Christian, Looks like its not possible to do the setup that you are looking for. Problem arises since HiveServer extends HMSHandler directly instead of accessing Metastore through HiveMetaStoreClient and because of this metastore thrift interface is missed entirely. Hiveserver will contact mysql d

Re: hive-0.7.0 semantic analysis inside catalogs

On Thu, Aug 25, 2011 at 12:11 PM, Ayon Sinha wrote: > You need > select one.a, two.b from one join two on one.a=two.a group by one.a,*two.b > *; > > -Ayon > See My Photos on Flickr > Also check out my Blog for answers to commonly asked > questions.

Re: hive-0.7.0 semantic analysis inside catalogs

You need   select one.a, two.b from one join two on one.a=two.a group by one.a,two.b;   -Ayon See My Photos on Flickr Also check out my Blog for answers to commonly asked questions. From: Edward Capriolo To: user@hive.apache.org Sent: Thursday, August 25, 2011 8

hive-0.7.0 semantic analysis inside catalogs

The parser can not handle certain queries inside catlogs. [11:09:51] hive> create table one (a int,b int) fields terminated by '\t'; [11:09:51] FAILED: Parse Error: line 1:31 mismatched input 'fields' expecting EOF [11:09:51] [11:09:51] hive> create table one (a int,b int) row format delimited

Re: Re:Re: Re: RE: Why a sql only use one map task?

Hi Daniel In the hadoop eco system the number of map tasks is actually decided by the job basically based no of input splits . Setting mapred.map.tasks wouldn't assure that only that many number of map tasks are triggered. What worked out here for you is that you were specifying that a

Re: Problem in hive

Hey Ashu!!1 i have given full permission to hadoop user on new server(A) with user name and password. it can only read those tables made by this server(A) and desc them, and from other server(B) we cant be able to read tables created by this server(A). regards Vikas Srivastava On Thu, Aug 25,

Re:Re:Re: Re: RE: Why a sql only use one map task?

after I set set mapred.min.split.size=2; Then it will kick off 3 map tasks (the file I have is 500M). So looks like we need to set mapred.min.split.size instead of mapred.map.tasks to control how many maps to kick off. At 2011-08-25 19:38:30,"Daniel,Wu" wrote: It works, after I set

Re:Re: Re: RE: Why a sql only use one map task?

It works, after I set as you said, but looks like I can't control the map task, it always use 9 maps, even if I set set mapred.map.tasks=2; Kind% CompleteNum TasksPendingRunningCompleteKilledFailed/Killed Task Attempts map100.00% 900900 / 0 reduce100.00% 100100 / 0 At 2011-08-25 06:35:38,

Re: Problem in hive

hey ashutosh, thanks for reply.. the output of that is *Failed with exception null FAILED: Execution Error, return code 1 from org.apache.hado**op.hive.ql.exec **.DDLTask* regards Vikas Srivastava On Thu, Aug 25, 2011 at 4:52 AM, Ashutosh Chauhan wrote: > Vikas, > Looks like your metadata i