How to ignore special characters while exporting my hive table to MySQL?
I'm trying to export one of my hive tables to MySQL. But one of the fields in hive table contains the special character "?". Due to which my sqoop export command is failing.
Can anyone please suggest me regarding the same?
mysql hive sqoop
add a comment |
I'm trying to export one of my hive tables to MySQL. But one of the fields in hive table contains the special character "?". Due to which my sqoop export command is failing.
Can anyone please suggest me regarding the same?
mysql hive sqoop
What have you tried so far? Please take a note whenever you post a question try to include your code so that other people can get an idea what you have tried on your end and where you getting stuck it will save everyone's time. Moreover, if you check this question has been answered before Here is a link <stackoverflow.com/questions/43112262/…>
– VIN
Nov 19 '18 at 14:36
Those are the actual characters or you are seeing this due toencoding mismatch
– Gaurang Shah
Nov 19 '18 at 16:42
add a comment |
I'm trying to export one of my hive tables to MySQL. But one of the fields in hive table contains the special character "?". Due to which my sqoop export command is failing.
Can anyone please suggest me regarding the same?
mysql hive sqoop
I'm trying to export one of my hive tables to MySQL. But one of the fields in hive table contains the special character "?". Due to which my sqoop export command is failing.
Can anyone please suggest me regarding the same?
mysql hive sqoop
mysql hive sqoop
edited Nov 19 '18 at 20:20
VIN
13311
13311
asked Nov 19 '18 at 9:58
ferventfervent
287
287
What have you tried so far? Please take a note whenever you post a question try to include your code so that other people can get an idea what you have tried on your end and where you getting stuck it will save everyone's time. Moreover, if you check this question has been answered before Here is a link <stackoverflow.com/questions/43112262/…>
– VIN
Nov 19 '18 at 14:36
Those are the actual characters or you are seeing this due toencoding mismatch
– Gaurang Shah
Nov 19 '18 at 16:42
add a comment |
What have you tried so far? Please take a note whenever you post a question try to include your code so that other people can get an idea what you have tried on your end and where you getting stuck it will save everyone's time. Moreover, if you check this question has been answered before Here is a link <stackoverflow.com/questions/43112262/…>
– VIN
Nov 19 '18 at 14:36
Those are the actual characters or you are seeing this due toencoding mismatch
– Gaurang Shah
Nov 19 '18 at 16:42
What have you tried so far? Please take a note whenever you post a question try to include your code so that other people can get an idea what you have tried on your end and where you getting stuck it will save everyone's time. Moreover, if you check this question has been answered before Here is a link <stackoverflow.com/questions/43112262/…>
– VIN
Nov 19 '18 at 14:36
What have you tried so far? Please take a note whenever you post a question try to include your code so that other people can get an idea what you have tried on your end and where you getting stuck it will save everyone's time. Moreover, if you check this question has been answered before Here is a link <stackoverflow.com/questions/43112262/…>
– VIN
Nov 19 '18 at 14:36
Those are the actual characters or you are seeing this due to
encoding mismatch
– Gaurang Shah
Nov 19 '18 at 16:42
Those are the actual characters or you are seeing this due to
encoding mismatch
– Gaurang Shah
Nov 19 '18 at 16:42
add a comment |
0
active
oldest
votes
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',
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%2f53372151%2fhow-to-ignore-special-characters-while-exporting-my-hive-table-to-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53372151%2fhow-to-ignore-special-characters-while-exporting-my-hive-table-to-mysql%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
What have you tried so far? Please take a note whenever you post a question try to include your code so that other people can get an idea what you have tried on your end and where you getting stuck it will save everyone's time. Moreover, if you check this question has been answered before Here is a link <stackoverflow.com/questions/43112262/…>
– VIN
Nov 19 '18 at 14:36
Those are the actual characters or you are seeing this due to
encoding mismatch
– Gaurang Shah
Nov 19 '18 at 16:42