CODEWITHSUNDEEP
hivehiveqlhive-udf
Sparrow
Sparrow

Reputation: 41

Hive UDF only works in standalone select statement and not in "Create table as select..." or "insert into .. select.."

I have a Generic UDF which encrypts a given input value. This UDF gives the correct value when used in a select statement however the UDF returns null when used in "Create table as select" or "Insert into .. select" statement. Input to the udf, output from udf, data type of the table column being created or inserted into, all are of type string.

So what could be the reason behind the select statement behaving differently when part of create or insert statement?

Upvotes: 1

Views: 92

Answers (0)

Related Questions