To utilize the UNPIVOT function against columns that have been configured with names that contain more than one period will throw an error stating as such, and the process will not complete as intended.
The following error will be encountered in this scenario:
2019-01-06 15:25:55.392 UERR (15531,17141,r0/gpudb_cluster_c) g-p4-300-302-u37.tysons.kinetica.com TypeManageme nt/Type.cpp:524 - 'The column_names parameter member: some.column.name has more than one period in the name (TM /Tc:524)'
Steps to Reproduce:
- Create a table that contains a column name with more than one period such as, "some.column.name"
- Access the API Tool and utilize the /aggregate/unpivot function against the newly created column
The process executes and completes without error/issue
The above error is received and the process fails
As columns with periods in their name are supported in the application, this issue has been resolved with a code-line change. It has been resolved in the 18.104.22.168 release of Kinetica.
- Affects Version:
- Fixed Version: