--- title: "Using Impala" slug: "hadoop-vpc-30" tags: ["Cloud Hadoop", "VPC"] updated: 2026-09-17T09:17:45Z published: 2026-09-17T09:17:45Z canonical: "guide.ncloud-docs.com/hadoop-vpc-30" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://guide.ncloud-docs.com/llms.txt > Use this file to discover all available pages before exploring further. # Using Impala Available in VPC [Impala](https://impala.apache.org/) is a massively parallel processing engine that can analyze stored data in real time using interactive SQL. It can read data from various storage sources such as HBase and Kudu, as well as Hadoop HDFS, and be used in conjunction with Hive and Hue. It uses your existing Hive metastore without the need to use a dedicated metastore. Impala appeared to solve the real-time query performance problem and multi-user support of Hive. While [Hive](https://hive.apache.org/) and [Pig](https://pig.apache.org/) process queries through the Map-Reduce framework, Impala has the fastest response speed because it uses its own distributed query engine. Note Impala supports single-statement transaction, but not multi-statement transaction. ## Impala components Impala service consists of three major components: Impala Daemon, StateStore, and Catalog Service. | Component | Description | | --- | --- | | Impala Daemon(Impalad) | - Installed on the data nodes in the Hadoop cluster, it manages the planning, scheduling, and execution engines for requested queries. - Each impalad consists of Query Planner, Query Coordinator, and Query Exec engine. - Query Planner: Establishes an execution plan for queries. - Query Coordinator: Requests to executor by managing job list and scheduling. - Query Exec Engine: Optimizes and executes queries and returns results to the coordinator. | | Impala StateStore(StateStored) | - Manages the state of impalad on each data node in the cluster. - Performs metadata sync operations for Impalad requested by Catalogd. | | Impala Catalog(Catalogd) | - Requests broadcasting to StateStored in order to reflect it in Impalad's metadata when querying. - Metadata changes made directly in impalad are automatically synchronized. - Changes made directly in Hive or HDFS must be synchronized using the Refresh statement. | ## Query execution process To execute the query: 1. Perform a query using the Impala shell, ODBC, and so on in a specific impalad within the cluster. 2. Impalad retrieves the table schema from the Hive metastore, determines the suitability of the query statement, and collects data blocks and location information required for query execution from the HDFS name node. 3. Based on the recently updated Impala metadata, information necessary for query execution is propagated to all impalads in the cluster. 4. All impalads that receive the query and metadata read the data block to be processed from the local directory and process the query. 5. When tasks are completed in all impalads, the impalad that received the query from the user collects the results and delivers them to the user. ![chadoop-30-00o](https://cdn.document360.io/6998976f-9d95-4df8-b847-d375892b92c2/Images/Documentation/chadoop-30-001.png?sv=2026-02-06&spr=https&st=2026-10-27T18%3A01%3A31Z&se=2026-10-27T19%3A01%3A31Z&sr=c&sp=r&sig=UtN%2Fz0LHbmT7EQXWmOt6HeqafDvpty2A7WQnMvzvw7g%3D) ## Using Impala It describes how to use Impala. ### Create cluster From the NAVER Cloud Platform console, create the Cloud Hadoop cluster. For more information about creating clusters, see [Create cluster](/docs/en/hadoop-vpc-2#%ED%81%B4%EB%9F%AC%EC%8A%A4%ED%84%B0-%EC%83%9D%EC%84%B1). ### Install Impala service from Ambari UI You can install Impala using Add Service in the Ambari UI. The options to enter during installation are as follows. **Advanced impala-env** | Setting | Value | | --- | --- | | `statestore_host` | `Impala_statestore_설치_FQDN` | | `catalog_host` | `Impala_catalog_설치_FQDN` | | `java_shared_lib_dir` | `/usr/jdk64/jdk1.8.0_192/jre/lib/amd64/server` | ### Check Impala service from Ambari UI You can check Impala services as follows: You can get start with the component and stop each of the service from this page. ![chadoop-30-003](https://cdn.document360.io/6998976f-9d95-4df8-b847-d375892b92c2/Images/Documentation/chadoop-30-003.png?sv=2026-02-06&spr=https&st=2026-10-27T18%3A01%3A31Z&se=2026-10-27T19%3A01%3A31Z&sr=c&sp=r&sig=UtN%2Fz0LHbmT7EQXWmOt6HeqafDvpty2A7WQnMvzvw7g%3D) - Summary: Checks hosts where components are installed. - Configs: Changes configuration of the Impala service. - Quick Links: Impala Statestore WEB-UI, Impala Catalog WEB-UI, Impala Server WEB-UI - Accessing these links requires [tunneling](/docs/en/hadoop-vpc-6). We recommend that you access through the Web UI link provided in the console. For more information, see [Access Impala WEB UI](/docs/en/hadoop-vpc-30#ImpalaWEBUI%EC%A0%91%EC%86%8D). Caution - When installing Atlas service on an Impala-installed cluster, Atlas service may not run properly due to duplication of ports. - Change the value in **Ambari UI** > **Atlas** > **CONFIGS** > **ADVANCED** > **Advanced application-properties** > **atlas.server.http.port** so that it does not duplicate with the port number (21000) that Impala is using, and rerun. ### Impala shell Trino CLI provides a responsive shell to run queries. For more information about Impala shell, see [Impala shell Documentation](https://impala.apache.org/docs/build/html/topics/impala_impala_shell.html). - Connect Impalad from Impala shell ``` /usr/lib/impala_3_1_0_0_78/impala-shell/impala-shell -i Example: impala-shell -i m-001-cluster-name-***-hd.kr.ch.naverncp.com; ``` Note When connecting to impalad from the Impala shell, is the host name of the data node running impalad. It is the host name of **Ambari UI** > **Impala** > **Quick Links** > **Impala Server WEB-UI**. - Change Hive properties to create table After changing the value of **Ambari UI > Hive > CONFIGS > ADVANCED > Advanced hive-site > hive.strict.managed.tables** to **false**, save it and restart Hive. - Create database and table ``` CREATE database test; USE test; CREATE TABLE testTable ( ID INT ); ``` - Search after saving data ``` INSERT INTO testTable(ID) VALUES (1); SELECT * FROM testTable; ``` Note For more query examples, see page 35 through 39 of the [Apache Impala guide](https://impala.apache.org/docs/build/impala-3.4.pdf). ### Accessing Impala WEB UI You can check the Impala editor in the Hue WEB UI. ![chadoop-impala-hue_ko](https://cdn.document360.io/6998976f-9d95-4df8-b847-d375892b92c2/Images/Documentation/chadoop-impala-hue_en.png?sv=2026-02-06&spr=https&st=2026-10-27T18%3A01%3A31Z&se=2026-10-27T19%3A01%3A31Z&sr=c&sp=r&sig=UtN%2Fz0LHbmT7EQXWmOt6HeqafDvpty2A7WQnMvzvw7g%3D) Note If you cannot see the Impala editor, proceed with the following steps: - Navigate to **Ambari Web UI** > **Hue** > **Configs** > **Hue Service Module** > **Hue Impala Module**. - Change the status to `ON`, and then restart the service. ![chadoop-impala-hue-module](https://cdn.document360.io/6998976f-9d95-4df8-b847-d375892b92c2/Images/Documentation/chadoop-impala-hue-module.png?sv=2026-02-06&spr=https&st=2026-10-27T18%3A01%3A31Z&se=2026-10-27T19%3A01%3A31Z&sr=c&sp=r&sig=UtN%2Fz0LHbmT7EQXWmOt6HeqafDvpty2A7WQnMvzvw7g%3D)