Databricks/Spark data write to SQL DW is dropping the table and recreating it The Next CEO of Stack Overflowspark - scala - save dataframe to a table with overwrite modeSpark Dataframe / SQL - Complex enriching nested dataconnection from databricks to snowflakeSpark - Mixed case sensitivity in Spark DataFrame, Spark SQL, and/or Databricks TableDetecting CSV Headers when creating a DataBricks Delta Table?Spark/Databricks data write issue with Cosmos DB with Mongo DB APIDelete azure sql database rows from azure databricksAuthorization error with spark-sftp connector on DatabricksHow do explicit table partitions in Databricks affect write performance?
Are British MPs missing the point, with these 'Indicative Votes'?
Simplify trigonometric expression using trigonometric identities
Why did the Drakh emissary look so blurred in S04:E11 "Lines of Communication"?
Is it possible to create a QR code using text?
Why can't we say "I have been having a dog"?
Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact
Airship steam engine room - problems and conflict
What difference does it make matching a word with/without a trailing whitespace?
Is it correct to say moon starry nights?
What is the difference between 'contrib' and 'non-free' packages repositories?
Upgrading From a 9 Speed Sora Derailleur?
How to unfasten electrical subpanel attached with ramset
Can Sri Krishna be called 'a person'?
Can you teleport closer to a creature you are Frightened of?
How should I connect my cat5 cable to connectors having an orange-green line?
Is it possible to make a 9x9 table fit within the default margins?
What did the word "leisure" mean in late 18th Century usage?
How does a dynamic QR code work?
Direct Implications Between USA and UK in Event of No-Deal Brexit
What does this strange code stamp on my passport mean?
How badly should I try to prevent a user from XSSing themselves?
What happens if you break a law in another country outside of that country?
Mathematica command that allows it to read my intentions
Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico
Databricks/Spark data write to SQL DW is dropping the table and recreating it
The Next CEO of Stack Overflowspark - scala - save dataframe to a table with overwrite modeSpark Dataframe / SQL - Complex enriching nested dataconnection from databricks to snowflakeSpark - Mixed case sensitivity in Spark DataFrame, Spark SQL, and/or Databricks TableDetecting CSV Headers when creating a DataBricks Delta Table?Spark/Databricks data write issue with Cosmos DB with Mongo DB APIDelete azure sql database rows from azure databricksAuthorization error with spark-sftp connector on DatabricksHow do explicit table partitions in Databricks affect write performance?
In Azure SQL DW ,I have an empty table (say table T1) .
Suppose T1 has 4 columns C1,C2,C3 and C4 (C4 is not null)
I have a dataframe in Databricks (say df1) which has data for C1,C2 and C3
I am performing the write operation on the dataframe using code snippet like the following
df1.write
.format("com.databricks.spark.sqldw")
.option("url", jdbcURL)
.option("dbtable", "T1")
.option( "forward_spark_azure_storage_credentials","True")
.option("tempDir", tempDir)
.mode("overwrite")
.save()
What I see there is that instead of getting any error ,the table T1 gets lost and new table T1 gets created with only 3 columns C1,C2 and C3.
Is that an expected behavior or ideally while trying to insert data , some exceptions should have been thrown as data corresponding to C4 was missing ?
apache-spark apache-spark-sql databricks azure-sqldw azure-databricks
add a comment |
In Azure SQL DW ,I have an empty table (say table T1) .
Suppose T1 has 4 columns C1,C2,C3 and C4 (C4 is not null)
I have a dataframe in Databricks (say df1) which has data for C1,C2 and C3
I am performing the write operation on the dataframe using code snippet like the following
df1.write
.format("com.databricks.spark.sqldw")
.option("url", jdbcURL)
.option("dbtable", "T1")
.option( "forward_spark_azure_storage_credentials","True")
.option("tempDir", tempDir)
.mode("overwrite")
.save()
What I see there is that instead of getting any error ,the table T1 gets lost and new table T1 gets created with only 3 columns C1,C2 and C3.
Is that an expected behavior or ideally while trying to insert data , some exceptions should have been thrown as data corresponding to C4 was missing ?
apache-spark apache-spark-sql databricks azure-sqldw azure-databricks
add a comment |
In Azure SQL DW ,I have an empty table (say table T1) .
Suppose T1 has 4 columns C1,C2,C3 and C4 (C4 is not null)
I have a dataframe in Databricks (say df1) which has data for C1,C2 and C3
I am performing the write operation on the dataframe using code snippet like the following
df1.write
.format("com.databricks.spark.sqldw")
.option("url", jdbcURL)
.option("dbtable", "T1")
.option( "forward_spark_azure_storage_credentials","True")
.option("tempDir", tempDir)
.mode("overwrite")
.save()
What I see there is that instead of getting any error ,the table T1 gets lost and new table T1 gets created with only 3 columns C1,C2 and C3.
Is that an expected behavior or ideally while trying to insert data , some exceptions should have been thrown as data corresponding to C4 was missing ?
apache-spark apache-spark-sql databricks azure-sqldw azure-databricks
In Azure SQL DW ,I have an empty table (say table T1) .
Suppose T1 has 4 columns C1,C2,C3 and C4 (C4 is not null)
I have a dataframe in Databricks (say df1) which has data for C1,C2 and C3
I am performing the write operation on the dataframe using code snippet like the following
df1.write
.format("com.databricks.spark.sqldw")
.option("url", jdbcURL)
.option("dbtable", "T1")
.option( "forward_spark_azure_storage_credentials","True")
.option("tempDir", tempDir)
.mode("overwrite")
.save()
What I see there is that instead of getting any error ,the table T1 gets lost and new table T1 gets created with only 3 columns C1,C2 and C3.
Is that an expected behavior or ideally while trying to insert data , some exceptions should have been thrown as data corresponding to C4 was missing ?
apache-spark apache-spark-sql databricks azure-sqldw azure-databricks
apache-spark apache-spark-sql databricks azure-sqldw azure-databricks
asked Mar 8 at 19:03
AyanAyan
986
986
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You’ve set the mode to overwrite
— dropping and recreating the table in question is my experience there too. Maybe try append
instead?
add a comment |
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55069443%2fdatabricks-spark-data-write-to-sql-dw-is-dropping-the-table-and-recreating-it%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You’ve set the mode to overwrite
— dropping and recreating the table in question is my experience there too. Maybe try append
instead?
add a comment |
You’ve set the mode to overwrite
— dropping and recreating the table in question is my experience there too. Maybe try append
instead?
add a comment |
You’ve set the mode to overwrite
— dropping and recreating the table in question is my experience there too. Maybe try append
instead?
You’ve set the mode to overwrite
— dropping and recreating the table in question is my experience there too. Maybe try append
instead?
answered Mar 8 at 20:40
Stephen DarlingtonStephen Darlington
46.1k995143
46.1k995143
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55069443%2fdatabricks-spark-data-write-to-sql-dw-is-dropping-the-table-and-recreating-it%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown