java - ERROR jdbc.HiveConnection: Error opening session Hive -


i try run jbdc code hive2 error. have hive 1.2.0 version hadoop 1.2.1 version. in command line hive , beeline works fine without problem.but jdbc getting error.

import java.sql.sqlexception; import java.sql.connection; import java.sql.resultset; import java.sql.statement; import java.sql.drivermanager;  public class hivejdbcclient {   private static string drivername = "org.apache.hive.jdbc.hivedriver";    /**    * @param args    * @throws sqlexception    */   public static void main(string[] args) throws sqlexception { //basicconfigurator.configure();    try {       class.forname(drivername);     } catch (classnotfoundexception e) {       // todo auto-generated catch block       e.printstacktrace();     }     //replace "hive" here name of user queries should run     connection con = drivermanager.getconnection("jdbc:hive2://localhost:10000/default","", "");     statement stmt = con.createstatement();     string tablename = "cdr";    stmt.execute("drop table if exists " + tablename); // show tables     string sql = "show tables '" + tablename + "'";     system.out.println("running: " + sql);     resultset res = stmt.executequery(sql);     if (res.next()) {       system.out.println(res.getstring(1));     }    } }

i error while run code.

15/06/19 12:08:53 info jdbc.hiveconnection: try open client transport jdbc uri: jdbc:hive2://localhost:10000/default 15/06/19 12:08:53 error jdbc.hiveconnection: error opening session org.apache.thrift.tapplicationexception: required field 'client_protocol' unset! struct:topensessionreq(client_protocol:null, configuration:{use:database=default})         @ org.apache.thrift.tapplicationexception.read(tapplicationexception.java:111)         @ org.apache.thrift.tserviceclient.receivebase(tserviceclient.java:71)         @ org.apache.hive.service.cli.thrift.tcliservice$client.recv_opensession(tcliservice.java:156)         @ org.apache.hive.service.cli.thrift.tcliservice$client.opensession(tcliservice.java:143)         @ org.apache.hive.jdbc.hiveconnection.opensession(hiveconnection.java:578)         @ org.apache.hive.jdbc.hiveconnection.<init>(hiveconnection.java:192)         @ org.apache.hive.jdbc.hivedriver.connect(hivedriver.java:105)         @ java.sql.drivermanager.getconnection(drivermanager.java:571)         @ java.sql.drivermanager.getconnection(drivermanager.java:215)         @ hivejdbcclient.main(hivejdbcclient.java:24) exception in thread "main" java.sql.sqlexception: not establish connection jdbc:hive2://localhost:10000/default: required field 'client_protocol' unset! struct:topensessionreq(client_protocol:null, configuration:{use:database=default})         @ org.apache.hive.jdbc.hiveconnection.opensession(hiveconnection.java:589)         @ org.apache.hive.jdbc.hiveconnection.<init>(hiveconnection.java:192)         @ org.apache.hive.jdbc.hivedriver.connect(hivedriver.java:105)         @ java.sql.drivermanager.getconnection(drivermanager.java:571)         @ java.sql.drivermanager.getconnection(drivermanager.java:215)         @ hivejdbcclient.main(hivejdbcclient.java:24) caused by: org.apache.thrift.tapplicationexception: required field 'client_protocol' unset! struct:topensessionreq(client_protocol:null, configuration:{use:database=default})

any solution ?

org.apache.thrift.tapplicationexception: required field 'client_protocol' unset! struct:topensessionreq(client_protocol:null, configuration:{use:database=default}) @ org.apache.thrift.tapplicationexception.read(tapplicationexception.java:111)

this error occurs if have version mismatch between hive , hive-jdbc. please check if both versions match.

please refer this more information.


Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more