Indexing fails if a table column is using a reserved Hive name

Description

At ingestion time, if you try to index a column which is named with a hive reserved word, the table is created and populated, but the data is not indexed, as the indexing will.

Potential Fix: Not sure about the implications for this fix!
Surround this sb.append with ' quotes ' https://github.com/Teradata/kylo/blob/02add4a7eb0afa578eb326c8c5098ddccd85a258/services/feed-manager-service/feed-manager-rest-model/src/main/java/com/thinkbiganalytics/feedmgr/rest/model/schema/TableSetup.java#L313

Could probably be fixed in NiFi by adding another processor to add quotes to attribute "fieldIndexString", before processor Extract Feed Data from index_text_service feed.

Example data:

I indexed DATE column, but Hive fails for the select query with "FAILED: ParseException line 1:7 Failed to recognize predicate 'date'. Failed rule: 'identifier' in table or column identifier"

Environment

None

Assignee

Unassigned

Reporter

Claudiu Stanciu

Labels

None

Reviewer

None

Story point estimate

None

Affects versions

Priority

Medium
Configure