The following are usage considerations for the TD_Unpivoting function:
- TD_Unpivoting function is aimed to be used in conjunction with other inDB analytic functions, in contrast to SQLE Unpivot.
- The function returns N*M output rows, if there are N rows in the input table and M features (columns). Due to this large output size, expect the query to run longer as the number of rows increases in the InputTable. The output size is limited by the user spool space, which in turn, limits the size or scalability of the input.
- With InputTypes as false, do note combine BLOB/CLOB data type columns with any other data type columns.