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
Create Table AS (CTAS), does it distribute data randomly or based on the table on which it received data?
Home
Netezza
Create Table AS (CTAS), does it distribute data randomly or based on the table on which it received...
0
votes
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
Create Table AS (CTAS), does it distribute data randomly or based on the table on which it received data?
netezza
ctas
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Feb 21, 2023
by
Robindeniel
Response: Newly created table from CTAS gets distribution from the original table.
Related questions
0
votes
Q: If you did not specify any distribution clause, how the Create Table AS (CTAS) will distribute the rows?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
ctas
+1
vote
Q: 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
Q: 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
+1
vote
Q: 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
0
votes
Q: When Netezza redistributes a table and when it broadcasts a table?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
Q: What constraints on a table are enforced?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
0
votes
Q: What are the constraints on a table that are enforced?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
netezza
connection-tab
e
+1
vote
Q: What are the ways to load data from a table into a file?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
table
+1
vote
Q: Which one of the following pieces of information is maintained in the zone map table to assist the performance of a query?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
Q: Explain how data gets stored in Netezza and how does SPU failover takes place?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
...