Milan, Unfortunately no, without code changes the Hive processors are not compatible with Hive 1.1.x. There were API changes both to the Java code and the Thrift code (the latter adds the client_protocol field you mentioned), so you can't change the version of the Hive dependencies and get the NAR to compile. You'd have to make the code changes yourself and build with the appropriate version of Hive. There are some vendor-specific profiles (hortonworks, cloudera, mapr) that you can use when specifying vendor-specific Hive versions.
Regards, Matt On Mon, Mar 5, 2018 at 12:29 PM, Milan Das <[email protected]> wrote: > Hello NIFI Dev, > > I am trying to use SelectHiveQL with Hive version hive-1.1.0 (it is part > of the Cloudera 5.13.1) > > https://www.cloudera.com/documentation/enterprise/ > release-notes/topics/cdh_vd_cdh_package_tarball_513.html#tarball_5131 > > > > Seems like because SelectHiveQL uses hive-1.2.1 client library I am > getting following error. My NIFI version is 1.4.0 > > > > Caused by: java.sql.SQLException: Could not establish connection to > jdbc:hive2://ip-NNN-NN-N-NNN.ec2.internal:10000/default; > principal=hive/[email protected]: Required field 'client_protocol' is > unset! Struct:TOpenSessionReq(client_protocol:null, > configuration:{use:database=default}) > > at org.apache.hive.jdbc.HiveConnection.openSession( > HiveConnection.java:594) > > at org.apache.hive.jdbc.HiveConnection.<init>( > HiveConnection.java:192) > > > > hive.version-> pom.xml > > https://github.com/apache/nifi/blob/rel/nifi-1.4.0/pom.xml#L105 > > > > > > > > Wondering if there is a way for backward compatibility. > > > > Regards, > > > > [image: graph] > > *Milan Das* > Sr. System Architect > > email: [email protected] > mobile: +1 678 216 5660 > > [image: dIn icon] <https://www.linkedin.com/in/milandas/> > > www.interset.com > > > > > > > > >
