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. Want to know more about what has changed? Check out the Community News blog.

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

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