Redshift query failed with error Error : No method asJSON S3 class: pq_super

Issues
#1

redshift query failed with error Error : No method asJSON S3 class: pq_super . how to debug where is the issue or how to ignore and proceed further?

#2

Hi Manas,
As for the SUPER data type column (SUPER type - Amazon Redshift), please cast it to VARCHAR.

For example, if ColA is the column whose data type is SUPER, you can use CAST as follows.

SELECT CAST(ColA AS VARCHAR) AS ColA_Text
FROM YourTableName;
#3

After casting to varchar issue got resolved. Thanks for quick reply