Since Redshift does not support ALTER COLUMN, I would like to know if it’s possible to remove the NOT NULL constraints from columns in Redshift. Answer You cannot alter the table. There is an alternative approach. You can create a new column with NULL constraint. Copy the values from your old column to this new column and then drop the
Tag: amazon-redshift
How to GROUP BY and CONCATENATE fields in redshift
How to GROUP BY and CONCATENATE fields in Redshift e.g. If I have table How can I get result like this There are some solutions for PostgreSQL, but none of functions mentioned in those answers are available in Redshift rightnow. Answer Well, I am a little late but the announcement about this feature happened on 3rd Aug 2015. Redshift has
ILIKE and NOT ILIKE in aws redshift different from total
I ran three following queries in amazon redshift: The count was 1554. The count was 62. The count was 85. The last two (62 + 85) should equal 1554. What am I missing? Answer Double-quotes are for identifiers: “myColumn” Single quotes are for values: ‘value’. Your examples contradict those basic syntax rules. Also, you did not consider NULL values, which