About hores

hores · ‎03-05-2019

Hi @Consult, 1. What is your recommendation about it? It is better to use it on all your components (Hive, ImpalaEmbeddedJVM, YARN, hdfs etc) or not? are their some exceptional components? 2. How do I configure theImpalaEmbeddedJVM ? Thanks

hores · ‎02-26-2019

Hi, We have CDH 5.15 on our production cluster with JDK 8, What is your recommendation about moving to G1GC or stay with the CMS, didn't find any clear instruction about it. Does it depend on the CDH version? or on the components I'm using? Thanks

hores · ‎03-04-2018

HI @AcharkiMed, 1. Thanks! 2. Thanks, but all the explanations in the link you sent I get when hovering with the mouse over the metrics, but I was asking about the metrics in Query Fragments section in Impala Cloudera .

hores · ‎02-07-2018

Hi All, 1. What is "Rows available" in Query Timeline of Impala query mean? what is Impala doing at this stage? 2. Is there a place where I can find an explanation of all the query profile metrics? Thanks

hores · ‎01-02-2018

It's stuck in a CREATED state (if I remember correctly at one time I could get to the daemon page), I don't remember about other queries cause when I've checked only this query was on the daemon and the daemon was page stuck in my browser. My daemon has exactly 16GB. Thanks, I'll try that, there any other tracing tool I can use to check the daemon or the query?

hores · ‎12-31-2017

Hi, I don't have a firewall because before running the query I can work with the daemon. Yes, the daemon is hung every time I start executing the query and I want to check on what, but I don't find anything so I wanted to debug the query and see step after step on what phase it stuck. After restarting ImpalaD the daemon is working again until I issue the query again. Thanks

hores · ‎12-31-2017

Hi, Ok, we will check that. Mauricio, thanks for the detailed answer!

hores · ‎12-31-2017

Hi mauricio, Very good and interesting direction to check:), From what I've looked at our tables, It looks like the problematic tables have 2000-20000 partitions and 1000-10000 files, so maybe it's too many partitions. Can you elaborate on how you defragment/compact your tables? what process are you doing on your maintenance jobs? Thanks a lot!

hores · ‎12-31-2017

Hi, thanks for the reply. But my problem is that I can't access "http://[coordinator_hostname]:25000" when I'm running the query, somehow the URL is frozen. even when I'm running it on Impala-shell with live-summary I don't get to the state when it spills tracing output cause it get stuck before doing it. so I wanted to know if there is an option to trace the query right after I execute it on impala-shell and see on which stage it get stuck. Thanks for the help

hores · ‎12-27-2017

Hi, We have at least once a day a situation where a refresh table is running on Impala and can take about an hour to finish and it seems like it gets locked on something. Even simple queries like DESCRIBE on another table can take 1 hour to finish when the refresh table is running. Do you know about locking issues I need to be aware of? How can I investigate this issue further cause I didn't find anything about it and don't know where to start? Thanks for the help

Online	Offline
Last Visited	‎10-27-2019 03:30 AM

Member Since	‎11-27-2017 05:05 AM
Last Visited	‎10-27-2019 03:30 AM
Posts	32
Kudos received	1

Cloudera Community

Re: Using G1GC of JDK 8 on Cloudera

Using G1GC of JDK 8 on Cloudera

Re: Impala "Rows available" in Query Timeline

Impala "Rows available" in Query Timeline

Re: Debugging query in Impala

Re: Debugging query in Impala

Re: Locking in Impala

Re: Locking in Impala

Re: Debugging query in Impala

Locking in Impala