Re: Table present in HDFS but 'show table' Returns Empty

2013-04-23 Thread Ramki Palle
May be you are using derby as your metastore. It creates the metastore in the current directory from where you started your hive session. You may have started your hive session from a different directory next time. Please use either mysql as your metastore or set a definite directory in your

Re: Exception comes out when counting the rows

2013-04-23 Thread Ramki Palle
Normally, you do not use load data when you use external table. You either specify location in the create external table query or use alter table tablename set location syntax to set the location of the files that the external table stores the data. In this case, try describe extended

Re: Exception comes out when counting the rows

2013-04-23 Thread YouPeng Yang
Hi All I notice that there are lots of fimilar issues ,however there is no perfect responses to these issues. I post this mail to close the case because I happen to get the reason . Hope to be helpfull. The exception is due to the configuration variable mapred.job.tracker =

Re: What's the URL of Hive IRC Channel

2013-04-23 Thread Carl Steinbach
I think you probably want this: https://webchat.freenode.net/ Thanks. Carl On Mon, Apr 22, 2013 at 10:23 PM, YouPeng Yang yypvsxf19870...@gmail.comwrote: Hi Does anyone know the exact URL of the Hive IRC Channel. I try http://irc.freenode.net/#hive,and it does not works. Regards

Re: What's the URL of Hive IRC Channel

2013-04-23 Thread Scott Preece
I set up an account on irc.freenode.net in Adium and then joined the group chat #hive, and that seemed to work (at least there are a bunch of people in the room). scott From: Carl Steinbach cwsteinb...@gmail.commailto:cwsteinb...@gmail.com Reply-To:

Re: What's the URL of Hive IRC Channel

2013-04-23 Thread yypvsxf19870706
Hi Thanks a lot. I see. Regards 发自我的 iPhone 在 2013-4-24,2:56,Scott Preece pre...@yahoo-inc.com 写道: I set up an account on irc.freenode.net in Adium and then joined the group chat #hive, and that seemed to work (at least there are a bunch of people in the room). scott From:

Re: Using Python thrift client for Hive Server 2 hangs.

2013-04-23 Thread Prasad Mujumdar
HiveServer2 by default uses ThriftSASL transport. The Thrift python library doesn't have the SASL transport. You can run the hiveserver2 in non-sasl mode by adding following to the hive-site.xml property namehive.server2.authentication/name valueNOSASL/value /property Also Hive 0.10