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