Studio creation of Hive tables

Hive tables can be created from Studio.

The Studio user can create a Hive table by:
  • Uploading data from a Microsoft Excel.
  • Uploading data from delimited files, such as CSV, TSV, and TXT.
  • Uploading data from compressed files, such as ZIP, GZ, and GZIP. A compressed file can include only one delimited file.
  • Importing a JDBC data source.
  • Exporting data from a Studio component.
  • Transforming data in a data set and then creating a new data set from the transformed data.

After the Hive table is created, Studio starts a Data Processing workflow on the table. For details on these Studio operations, see the Studio User's Guide.

A Studio-created Hive table will have the skipAutoProvisioning property added at creation time. This property prevents the table from being processed again by the BDD Hive Table Detector.

Another table property will be dataSetDisplayName, which stores the display name for the data set. The display name is a user-friendly name that is visible in the Studio UI.