Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

Please find JIRA Link :- https://issues.apache.org/jira/browse/DRILL-6293 On Sat, Mar 24, 2018 7:01 PM, Vitalii Diravka vitalii.dira...@gmail.com wrote: Hi Anup. The API of Hive2.3 is changed, but not documented fully yet. So the difference should be found and resolved in Drill.

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

Hi Anup. The API of Hive2.3 is changed, but not documented fully yet. So the difference should be found and resolved in Drill. Please go ahead and create Jira [1] with description of your environment, settings, CTAS and query, which doesn't work. Thanks [1]

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

I have not upgraded hive version but installed hive 2.3.2 on a server and tried to read data and its working.Can we have any workaround to run drill 1.13 with hive 2.1 or up-gradation is the only option? On Sat, Mar 24, 2018 3:52 PM, Anup Tiwari anup.tiw...@games24x7.com wrote: Sorry for

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

Sorry for delayed response as i didn't got time to test this. @Vitalii, I have tried setting hive.metastore.client.capability.check=false in both ways which are :- 1.  "hive.metastore.uris":

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

@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

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

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

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

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

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

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,

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

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 wrote: > Hi, > Please find my reply :- > Can you do a 'use hive;`

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

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

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

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

Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req'

Note : Using Show databases, i can see hive schemas. On Tue, Mar 20, 2018 2:36 PM, Anup Tiwari anup.tiw...@games24x7.com wrote: Hi, I am not able to read my hive tables in drill 1.13.0 and with same plugin conf it was working in Drill 1.12.0 and 1.10.0. Please look into it asap and let me