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
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
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-15 Thread Ahmad, Sami
I have put this parameter to false since we are not using sasl "hive.metastore.sasl.enabled": "false", From: Ahmad, Sami Sent: Wednesday, May 15, 2019 10:39 AM To: Khurram Faraaz ; user@drill.apache.org Subject: RE: WELCOME to user@drill.apache.org Changed it as p

RE: cant select from hive table

2019-05-27 Thread Ahmad, Sami
From root schema select * from hive.`test`; OR 3) Two separate queries: use hive; select * from test; If previous queries don't work for not secured deployment it's a bug. Thanks, Igor On Mon, May 27, 2019 at 3:27 PM Ahmad, Sami wrote: > > Still not wo

RE: Apache Drill Hangout - May 28, 2019

2019-05-27 Thread Ahmad, Sami
Yes please I have a question : can we query Hbase versions from Drill ? if yes how ? Thanks Sami -Original Message- From: Volodymyr Vysotskyi [mailto:volody...@apache.org] Sent: Monday, May 27, 2019 3:23 AM To: dev ; user Subject: Apache Drill Hangout - May 28, 2019 EXTERNAL

RE: cant select from hive table

2019-05-27 Thread Ahmad, Sami
efault`.test). > On May 24, 2019, at 10:59 PM, Ahmad, Sami wrote: > > As you can see , the show table command sees the table but select command > cant find it . > > pache drill (hive.default)> show tables; > +--++ > | TABLE_SCHEMA | TABLE_NAME | > +---

RE: cant select from hive table

2019-05-24 Thread Ahmad, Sami
ted (0.113 seconds) apache drill (hive.default)> select id from test; Error: VALIDATION ERROR: From line 1, column 16 to line 1, column 19: Object 'test' not found [Error Id: 7d0eb107-38c6-4d37-90b2-baa953a3e701 ] (state=,code=0) apache drill (hive.default)> From: Ahmad, Sami Sent: Frida

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: cant select from hive table

2019-05-28 Thread Ahmad, Sami
Vysotskyi On Tue, May 28, 2019 at 8:07 PM Ahmad, Sami wrote: > Any updates/advise on this please? > I really need to demo this apache drill to management . > > regards > > -Original Message----- > From: Ahmad, Sami > Sent: Monday, May 27, 2019 11:19 AM > To: user@dri

RE: cant select from hive table

2019-05-28 Thread Ahmad, Sami
Any updates/advise on this please? I really need to demo this apache drill to management . regards -Original Message- From: Ahmad, Sami Sent: Monday, May 27, 2019 11:19 AM To: user@drill.apache.org Cc: Khurram Faraaz Subject: RE: cant select from hive table None of the three worked

RE: cant select from hive table

2019-05-28 Thread Ahmad, Sami
Ahmad, Sami wrote: > Any updates/advise on this please? > I really need to demo this apache drill to management . > > regards > > -Original Message----- > From: Ahmad, Sami > Sent: Monday, May 27, 2019 11:19 AM > To: user@drill.apache.org > Cc: Khurram Faraaz &

help needed

2019-05-09 Thread Ahmad, Sami
hi I need help in apache drill and Hbase and hive , as I could not get drill to work with either , what are my options ? Regards Sami

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
onURL": "jdbc:derby:;databaseName=../sample-data/drill_hive_db;create=true", "hive.metastore.warehouse.dir": "/tmp/drill_hive_wh", Thanks, Khurram On Tue, May 14, 2019 at 11:31 AM Ahmad, Sami wrote: > Same problem I have with hbase , it wont show th

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
s 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, Sami wrote: > I am not able to see any hive or hbase tables in drill , I get the > schema fine , getting the

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
r": "/tmp/drill_hive_wh", Thanks, Khurram On Tue, May 14, 2019 at 11:31 AM Ahmad, Sami mailto:sami.ah...@dot.state.fl.us>> wrote: > Same problem I have with hbase , it wont show the tables. > Hbase version is 1.1.2 > > Here is the storage pl

RE: WELCOME to user@drill.apache.org

2019-05-14 Thread Ahmad, Sami
~[drill-shaded-guava-23.0.jar:23.0] at o -Original Message- From: user-h...@drill.apache.org [mailto:user-h...@drill.apache.org] Sent: Tuesday, May 14, 2019 10:55 AM To: Ahmad, Sami Subject: WELCOME to user@drill.apache.org EXTERNAL SENDER: Use caution with links and attachments.

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
a/drill_hive_db;create=true", "hive.metastore.warehouse.dir": "/tmp/drill_hive_wh", Thanks, Khurram On Tue, May 14, 2019 at 11:31 AM Ahmad, Sami wrote: > Same problem I have with hbase , it wont show the tables. > Hbase version is 1.1.2 > > Here is the

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":

problems with HBASE storage plugin

2019-05-24 Thread Ahmad, Sami
I am not able to get hbase storage plugin to work . HIVE storage plugin is working good though. From hbase I can see the tables and access them fine. The plugin in I am using is : { "type": "hbase", "config": { "hbase.zookeeper.quorum": "hadoop1,hadoop2,hadoop3",

cant select from hive table

2019-05-24 Thread Ahmad, Sami
Hi My hive storage plugin is working and I can see the hive tables but I can’t select from them ,please advise apache drill (hive.default)> show tables; +--++ | TABLE_SCHEMA | TABLE_NAME | +--++ | hive.default | test |

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