I may have asked this question incorrectly but I have the following query where I’m trying to pull 3 different metrics for a given store. When I pull them though it comes out as below: Is there a way …
Tag: aginity
How to copy CSV into table with missing column?
I want to import data from a csv file into redshift. CSV format: Here is my import command: The problem I have is that sometimes, my file has only col1, col2 and col3. Is it possible to execute the COPY and add null for the missing values? Answer Yes, but must be explicit about it: The missing col2 will be
RedShift Error when using COUNT (Distinct XXX) ERROR: XX000: This type of correlated subquery pattern is not supported due to internal error
I have a small query running in RedShift through Aginity that is getting the following error: ERROR: XX000: This type of correlated subquery pattern is not supported due to internal error Current …