Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
MapReduce >> mail # user >> Re: Issue with running Impala


Copy link to this message
-
Re: Issue with running Impala
Hi,

This question should go to the impala-user group which you can subscribe to
here:

https://groups.google.com/a/cloudera.org/forum/?fromgroups#!forum/impala-user

Sorry for the confusion.

Brock

On Mon, Oct 29, 2012 at 8:17 PM, Subash D'Souza <[EMAIL PROTECTED]> wrote:

> I'm hoping this is the right place to post questions about Impala. I'm
> playing around with Impala and have configured and got it running. I tried
> a running a query though and it comes back with a very abstract error. Any
> help would be appreciated.
>
> Thanks
> Subash
>
> Here are the error and log files for the same
> [hadoop4.rad.wc.truecarcorp.com:21000] > select * from clearbook2 limit 5;
> ERROR: Failed to open HDFS file hdfs://
> hadoop1.rad.wc.truecarcorp.com:8020/tc/clearbook_data_20120101.txt.gz
> Error(255): Unknown error 255
> ERROR: Invalid query handle
>
> My log files don't seem to give much information
>
> Impala State Server
>
>
>  I1029 18:01:01.906649 23286 impala-server.cc:1524] TClientRequest.queryOptions: TQueryOptions {
>   01: abort_on_error (bool) = false,
>   02: max_errors (i32) = 0,
>   03: disable_codegen (bool) = false,
>   04: batch_size (i32) = 0,
>   05: return_as_ascii (bool) = true,
>   06: num_nodes (i32) = 0,
>   07: max_scan_range_length (i64) = 0,
>   08: num_scanner_threads (i32) = 0,
>   09: max_io_buffers (i32) = 0,
>   10: allow_unsupported_formats (bool) = false,
>   11: partition_agg (bool) = false,
> }
> I1029 18:01:01.906776 23286 impala-server.cc:821] query(): query=select * from clearbook2 limit 5
> I1029 18:01:02.755319 23286 coordinator.cc:209] Exec() query_id=5fa79b17f9a8474f:97b7e6fea1b688a1
> I1029 18:01:02.756422 23286 simple-scheduler.cc:159] SimpleScheduler assignment (data->backend):  (10.5.22.22:50010 -> 10.5.22.22:22000), (10.5.22.24:50010 -> 10.5.22.24:22000), (10.5.22.23:50010 -> 10.5.22.23:22000)
> I1029 18:01:02.756430 23286 simple-scheduler.cc:162] SimpleScheduler locality percentage 100% (3 out of 3)
> I1029 18:01:02.759310 23286 plan-fragment-executor.cc:70] Prepare(): query_id=5fa79b17f9a8474f:97b7e6fea1b688a1 instance_id=5fa79b17f9a8474f:97b7e6fea1b688a2
> I1029 18:01:02.763690 23286 plan-fragment-executor.cc:83] descriptor table for fragment=5fa79b17f9a8474f:97b7e6fea1b688a2
> tuples:
> Tuple(id=0 size=560 slots=[Slot(id=0 type=STRING col=0 offset=16 null=(offset=0 mask=2)), Slot(id=1 type=STRING col=1 offset=32 null=(offset=0 mask=4)), Slot(id=2 type=STRING col=2 offset=48 null=(offset=0 mask=8)), Slot(id=3 type=STRING col=3 offset=64 null=(offset=0 mask=10)), Slot(id=4 type=STRING col=4 offset=80 null=(offset=0 mask=20)), Slot(id=5 type=STRING col=5 offset=96 null=(offset=0 mask=40)), Slot(id=6 type=FLOAT col=6 offset=8 null=(offset=0 mask=1)), Slot(id=7 type=STRING col=7 offset=112 null=(offset=0 mask=80)), Slot(id=8 type=STRING col=8 offset=128 null=(offset=1 mask=1)), Slot(id=9 type=STRING col=9 offset=144 null=(offset=1 mask=2)), Slot(id=10 type=STRING col=10 offset=160 null=(offset=1 mask=4)), Slot(id=11 type=STRING col=11 offset=176 null=(offset=1 mask=8)), Slot(id=12 type=STRING col=12 offset=192 null=(offset=1 mask=10)), Slot(id=13 type=STRING col=13 offset=208 null=(offset=1 mask=20)), Slot(id=14 type=STRING col=14 offset=224
>  null=(offset=1 mask=40)), Slot(id=15 type=STRING col=15 offset=240 null=(offset=1 mask=80)), Slot(id=16 type=STRING col=16 offset=256 null=(offset=2 mask=1)), Slot(id=17 type=STRING col=17 offset=272 null=(offset=2 mask=2)), Slot(id=18 type=STRING col=18 offset=288 null=(offset=2 mask=4)), Slot(id=19 type=STRING col=19 offset=304 null=(offset=2 mask=8)), Slot(id=20 type=STRING col=20 offset=320 null=(offset=2 mask=10)), Slot(id=21 type=STRING col=21 offset=336 null=(offset=2 mask=20)), Slot(id=22 type=STRING col=22 offset=352 null=(offset=2 mask=40)), Slot(id=23 type=STRING col=23 offset=368 null=(offset=2 mask=80)), Slot(id=24 type=STRING col=24 offset=384 null=(offset=3 mask=1)), Slot(id=25 type=STRING col=25 offset=400 null=(offset=3 mask=2)), Slot(id=26 type=STRING col=26 offset=416 null=(offset=3 mask=4)), Slot(id=27 type=STRING col=27 offset=432 null=(offset=3 mask=8)), Slot(id=28 type=STRING col=28 offset=448 null=(offset=3 mask=10)), Slot(id=29
Apache MRUnit - Unit testing MapReduce - http://incubator.apache.org/mrunit/
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB