Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala / Llama resource error... with dynamic resource pools

Highlighted

Impala / Llama resource error... with dynamic resource pools

New Contributor

Just in the process of deploying and getting started with a small 3 node cluster.. and running into only 1 small problem with resource allocation.

 

Here's a full profile download of the error, if anyone can point me in the right direction.. would be so kind

 

Query (id=a849f2a43c14d9ce:b3c2652cce319493)
Summary
Session ID: b64dc2e48f75ca3e:f648933aea0d4bac
Session Type: HIVESERVER2
HiveServer2 Protocol Version: V6
Start Time: 2016-05-09 12:13:56.082642000
End Time: 2016-05-09 12:13:56.119689000
Query Type: QUERY
Query State: EXCEPTION
Query Status: com.cloudera.llama.util.LlamaException: INTERNAL_ERROR - internal error : java.lang.ArithmeticException: / by zero, com.cloudera.llama.util.LlamaException: INTERNAL_ERROR - internal error : java.lang.ArithmeticException: / by zero, at com.cloudera.llama.server.TypeUtils.createError(TypeUtils.java:74), at com.cloudera.llama.am.LlamaAMServiceImpl.Reserve(LlamaAMServiceImpl.java:138), at com.cloudera.llama.am.MetricLlamaAMService.Reserve(MetricLlamaAMService.java:140), at com.cloudera.llama.thrift.LlamaAMService$Processor$Reserve.getResult(LlamaAMService.java:512), at com.cloudera.llama.thrift.LlamaAMService$Processor$Reserve.getResult(LlamaAMService.java:497), at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39), at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39), at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206), at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145), at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615), at java.lang.Thread.run(Thread.java:745), Caused by: java.lang.ArithmeticException: / by zero, at com.cloudera.llama.am.impl.NormalizedRMResource.getNormalizedCount(NormalizedRMResource.java:53), at com.cloudera.llama.am.impl.NormalizedRMResource.normalize(NormalizedRMResource.java:40), at com.cloudera.llama.am.impl.NormalizerRMConnector.reserve(NormalizerRMConnector.java:219), at com.cloudera.llama.am.impl.PhasingOutRMConnector.reserve(PhasingOutRMConnector.java:156), at com.cloudera.llama.am.impl.SingleQueueLlamaAM.reserve(SingleQueueLlamaAM.java:266), at com.cloudera.llama.am.impl.ThrottleLlamaAM.reserve(ThrottleLlamaAM.java:305), at com.cloudera.llama.am.impl.MultiQueueLlamaAM.reserve(MultiQueueLlamaAM.java:289), at com.cloudera.llama.am.impl.GangAntiDeadlockLlamaAM.reserve(GangAntiDeadlockLlamaAM.java:205), at com.cloudera.llama.am.impl.ExpansionReservationsLlamaAM.reserve(ExpansionReservationsLlamaAM.java:131), at com.cloudera.llama.am.impl.APIContractLlamaAM.reserve(APIContractLlamaAM.java:144), at com.cloudera.llama.am.LlamaAMServiceImpl.Reserve(LlamaAMServiceImpl.java:132), ... 9 more
WARNING: The following tables are missing relevant table and/or column statistics.
dzone.dzone_queries_staging

Impala Version: impalad version 2.4.0-cdh5.6.0 RELEASE (build 386c7fffa54a2b846dfb00a2ff7bf023dc2dd684)
User: admin
Connected User: admin
Delegated User:
Network Address: ::ffff:10.54.80.100:43914
Default Db: dzone
Sql Statement: SELECT * FROM `dzone`.`dzone_queries_staging` LIMIT 100
Coordinator: dzn-hdp-03.corp.cira.ca:22000
Plan:
----------------
Estimated Per-Host Requirements: Memory=0B VCores=1
WARNING: The following tables are missing relevant table and/or column statistics.
dzone.dzone_queries_staging

F01:PLAN FRAGMENT [UNPARTITIONED]
01:EXCHANGE [UNPARTITIONED]
limit: 100
hosts=1 per-host-mem=unavailable
tuple-ids=0 row-size=413B cardinality=0

F00:PLAN FRAGMENT [RANDOM]
DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED]
00:SCAN HDFS [dzone.dzone_queries_staging, RANDOM]
partitions=0/0 files=0 size=0B
table stats: unavailable
columns missing stats: dns_qname, customer_id, zone_id, zone_owner_id, server_location, server_cloud, geo_country, geo_lat, geo_long, dns_rcode, src, src_port, dst, dst_port, ts_delta, ts_query, ts_usec_query, ts_micros_query, ts_resp, ts_usec_resp, ts_micros_resp, dns_qtype, dns_answer, dns_queryid, ip_flags_mf, udpsum, ip_header_length, dns_additional, dns_opcode, protocol, dns_authority, len, udp_length, fragment_offset, ip_version, last_fragment, tcp_flag_ns, tcp_flag_cwr, tcp_flag_ece, tcp_flag_urg, tcp_flag_rst, tcp_flag_psh, tcp_flag_syn, tcp_flag_fin, tcp_flag_ack, aa, tc, rd, ra, z, ad, cd, reassembled_tcp_fragments, reassembled_datagram_fragments, tcp_header_length, tcp_seq, tcp_ack, fragmented, tcp_window_size, total_length, pay_load_length
limit: 100
hosts=1 per-host-mem=0B
tuple-ids=0 row-size=413B cardinality=0
----------------
Estimated Per-Host Mem: 0
Estimated Per-Host VCores: 1
Tables Missing Stats: dzone.dzone_queries_staging
Request Pool: root.admin
ExecSummary:
Planner Timeline
Analysis finished: 3789740
Equivalence classes computed: 7692546
Single node plan created: 10908712
Distributed plan created: 14220275
Lineage info computed: 17782370
Planning finished: 22315999
Query Timeline
Start execution: 37143
Planning finished: 25210094
Unregister query: 37055717
ImpalaServer
- ClientFetchWaitTimer: 0
- InactiveTotalTime: 0
- RowMaterializationTimer: 0
- TotalTime: 0