Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
If you did not specify any distribution clause, how the Create Table AS (CTAS) will distribute the rows?
Home
Netezza
If you did not specify any distribution clause, how the Create Table AS (CTAS) will distribute the...
0
votes
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
If you did not specify any distribution clause, how the Create Table AS (CTAS) will distribute the rows?
netezza
ctas
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Feb 19, 2023
by
rajeshsharma
CTAS will get a distribution from the original table.
Related questions
0
votes
Create Table AS (CTAS), does it distribute data randomly or based on the table on which it received data?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
ctas
0
votes
If you did not specify any distribution on clause while creating a table, what distribution Netezza uses?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
netezz
+1
vote
How do you check the rows in a table are equally distributed in all SPU’s or not?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
spu
netezza
+1
vote
Can you update the columns used in the distribution clause?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
netezza
+1
vote
What data types are most suited for the columns specified in the distribution clause?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
netezza
distribution-clause
+1
vote
Which system table could be used to find an object id for any table/view or object in a database?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
+1
vote
What is the maximum number of columns you can choose as organizing keys for a clustered base table?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
What is the distribution of materialized views?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
materialized-views
netezza
+1
vote
How do you redistribute a table?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
Why do you prefer to truncate instead of drop table command?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
...