NVarchar(Max) on SQL Server source is handled as a LOB internally by Replicate. If the task is set to allow unlimited LOB size, you will see this message in the task log:
00012228: 2021-11-02T18:10:07 [TASK_MANAGER ]W: The target endpoint does not support replication of full LOB columns. To replicate LOB columns, enable "Limited-size LOB mode" in the Task Settings > Target Metadata tab. (replicationtask_util.c:309)
Hadoop target does not support unlimited LOB size. Set "Limit LOB size" to the max size of the NVarchar(Max) values stored in the source, or to 102400 KB (the maximum LOB size allowed), whichever is lower.
Environment
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
Related Content
Using Hadoop as a target > Limitations
Hadoop endpoint target data types
Handling LOB columns
