7.00.02 - Enclosing Database Object Names in Double Quotation Marks - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

For analytic functions, if the name of a database object contains spaces or special characters, or is case-sensitive, you must enclose the name in double quotation marks, as in the following examples.

Create a schema and a table:

beehive=> create schema "Schema TxtClssfr";
CREATE SCHEMA beehive=> create fact table "Schema TxtClssfr"."text_Classifier Case fact"(id
int, "ConTent" text, "[Category] coLumn" text) distribute by hash(id);
CREATE TABLE

If such a database object name is a function argument that must be enclosed in single quotation marks, you must put the double quotation marks inside the single quotation marks, as in this SQL-MapReduce query:

SELECT * FROM TextClassifierTrainer (
   ON (SELECT 1) PARTITION BY 1
   INPUTTABLE ('"Schema TxtClssfr"."text_Classifier Case fact"')
   TextColumn ('"ConTent"')
   CategoryColumn ('"[Category] coLumn" ')
   ModelFile ('KNN.bin')
   ClassifierType ('knn')
   ClassifierParameters ('Compress:0.5')
   FeatureSelection ('DF:[0.1:]')
   Database ('beehive')
   UserID ('beehive')
   Password ('beehive')
 );