RE: WELCOME to user@drill.apache.org

2019-05-24 Thread Ahmad, Sami
icationException Invalid method name: 'get_tables_by_type') at org.apache.drill.exec.store.hive.client.HiveMetadataCache.getTableNamesAndTypes(HiveMetadataCache.java:116) ~[drill-storage-hive-core-1.16.0.jar:1.16.0] at org.apache.drill.exec.store.hive.client.DrillHiveMetaStoreClient.getTableNamesAndTypes(DrillHiveMetaStoreClient.java:90)

RE: WELCOME to user@drill.apache.org

2019-05-24 Thread Ahmad, Sami
t;hive.metastore.warehouse.dir": "/tmp/drill_hive_wh", "fs.default.name": "hdfs:///" }, "enabled": true } Thanks a lot for your help Regards Sami From: Khurram Faraaz [mailto:kfar...@mapr.com] Sent: Thursday, May 23, 2019 6:01 PM To: Ahma

Re: WELCOME to user@drill.apache.org

2019-05-23 Thread Khurram Faraaz
der . > > -rw-r--r-- 1 root root 6345039 May 14 15:51 > hive-metastore-1.2.1000.2.6.5.0-292.jar > -rw-r--r-- 1 root root 122581 May 14 15:52 > hive-contrib-1.2.1000.2.6.5.0-292.jar > -rw-r--r-- 1 root root 120473 May 14 15:52 > hive-hbase-handler-1.2.1000.2.6.5.0-292.jar > [r

RE: WELCOME to user@drill.apache.org

2019-05-23 Thread Ahmad, Sami
@drill.apache.org; Ahmad, Sami Subject: Re: WELCOME to user@drill.apache.org If you are using mySQL for hive metastore, your entries in Drill's hive storage plugin should like below { "type": "hive", "configProps": { "hive.metastore.uris":

RE: WELCOME to user@drill.apache.org

2019-05-15 Thread Ahmad, Sami
Could this be version issue? I saw on web that dril 1.13 requires hive 2.3.X I am using hive 1.2 regards From: Khurram Faraaz [mailto:kfar...@mapr.com] Sent: Tuesday, May 14, 2019 6:35 PM To: user@drill.apache.org; Ahmad, Sami Subject: Re: WELCOME to user@drill.apache.org If you are using

RE: WELCOME to user@drill.apache.org

2019-05-15 Thread Ahmad, Sami
in 'hive.default' [Error Id: b4c73c9b-9460-4483-8010-a1bdaf97a4d0 ] (state=,code=0) From: Khurram Faraaz [mailto:kfar...@mapr.com] Sent: Tuesday, May 14, 2019 6:35 PM To: user@drill.apache.org; Ahmad, Sami Subject: Re: WELCOME to user@drill.apache.org If you are using mySQL for hive metastore,

RE: WELCOME to user@drill.apache.org

2019-05-15 Thread Ahmad, Sami
at org.apache.drill.exec.store.hive.client.DrillHiveMetaStoreClient.getTableNamesAndTypes(DrillHiveMetaStoreClient.java:90) ~[drill-storage-hive-core-1.16.0.jar:1.16.0] From: Khurram Faraaz [mailto:kfar...@mapr.com] Sent: Tuesday, May 14, 2019 6:35 PM To: user@drill.apache.org; Ahmad, Sami Su

Re: WELCOME to user@drill.apache.org

2019-05-14 Thread Khurram Faraaz
handler-1.2.1000.2.6.5.0-292.jar > [root@hadoop1 3rdparty]# > [root@hadoop1 3rdparty]# pwd > /root/apache-drill-1.16.0/jars/3rdparty > You have mail in /var/spool/mail/root > [root@hadoop1 3rdparty]# > > -Original Message- > From: Khurram Faraaz [mailto:kfar...@mapr.com] > S

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
enabled": false, > "enabled": true > } > > -----Original Message- > From: Ahmad, Sami [mailto:sami.ah...@dot.state.fl.us] > Sent: Tuesday, May 14, 2019 2:25 PM > To: user@drill.apache.org > Cc: user-h...@drill.apache.org > Subject: RE: WELCOME to user

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
d:image001.png@01D50A6A.689DF090] -Original Message- From: Khurram Faraaz [mailto:kfar...@mapr.com] Sent: Tuesday, May 14, 2019 3:10 PM To: user@drill.apache.org Cc: user-h...@drill.apache.org Subject: Re: WELCOME to user@drill.apache.org Looking at you Hive storage plugin, there are t

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
@drill.apache.org Cc: user-h...@drill.apache.org Subject: Re: WELCOME to user@drill.apache.org Looking at you Hive storage plugin, there are two entries (see below) that are missing, can you please add them with appropriate values to Hive storage plugin and give it a try ? "javax.jdo.option.Connecti

Re: WELCOME to user@drill.apache.org

2019-05-14 Thread Khurram Faraaz
; "enabled": true > } > > -----Original Message- > From: Ahmad, Sami [mailto:sami.ah...@dot.state.fl.us] > Sent: Tuesday, May 14, 2019 2:25 PM > To: user@drill.apache.org > Cc: user-h...@drill.apache.org > Subject: RE: WELCOME to user@drill.apache.org > > Hi K

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
rty.clientPort": "2181" }, "size.calculator.enabled": false, "enabled": true } -Original Message- From: Ahmad, Sami [mailto:sami.ah...@dot.state.fl.us] Sent: Tuesday, May 14, 2019 2:25 PM To: user@drill.apache.org Cc: user-h...@drill.apache.org Subjec

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
Faraaz [mailto:kfar...@mapr.com] Sent: Tuesday, May 14, 2019 2:18 PM To: user@drill.apache.org Cc: user-h...@drill.apache.org Subject: Re: WELCOME to user@drill.apache.org Hi Ahmad, Does the "show tables" command work for you from Hive shell ? Can you please share you Hive version that i

Re: WELCOME to user@drill.apache.org

2019-05-14 Thread Khurram Faraaz
Hi Ahmad, Does the "show tables" command work for you from Hive shell ? Can you please share you Hive version that is being used ? And share the content from your Hive storage plugin, which is available on the storage tab on Drill web UI. Thanks, Khurram On Tue, May 14, 2019 at 10:07 AM Ahmad,

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
Adding drill-dev -Original Message- From: Ahmad, Sami Sent: Tuesday, May 14, 2019 1:08 PM To: user-h...@drill.apache.org Cc: user@drill.apache.org Subject: RE: WELCOME to user@drill.apache.org I am not able to see any hive or hbase tables in drill , I get the schema fine , getting

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
I am not able to see any hive or hbase tables in drill , I get the schema fine , getting the error in the logfile shown below . Regards [root@hadoop1 bin]# ./drillbit.sh start Starting drillbit, logging to /root/apache-drill-1.16.0/log/drillbit.out [root@hadoop1 bin]# [root@hadoop1 bin]#