Re: beeline remote client not connecting to hiveserver2

Does this work? jdbc:hive2://hiveservice:11000/default?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice Are you certain that HiveServer2 daemon is running on hiveservice AND listening on port 11000? On 3 July 2014 13:12, Hang Chan wrote: > hive.server.read.socket.tim

Re: beeline remote client not connecting to hiveserver2

hive.server.read.socket.timeout=10 hive.server.tcp.keepalive=true hive.server2.async.exec.shutdown.timeout=10 hive.server2.async.exec.threads=50 hive.server2.authentication=NONE hive.server2.enable.doAs=true hive.server2.table.type.mapping=CLASSIC hive.server2.thrift.http.max.worker.threads=500 hiv

Re: beeline remote client not connecting to hiveserver2

Did you explicitly change the HiveServer2 port to 11000? The default is 1. Can you provide the output of the following ? hive -e set | grep hive.server On 3 July 2014 11:08, Hang Chan wrote: > It's not a dns problem. I just substituted my real server name with > "hiveservice". I confir

Re: beeline remote client not connecting to hiveserver2

It's not a dns problem. I just substituted my real server name with "hiveservice". I confirmed that the hostname is indeed resolvable in dns. I also tried using the ip address in place of the hostname and I still get the same error. On Wed, Jul 2, 2014 at 5:36 PM, Andre Araujo wrote: > If th

Re: beeline remote client not connecting to hiveserver2

If the name "hiveserver" is not resolved correctly, that's the exact error you'd getting. Does "nslookup hiveservice" resolve the name successfully? Try using the fully qualified name instead. On 3 July 2014 07:01, Szehon Ho wrote: > I believe you should be able to put in anything by default.

Re: beeline remote client not connecting to hiveserver2

I believe you should be able to put in anything by default. The hive jdbc url is of the form jdbc:hive2://:, is the url correct? Thanks, Szehon On Wed, Jul 2, 2014 at 10:16 AM, Hang Chan wrote: > beeline does not seem to be connecting remotely. It works if I connect > using the embedded clie

Re: beeline remote client not connecting to hiveserver2

Is the name "hiveservice" being resolved successfully? If there's a problem with the name resolution, that's the exact message you'd get. Does "nslookup hiveservice" resolve the name? Try using the fully qualified name instead. On 3 July 2014 03:16, Hang Chan wrote: > beeline does not seem to

Retrieving hbase column names

Hi! I have an HCatalog table mapped to an HBase table. Is there a way that I can retrieve the HBase column names from the schema? Carlotta Hicks

beeline remote client not connecting to hiveserver2

beeline does not seem to be connecting remotely. It works if I connect using the embedded client. I am using all the default configurations, except I configured my hiveserver2 thrift port to 11000. If I put in the database name after the port number, it will prompt me for a username and password

Re: Hivemetastore Error: Duplicate entry

Seems that you are inserting duplicate record into that global table. Can you show the query ??? On Jun 26, 2014 8:19 AM, "张伟" wrote: > I run hive-0.13.1 on hadoop-2.2.0. When I insert into an orc table, then i > get the following ERROR, indicating that Hive is trying to insert duplicate > entry

Re: Error in create table

Seems that you have created wrong table structure in hive metastore. Which hive are you using ?? you need to check which schema is required for your Hadoop version . On Jun 26, 2014 4:37 PM, "Rishabh Bhardwaj" wrote: > Hi all, > I have set mysql as my metastore but when I try to create a table

RE: ERROR 1115: Unsupported type: 5 in Pig's schema

Yes. Here is a row of data: cust_1,M,56,D,Hopatcong,NJ,7843,15-May-74,15-May-77,88.00,43,688.00,458.00,N From: hadoop hive [mailto:hadooph...@gmail.com] Sent: Wednesday, July 02, 2014 12:51 AM To: user@hive.apache.org Subject: Re: ERROR 1115: Unsupported type: 5 in Pig's schema Did you checked

Re: Need urgent help

set dfs.permissions property as false and try once. On Wed, Jul 2, 2014 at 12:42 PM, wrote: > Yes. > > > Sent from Samsung Mobile > > > Original message > From: Andre Araujo > Date:02/07/2014 00:10 (GMT-08:00) > To: user > Subject: Re: Need urgent help > > Did you manage to

Re: Skewed vs ListBucketing

Well, it turns out I dropped the ball on improving the list bucketing docs back in April. See the message thread "Skewed Tables" that Mayur Gupta started on April 21 and Pras

Re: Need urgent help

Yes. Sent from Samsung Mobile Original message From: Andre Araujo Date:02/07/2014 00:10 (GMT-08:00) To: user Subject: Re: Need urgent help Did you manage to load the jar from the local file? On 2 July 2014 16:57, mailto:shouvanik.hal...@accenture.com>> wrote: This copy was

Re: Need urgent help

Did you manage to load the jar from the local file? On 2 July 2014 16:57, wrote: > This copy was successful. The file was not corrupted > > > Sent from Samsung Mobile > > > Original message > From: Andre Araujo > Date:01/07/2014 23:45 (GMT-08:00) > To: user > Subject: Re: Ne