Google cloud sql export csv fails when contains nulls
up vote
0
down vote
favorite
I'm exporting a table from my Mysql database in Cloud Sql with the command,
gcloud sql export csv INSTANCE URI --query = QUERY
I have the file in my bucket, but when I try to import into Bigquery it fails, I noticed that all nulls are replaced by "n,
not even close the quote.
I found that this is a known bug,
https://cloud.google.com/sql/docs/mysql/known-issues
Someone has a temporary solution?
thanks a lot.
google-cloud-sql gcloud export-csv asked Nov 22 at 16:53
Adamo Figueroa
335
add a comment |
up vote
0
down vote
favorite
I'm exporting a table from my Mysql database in Cloud Sql with the command,
gcloud sql export csv INSTANCE URI --query = QUERY
I have the file in my bucket, but when I try to import into Bigquery it fails, I noticed that all nulls are replaced by "n,
not even close the quote.
I found that this is a known bug,
https://cloud.google.com/sql/docs/mysql/known-issues
Someone has a temporary solution?
thanks a lot.
google-cloud-sql gcloud export-csv asked Nov 22 at 16:53
Adamo Figueroa
335
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm exporting a table from my Mysql database in Cloud Sql with the command,
gcloud sql export csv INSTANCE URI --query = QUERY
I have the file in my bucket, but when I try to import into Bigquery it fails, I noticed that all nulls are replaced by "n,
not even close the quote.
I found that this is a known bug,
https://cloud.google.com/sql/docs/mysql/known-issues
Someone has a temporary solution?
thanks a lot.
google-cloud-sql gcloud export-csv asked Nov 22 at 16:53
Adamo Figueroa
335
I'm exporting a table from my Mysql database in Cloud Sql with the command,
gcloud sql export csv INSTANCE URI --query = QUERY
I have the file in my bucket, but when I try to import into Bigquery it fails, I noticed that all nulls are replaced by "n,
not even close the quote.
I found that this is a known bug,
https://cloud.google.com/sql/docs/mysql/known-issues
Someone has a temporary solution?
thanks a lot.
google-cloud-sql gcloud export-csv google-cloud-sql gcloud export-csv asked Nov 22 at 16:53
Adamo Figueroa
335
asked Nov 22 at 16:53
Adamo Figueroa
335
asked Nov 22 at 16:53
Adamo Figueroa
335
asked Nov 22 at 16:53
Adamo Figueroa
335
asked Nov 22 at 16:53
Adamo Figueroa
335
335
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
The fix for this issue is still currently being addressed by the Cloud SQL Team. You can stay update on this thread
If you have to use CSV, you can try using an SQL client to issue an import with the options you prefer (LOAD DATA LOCAL INFILE) instead of using the Cloud SQL import API
answered Nov 22 at 20:26
Yasser Karout
714
add a comment |
Your Answer
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',
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%2f53435419%2fgoogle-cloud-sql-export-csv-fails-when-contains-nulls%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
up vote
1
down vote
accepted
The fix for this issue is still currently being addressed by the Cloud SQL Team. You can stay update on this thread
If you have to use CSV, you can try using an SQL client to issue an import with the options you prefer (LOAD DATA LOCAL INFILE) instead of using the Cloud SQL import API
answered Nov 22 at 20:26
Yasser Karout
714
add a comment |
up vote
1
down vote
accepted
The fix for this issue is still currently being addressed by the Cloud SQL Team. You can stay update on this thread
If you have to use CSV, you can try using an SQL client to issue an import with the options you prefer (LOAD DATA LOCAL INFILE) instead of using the Cloud SQL import API
answered Nov 22 at 20:26
Yasser Karout
714
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
The fix for this issue is still currently being addressed by the Cloud SQL Team. You can stay update on this thread
If you have to use CSV, you can try using an SQL client to issue an import with the options you prefer (LOAD DATA LOCAL INFILE) instead of using the Cloud SQL import API
answered Nov 22 at 20:26
Yasser Karout
714
The fix for this issue is still currently being addressed by the Cloud SQL Team. You can stay update on this thread
If you have to use CSV, you can try using an SQL client to issue an import with the options you prefer (LOAD DATA LOCAL INFILE) instead of using the Cloud SQL import API
answered Nov 22 at 20:26
Yasser Karout
714
answered Nov 22 at 20:26
Yasser Karout
714
answered Nov 22 at 20:26
Yasser Karout
714
answered Nov 22 at 20:26
Yasser Karout
714
714
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53435419%2fgoogle-cloud-sql-export-csv-fails-when-contains-nulls%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
