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 INSERT query hangs

Highlighted

Impala INSERT query hangs

New Contributor

I am executing this query:

INSERT OVERWRITE TABLE B SELECT * from A;

 

Table A has 6TB of data, i have changed mem_limit config to 70%.

 

Are there any other configuration changes to be made since the above query hangs when executed.

1 REPLY 1

Re: Impala INSERT query hangs

Contributor

The first step to resolving hanging queries is to figure out why they are hanging.

 

1. Check the logs of the impalad you connect to. Often it will write details of what its doing. At the very least, we'll know which step hangs.

2. You can also check the Impala UI for more information about the query and its plan: http://impalad-node-hostname:25000

3. Are you sure its hanging and not just slow? Do you see the cluster using disks, CPU, etc? That can be a useful clue.

 

Using this information you may figure out what's going on. Or you can post extra information here and we can help more.

Don't have an account?
Coming from Hortonworks? Activate your account here