You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Adrià Vilà <av...@datknosys.com> on 2015/07/29 16:49:00 UTC
Drill 1.1 on Hive 1.2? (No results on hive tables!)
Hi everyone,
Have installed and configured correctly hive "storage" plugin and it 's possible to list hive databases and view hive tables schema (describe table returns the right result), but any (basic) SELECT query returns no rows: "No rows selected".
Cluster versions:
- google cloud platform
- multi node cluster
- hive 1.2.1.2.3
- zookeeper 3.4.6.2.3
- hdfs 2.7.1.2.3
- drill 1.1 (commit e3fc7e97bfe712dc09d43a8a055a5135c96b7344)
Is it possible that hive 1.2 version is not supported yet by drill 1.1 and thats why I can't get any results on hive tables? I get no error, just no results.. Have been looking all logs and files I could!
Is there any commit that fixes this?
Thank you in advance!
Adrià
----------------------------------------
ADRIÀ VILÀ
Desarrollador de Software | Software Development
avila@datknosys.com
Tel.: +34 650 538 419
www.datknosys.com
Gran Via Carles III, 84, planta 3 (Torres Trade) - 08028 Barcelona (España) - T +34 934 965 721
Paseo de la Castellana 141, 20ª (Edif Cuzco IV) - 28046 Madrid (España) - T +34 917 498 012
Calle Aguere, 9 local 01 (Torres de Cristal) - 38005 Santa Cruz de Tenerife (España) - T +34 922 02 57 60
4 N. 2nd Street, Suite #210 San Jose, CA 95113 (USA) - Phone: +1 (408) 628 1441 -->
----------------------------------------
La información contenida en este mensaje es confidencial y se dirige exclusivamente a su destinatario, estando prohibida su divulgación parcial o total. Por favor contacte inmediatamente al remitente si ha recibido este mensaje por error. // The information in this message is confidential and it is intended only to its recipient, being forbidden its total or partial disclosure. Please immediately contact the sender if you have received this message by mistake.
Re: Drill 1.1 on Hive 1.2? (No results on hive tables!)
Posted by Neeraja Rentachintala <nr...@maprtech.com>.
Yes, Drill 1.1 supports hive 1.0.
On Wednesday, July 29, 2015, Adrià Vilà <av...@datknosys.com> wrote:
> Hi everyone,
>
> Have installed and configured correctly hive "storage" plugin and it 's
> possible to list hive databases and view hive tables schema (describe table
> returns the right result), but any (basic) SELECT query returns no rows:
> "No rows selected".
>
> Cluster versions:
> - google cloud platform
> - multi node cluster
> - hive 1.2.1.2.3
> - zookeeper 3.4.6.2.3
> - hdfs 2.7.1.2.3
> - drill 1.1 (commit e3fc7e97bfe712dc09d43a8a055a5135c96b7344)
>
> Is it possible that hive 1.2 version is not supported yet by drill 1.1
> and thats why I can't get any results on hive tables? I get no error, just
> no results.. Have been looking all logs and files I could!
> Is there any commit that fixes this?
>
> Thank you in advance!
>
> Adrià
>
>
>
> ----------------------------------------
>
> ADRIÀ VILÀ
> Desarrollador de Software
> | Software Development
> avila@datknosys.com
> <javascript:;>
> Tel.: +34 650 538 419
> www.datknosys.com
> Gran Via Carles III, 84,
> planta 3 (Torres Trade) - 08028 Barcelona (España) - T +34 934 965 721
> Paseo de la Castellana
> 141, 20ª (Edif Cuzco IV) - 28046 Madrid (España) - T +34 917 498 012
> Calle Aguere, 9 local 01
> (Torres de Cristal) - 38005 Santa Cruz de Tenerife (España) - T +34 922 02
> 57 60
> 4 N. 2nd Street, Suite
> #210 San Jose, CA 95113 (USA) - Phone: +1 (408) 628 1441 -->
>
> ----------------------------------------
>
> La información contenida
> en este mensaje es confidencial y se dirige exclusivamente a su
> destinatario, estando prohibida su divulgación parcial o total. Por favor
> contacte inmediatamente al remitente si ha recibido este mensaje por error.
> // The information in this message is confidential and it is intended only
> to its recipient, being forbidden its total or partial disclosure. Please
> immediately contact the sender if you have received this message by mistake.
>
>
>