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.
CREATE TABLE ice_t2 (i int, s string, ts timestamp, d date) STORED BY ICEBERG;
Alternatively, you can create an Iceberg table 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.
- Click Importer on the left-assist panel.
- Select Remote File from the Type drop-down menu.
Click .. adjoining to the Path
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
Verify other entries and make the necessary modifications.
The CREATE TABLE query is submitted with your preferences.