Creating a Manifest File | Native Object Store ( NOS ) | Teradata Vantage - 17.05 - Creating a Manifest File Without Writing Separate Objects to the Object Store - Teradata Database

Teradata Vantageā„¢ - Native Object Store Getting Started Guide

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.05
created_date
January 2021
category
Programming Reference
featnum
B035-1214-175K

The following examples show how to use WRITE_NOS to create a manifest file.

When Write_NOS is done creating objects on external object store it can create a manifest file with the names of the objects created. If there is a crash, abort, or error while writing objects, the manifest file is not created.

  • The first example shows how to create the manifest file if a WRITE_NOS operation aborts before all the objects have been written out.
  • The second example shows how to overwrite a manifest file.
  • The third example shows how to create a manifest file using READ_NOS with RETURNTYPE('NOSREAD_KEYS') as input to writing the manifest file.
In these examples only the manifest file is written, not the actual objects the manifest file identifies.

    Prerequisites

  1. If not already done, set up an authorization to access external object storage. See Setting Up Authorization for WRITE_NOS Examples.
  2. If not already done, set up a database table to extract data from. You can use one of your existing tables or set up a test table to use with the examples. See Setting Up a Test Table.
  3. If not already done, set up or obtain access to the external object store where you want to write data. Follow the instructions from your external storage vendor.
  4. Create A Manifest Table in the Database

  5. Create a database table to store the manifest file entries:
    CREATE TABLE ManifestTbl 
    ( ObjectName VARCHAR(1024) CHARACTER SET UNICODE NOT CASESPECIFIC,
      ObjectSize BIGINT
    );