Creating Iceberg tables using Hue

You can create Iceberg tables in Hue by using a CREATE TABLE statement or by importing CSV files using the Hue importer.

Parquet is the only supported data file format for writing to Impala tables. For more information about the supported table formats, sample queries, and syntax, see the Create table feature. Following is a sample query to create an Iceberg table in Impala. You can run this query from the Impala editor in Hue:

CREATE TABLE ice_t2 (i int, s string, ts timestamp, d date)
STORED BY ICEBERG;

Alternatively, you can create an Iceberg table in Impala by importing a CSV file in Hue. You can either use an existing file present on your filesystem or upload a new file into Hue.

Log in to the Hue web interface.
Select Impala as the SQL editor, and then click on the left-assist panel as shown in the following image:

The Import to table page is displayed.

note
Do not navigate to Importer by clicking Importer on the left-most bar in the Hue web interface. By default, it creates a table in the select source, which could be Hive or Impala. The default source when you launch Hue is Hive. Because Iceberg with Hive is not supported, this can result into an error. Therefore, you must actively select Impala as the SQL engine before importing a file.
Select Remote File from the Type drop-down menu.
Click .. adjoining to the Path option.
The Choose a file modal is displayed.
Upload a CSV file or select an available file present on your filesystem.
Format and preview details are displayed.

At this point, you can select the characters that should be used for the field separator, record separator, and quotes.
Click Next.
Specify the type and name of your table under the DESTINATION section.
Expand the Extras section under the PROPERTIES section and select the Iceberg table option.
Verify other entries and make the necessary modifications.
Click Submit.
The CREATE TABLE query is submitted with your preferences.