Unica Campaign V12.1.3 Release Notes | 1 - Release Notes for version 12.1.3 | 40
ableCreateRunScript, where you can pro
vide SQL or scripts to create indexes on
user database tables. If you are using DB2
10.5 as a customer database, with the
BLU feature ON, you do not need to con
figure any of these temp table properties.
201,968,200,241 If two process boxes are moved very
close together in a flowchart, the direction
of the connection arrow changes. This
limitation affects the visual representation
of the arrow. The process data ow is not
affected. The workaround is to move the
process boxes farther apart so the arrow
head changes back to the correct direc
tion.
211293 In Unica Campaign, the built-in macro
Current_Date() results in an error when ex
ecuted against a Hive 1.2 based Big Data
instance. The Hive ODBC driver does not
support the Current_Date macro to obtain
interval values. For example, executing
the following query results in a Hive error:
SELECT DISTINCT customerid FROM Cus
tomer_date WHERE ((Customer_date.my_
date_mmdyyyy - CURRENT_DATE()) >= 7)
Error: Hive 2 Internal error: unsupported
conversion from type: interval_day_time
Workaround: To use the Current_Date
function in a RAW SQL query on Hive with
Hortonworks, execute SQL in the follow
ing format: