CODEWITHSUNDEEP
hivehiveql
Martin
Martin

Reputation: 183

Hive String operator concatenate by || double pipe

Language manual of Hive claims that double pipe string concatenation is supported, however I am unable to use this feature in my current version of HIVE 1.2.1000.2.4.3.6-2

hive> select 'a'||'b';
NoViableAltException(5@[323:1: atomExpression : ( ( KW_NULL )=> KW_NULL -> TOK_NULL | ( constant )=> constant | castExpression | caseExpression | whenExpression | ( functionName LPAREN )=> function | tableOrColumn | LPAREN ! expression RPAREN !);])

I was trying to find a version which starts to support that, but without any luck :-(

I know that I can use build in function concat to do the same thing, but I am rewriting bunch of Oracle views to Hive and I don't want to change things which can stay the same if possible.

Upvotes: 6

Views: 43187

Answers (1)

David דודו Markovitz
David דודו Markovitz

Reputation: 44991

Hive 2.2.0
The documentation is very clear about that

enter image description here https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-StringOperators

Upvotes: 7

Related Questions