Follow

GPUDB-0002: UNPIVOT Function Throws Error on Columns Containing More Than One Period

Overview:

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.

 

Error:

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:

  1. Create a table that contains a column name with more than one period such as, "some.column.name"
  2. Access the API Tool and utilize the /aggregate/unpivot function against the newly created column

Expected:

The process executes and completes without error/issue

Observed:

The above error is received and the process fails

 

Solution:

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 6.2.0.26 release of Kinetica.

 

Additional Information:

  • Affects Version:
    • 6.2.0.23
  • Fixed Version:
    • 6.2.0.26
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.