Creating a Virtual Warehouse and creating tables on Ozone
After you configure the Database Catalog to point to the Ozone filesystem, verify that the Hive and Impala Virtual Warehouses in Cloudera Data Warehouse (CDW) carry the right configurations, and then you can managing databases and tables residing in Ozone using Hue or other SQL clients.
- Log in to the Data Warehouse service as a DWAdmin.
Create an Impala or Hive Virtual Warehouse.
Since you have already added Ozone in your base cluster, the required configuration are made available in CDW when you create a Virtual Warehouse.
Verify that the Ozone configurations are present in CDW. From your Virtual
Warehouse tile, click ozone-site from the
Configuration files drop-down menu.
and select For Hive, click ozone-site from the Configuration files drop-down menu.and select
Use Hue or any other SQL clients to start managing databases, managed and
Following is a sample command to create an external table:
create external table [***TABLE-NAME***] (id int, name string) location 'ofs://ozone1/s3v/cdw-logs/compute-schal-pvc111-env-1-hive5/warehouse/tablespace/[***TABLE-NAME***]';
Verify that the required keys are created in the bucket by running the
ozone sh bucket ls [***VOLUME***] -p warehouses/tablespace