I have a table in Redshift having datatype as text. I want to move this Data to Azure Data Warehouse. Can anyone suggest what could be the best distribution method(Hash or Round Robin) for this? as the data type is text in Redshift and has big data in it
Asked
Active
Viewed 52 times
0
-
what distribution method does it have in Redshift? – Nick.Mc Jan 24 '19 at 12:22
-
Even Distribution – Pooja Jan 24 '19 at 12:39
-
Redshift Even distribution = Azure DW Round Robin. Hash is if there is some known access pattern (defined by a piece of data in the row). Round Robin is good for default – Nick.Mc Jan 24 '19 at 13:01