Re: cant select from hive table

2019-05-28 Thread Paul Rogers
: Re: cant select from hive table Hi Ahmad, Could you please clarify, which version (and vendor) of Hive and Drill you are using? Apache Drill 1.16 works fine with hive 2.3.2. There are possible some issues for other versions of Hive, so it is highly recommended to use this specific version

RE: cant select from hive table

2019-05-28 Thread Ahmad, Sami
ll.apache.org > Cc: Khurram Faraaz > Subject: RE: cant select from hive table > > None of the three worked > > apache drill (hive.default)> use hive.`default`; > +--+---

RE: cant select from hive table

2019-05-28 Thread Ahmad, Sami
I am using hortonworks HDP 3.0 which comes with hive 3.1.0 I am using apache drill 1.16 regards -Original Message- From: Vova Vysotskyi [mailto:vvo...@gmail.com] Sent: Tuesday, May 28, 2019 1:19 PM To: user Subject: Re: cant select from hive table Hi Ahmad, Could you please clarify

Re: cant select from hive table

2019-05-28 Thread Vova Vysotskyi
he.org > Cc: Khurram Faraaz > Subject: RE: cant select from hive table > > None of the three worked > > apache drill (hive.default)> use hive.`default`; > +--+--+ > | ok | summary | > +--

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-27 Thread Ahmad, Sami
Object 'test' not found [Error Id: ebf13f9c-16c9-4990-b72a-ba74e8348753 ] (state=,code=0) -Original Message- From: Igor Guzenko [mailto:ihor.huzenko@gmail.com] Sent: Monday, May 27, 2019 11:02 AM To: user@drill.apache.org Cc: Khurram Faraaz Subject: Re: cant select from hive table

Re: cant select from hive table

2019-05-27 Thread Igor Guzenko
0) > apache drill (hive.default)> > > -Original Message- > From: Arina Yelchiyeva [mailto:arina.yelchiy...@gmail.com] > Sent: Friday, May 24, 2019 4:34 PM > To: user@drill.apache.org > Cc: Khurram Faraaz > Subject: Re: cant select from hive table > > EXTERNAL

RE: cant select from hive table

2019-05-27 Thread Ahmad, Sami
a Yelchiyeva [mailto:arina.yelchiy...@gmail.com] Sent: Friday, May 24, 2019 4:34 PM To: user@drill.apache.org Cc: Khurram Faraaz Subject: Re: cant select from hive table EXTERNAL SENDER: Use caution with links and attachments. Default is keyword, use it back-ticks (select * from hive.`d

Re: cant select from hive table

2019-05-24 Thread Arina Yelchiyeva
Default is keyword, use it back-ticks (select * 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; >

RE: cant select from hive table

2019-05-24 Thread Ahmad, Sami
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 | +--++ | hive.default | test | +--++ 1 row selected