Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0

Hi Francis, I don’t know if you’ve tried it by there are two other python modules: drillpy and pydrill which use Drill’s RESTFul interface and I’ve found them to work a lot better. — C > On Mar 20, 2018, at 17:16, Francis McGregor-Macdonald > wrote: > > Hi Kunal, > > I

Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0

Hi Kunal, I did find: https://github.com/baztian/jaydebeapi/commit/a1f8d3c3b4621570065d968b4b734bae3f0eaf79 which suggests that this may be already being worked on. I'm not sure if it would cover this use case though. I posted a question on the commit which hopefully gets an answer. On Tue,

Re: Drill and orc file support

Drill can read ORC format files via the Hive plugin. If you have a Hive table with underlying data stored as ORC, try and configure the Hive storage plugin in Drill [1]. And then you can attempt to query the table in Hive from Drill [2]. [1] http://drill.apache.org/docs/hive-storage-plugin/ [2]

Fwd: Drill and orc file support

Hello! Please, help me Does drill can read from orc format files ( orc.apache.org ) ?

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: How to get data from mongo database into saiku using apache drill

I see that you have previously asked this question and folks have responded - but you haven't responded back. I'm not sure if you are getting emails sent to the list. If you are and missed those, perhaps check Spam? Also, I'd request you to not start duplicate threads for the same issue. On Tue,

Re: How to get data from mongo database into saiku using apache drill

Is the issue specific to Mongo datasource (can you access regular files through the tool)? Do you see any errors in the drillbit.log when you attempt to access the mongo table? On Mon, Mar 19, 2018 at 5:27 PM, Sonu Kumawat wrote: > Hi, > >I am trying to get

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

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

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 know if i have missed anything. Hive Plugin :- {  "type": "hive",  "enabled": true,  "configProps": {"hive.metastore.uris":

Re: Channel closed exception

My big data cluster is being migrated from one cloud subscription to another one which is more secure. since then the issue "ChannelClosedException" happening however there is no change in machine configurations. I have same job/scripts loops multiple times,for one loop the job

Re: [Drill 1.9.0] : [CONNECTION ERROR] :- (user client) closed unexpectedly. Drillbit down?

Thanks.. will upgrade to 1.13.0 and let you know. On Tue, Mar 20, 2018 11:08 AM, Parth Chandra par...@apache.org wrote: Hi Anup, I don't have full context for the proposed hack, and it might have worked, but looks like Vlad has addressed the issue in the right place. Perhaps you