Enclosing Database Object Names in Double Quotation Marks - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

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')
 );