alright the problem solved! Now I'm able to connect to the hiveserver. I appreciate your help Navis :)
Ben On Tue, Jul 17, 2012 at 3:34 PM, Navis류승우 <navis....@nexr.com> wrote: > It seemed to be https://issues.apache.org/jira/browse/HIVE-2937 > > HIVE-2397 is expected to be included in hive-0.9 but missed by some > reason. > You can try applying the patch or using hive in trunk. > > 2012/7/17 Ben Kim <benkimkim...@gmail.com> > >> I tested it on 0.8.1 and 0.9.0 >> >> Ben >> >> >> On Tue, Jul 17, 2012 at 3:03 PM, Navis류승우 <navis....@nexr.com> wrote: >> >>> Can I ask the hive version you are currently using? >>> >>> >>> 2012/7/17 Ben Kim <benkimkim...@gmail.com> >>> >>>> Did you get around to solve this problem? >>>> >>>> I running into the same problem and can't find a fix anywhere. >>>> >>>> For Hiveserver you will need to create your own when running the server >>>> such as running "hive --service hiveserver & >> hiveserver.log 2>&1" >>>> but it writes no logs. I think a connection is getting blocked >>>> somewhere outside of the hive server or it could be something else. >>>> >>>> Ben >>>> >>>> On Tue, Jun 26, 2012 at 6:36 AM, VanHuy Pham <huy.pham...@gmail.com>wrote: >>>> >>>>> I just tried, but it still hangs there. I think all the executions run >>>>> into the same problem so I was wondering if I miss anything here. >>>>> 1) Do I need to sart any other services to make hive thrift server >>>>> work? >>>>> 2) I can't seem to find the log information for hive-thrift server. >>>>> There is a folder called "hivelogs" created in my home dir, but I only >>>>> find >>>>> the log information there when I use hive cli through terminal. Is there >>>>> any log dir for hive-thrift server? or any way I can tract the trace of >>>>> the >>>>> thrift client query (execute or getAlltables())?? >>>>> >>>>> Thanks >>>>> >>>>> >>>>> On Mon, Jun 25, 2012 at 2:15 PM, Aniket Mokashi >>>>> <aniket...@gmail.com>wrote: >>>>> >>>>>> Can you do client.getAllTables()? >>>>>> >>>>>> ~Aniket >>>>>> >>>>>> >>>>>> On Mon, Jun 25, 2012 at 12:43 PM, VanHuy Pham >>>>>> <huy.pham...@gmail.com>wrote: >>>>>> >>>>>>> Hi, >>>>>>> I am trying to use the hive thrift client to connect to hive. >>>>>>> Even though I have started the hive thrift server (it's running by >>>>>>> checking >>>>>>> netstat -na | grep 10000). >>>>>>> However, the thrift client justs hangs forever when I execute a >>>>>>> query. here is the code: >>>>>>> >>>>>>> TSocket transport = new TSocket(hiveServer, >>>>>>> hivePort); >>>>>>> >>>>>>> transport.setTimeout(999999); >>>>>>> >>>>>>> TBinaryProtocol protocol = new >>>>>>> TBinaryProtocol(transport); >>>>>>> >>>>>>> client = new ThriftHive.Client(protocol); >>>>>>> >>>>>>> transport.open(); >>>>>>> >>>>>>> System.out.println(transport.isOpen()); ///// >>>>>>> It is open >>>>>>> >>>>>>> >>>>>>> System.out.println("Executing query"); >>>>>>> client.execute("show tables"); // >>> hanging >>>>>>> forever >>>>>>> >>>>>>> The thrift server is definitely on, because if I tried shutting it >>>>>>> down, the hanging would stop immediately and say something like >>>>>>> "connection >>>>>>> interupted...". I was able to use JDBC to connect to hive locally only. >>>>>>> Trying to use thrift client now. >>>>>>> Any help would be much appreciated. >>>>>>> Thanks >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> "...:::Aniket:::... Quetzalco@tl" >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> >>>> *Benjamin Kim* >>>> *benkimkimben at gmail* >>>> >>>> >>> >> >> >> -- >> >> *Benjamin Kim* >> *benkimkimben at gmail* >> >> > -- *Benjamin Kim* *benkimkimben at gmail*
