Impala query language conformance
The following guidelines apply when Unica Campaign is integrated with Impala-based big data sources. Please refer to Cloudera documentation for HiveQL features not available in Impala
- The SQL must conform with HiveQL.
- If you are writing raw SQL queries for use in Impala Unica Campaign, confirm that the queries work on Impala .
- Using multiple SQL statements for raw SQL queries is not supported.
- You might need to modify existing queries for Impala if you are using raw SQL in Unica Campaign process boxes, custom macros, or derived fields, for pre- and post-processing.