@Anup, it should. If it isn't back compatible, it is a Hive issue. Hive Trift Metastore API was changed, but still isn't documented in cwiki.apache.org [1] *hive.metastore.client.capability.check *[2] property is true by default. Possibly changing this could help you. You can change it in Drill Hive plugin or in hive-site.xml Looks like, the issue will be the same for using hive-server2 2.3 version and hive-metastore 2.1 version. If so it is a Hive issue.
So you can try to change the property before updating to Hive 2.3 version. [1] https://issues.apache.org/jira/browse/HIVE-15062 [2] https://issues.apache.org/jira/browse/HIVE-15062?focusedCommentId=15659298&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15659298 Kind regards Vitalii On Tue, Mar 20, 2018 at 1:54 PM, Anup Tiwari <anup.tiw...@games24x7.com> wrote: > Please find below information :- > Apache Hadoop 2.7.3Apache Hive 2.1.1 > @Vitalii, For testing i can setup upgrade hive but upgrading hive will > take time > on our production server. Don't you think it should be back compatible? > > > > > On Tue, Mar 20, 2018 4:33 PM, Vitalii Diravka vitalii.dira...@gmail.com > wrote: > Anup, > > > > > "get_table_req" method is present in ThriftHiveMetastore header of Apache > > Hive 2.3 version. > > I believe Hive upgrade will help you. Probably it is Hive's back > > compatibility issue. > > Please let us know, whether upgrade helps. > > > > > Kind regards > > Vitalii > > > > > On Tue, Mar 20, 2018 at 12:56 PM, Vitalii Diravka < > vitalii.dira...@gmail.com > > wrote: >> > > > > > Hi Anup, >> > > >> > Maybe we missed something after updating onto hive-2.3 client versions. >> > > Could you provide the following info: >> > > * What is your hive-server and metastore versions? If it is not 2.3 >> > > version could you update onto this? >> > > * What is your hadoop distribution? >> > > >> > Kind regards >> > > Vitalii >> > > >> > On Tue, Mar 20, 2018 at 12:31 PM, Abhishek Girish <agir...@apache.org> >> > > wrote: >> > > >> > Okay, that confirms that the Hive storage plugin is not configured >>> >> > correctly - you are unable to access any Hive table. What's your Hive >>> >> > server version? >>> >> > >>> > On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <anup.tiw...@games24x7.com> >>> >> > wrote: >>> >> > >>> > > Hi, >>> >> > > Please find my reply :- >>> >> > > Can you do a 'use hive;` followed by 'show tables;' and see if table >>> >> > > 'cad' is listed? : Did and got empty set(No rows selected). >>> >> > > >>> >> > > If you try via hive shell, do you see it? : Yes >>> >> > > >>> >> > > can you check if this is impacting accessing all hive tables (may be >>> >> > > create a new one and try) or if this is specific to a certain table / >>> >> > > database in Hive? : Tried 2 tables but getting same error. I have not >>> >> > tried >>> >> > > creating anew one, will try that and let you know. >>> >> > > >>> >> > > >>> >> > > >>> >> > > >>> >> > > On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agir...@apache.org >>> >> > wrote: >>> >> > > Down in the stack trace it's complaining that the table name 'cad' was >>> >> > not >>> >> > > >>> >> > > found; Can you do a 'use hive;` followed by 'show tables;' and see if >>> >> > table >>> >> > > >>> >> > > 'cad' is listed? >>> >> > > >>> >> > > >>> >> > > >>> >> > > >>> >> > > If you try via hive shell, do you see it? >>> >> > > >>> >> > > >>> >> > > >>> >> > > >>> >> > > Also, can you check if this is impacting accessing all hive tables (may >>> >> > be >>> >> > > >>> >> > > create a new one and try) or if this is specific to a certain table / >>> >> > > >>> >> > > database in Hive? >>> >> > > >>> >> > > >>> >> > > >>> >> > > >>> >> > > -Abhishek >>> >> > > >>> >> > > >>> >> > >>> > >> > >> > > > > > > Regards, > Anup Tiwari