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
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
&
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
try:
1) Two separate queries:
use hive.`default`;
select * from test;
OR
2) 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 bu
from hive.`default`.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 | TA
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 SENDER:
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
S
ationException
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(DrillHiveMetaStor
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 |
+--+---
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
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",
"hbase.zoo
@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&q
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
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 per y
#x27; not found within '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 us
e-1.16.0.jar:1.16.0]
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.
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
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
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 the table
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
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
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 the
va:2417)
~[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 attac
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
24 matches
Mail list logo