IBM Support

Default distribution key when using CTAS

Question & Answer


Question

What is the default distribution key when using the CTAS command?

Answer

It is a best practice to define explicit distribution keys when using the CTAS (Create Table As) command. However if you do not do so, a CTAS table inherits its distribution keys from the parent table.

If there is no deducible distribution key or the source stream into the table has round robin distribution, the default distribution key for CTAS tables is the first column (hash distribution).

For more information about handling distribution keys, refer to the Netezza Performance Server Database User's Guide.

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

NZ954681

Document Information

Modified date:
17 October 2019

UID

swg21570716