how to use hexa delimiter in sqoop to be read by using exteranl table delimeter The Next CEO of Stack OverflowHow do I split a string on a delimiter in Bash?Need help about importing the data from Mysql to HDFSSqoop import to HCatalog/Hive - table not visibleHow to import data using sqoop with ¡ (inverted exclamation mark) as delimiterHow to create Hive table on top orc format data?Sqoop: Multi character delimiterHive to RDBMS incremental exportSqoop export doesn't handle utf-8 characterssqoop export to Teradata gives com.teradata.connector.common.exception.ConnectorException: Malformed uxxxx encoding
Can this transistor (2N2222) take 6 V on emitter-base? Am I reading the datasheet incorrectly?
Upgrading From a 9 Speed Sora Derailleur?
Mathematica command that allows it to read my intentions
How to implement Comparable so it is consistent with identity-equality
Why does sin(x) - sin(y) equal this?
Is it OK to decorate a log book cover?
My boss doesn't want me to have a side project
Can I hook these wires up to find the connection to a dead outlet?
Is it "common practice in Fourier transform spectroscopy to multiply the measured interferogram by an apodizing function"? If so, why?
Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico
Find a path from s to t using as few red nodes as possible
Direct Implications Between USA and UK in Event of No-Deal Brexit
Why does the freezing point matter when picking cooler ice packs?
MT "will strike" & LXX "will watch carefully" (Gen 3:15)?
Why did early computer designers eschew integers?
Creating a script with console commands
What happens if you break a law in another country outside of that country?
Could you use a laser beam as a modulated carrier wave for radio signal?
Is there a rule of thumb for determining the amount one should accept for a settlement offer?
Read/write a pipe-delimited file line by line with some simple text manipulation
Why can't we say "I have been having a dog"?
Does Germany produce more waste than the US?
How dangerous is XSS
Find the majority element, which appears more than half the time
how to use hexa delimiter in sqoop to be read by using exteranl table delimeter
The Next CEO of Stack OverflowHow do I split a string on a delimiter in Bash?Need help about importing the data from Mysql to HDFSSqoop import to HCatalog/Hive - table not visibleHow to import data using sqoop with ¡ (inverted exclamation mark) as delimiterHow to create Hive table on top orc format data?Sqoop: Multi character delimiterHive to RDBMS incremental exportSqoop export doesn't handle utf-8 characterssqoop export to Teradata gives com.teradata.connector.common.exception.ConnectorException: Malformed uxxxx encoding
I have used --fields-terminated-by '336' i.e octal value of Þ capital THORN, Icelandic in sqoop command to extract data from netezza to hdfs.
In hdfs file I am able to see the Þ character, when I create an external table on top of the hdfs location I am not seeing the data displayed correctly.
Used the below options
FIELDS TERMINATED BY '222' -- decimal
FIELDS TERMINATED BY 'u00DE' -- hexa
FIELDS TERMINATED BY '336' -- octal
Please let me know if any other alternatives are available.
any help is greatly appreciated.
shell hive hex hdfs sqoop
edited Mar 7 at 21:00
liamhawkins
674623
asked Mar 7 at 19:27
prashanthprashanth
13
add a comment |
I have used --fields-terminated-by '336' i.e octal value of Þ capital THORN, Icelandic in sqoop command to extract data from netezza to hdfs.
In hdfs file I am able to see the Þ character, when I create an external table on top of the hdfs location I am not seeing the data displayed correctly.
Used the below options
FIELDS TERMINATED BY '222' -- decimal
FIELDS TERMINATED BY 'u00DE' -- hexa
FIELDS TERMINATED BY '336' -- octal
Please let me know if any other alternatives are available.
any help is greatly appreciated.
shell hive hex hdfs sqoop
edited Mar 7 at 21:00
liamhawkins
674623
asked Mar 7 at 19:27
prashanthprashanth
13
add a comment |
I have used --fields-terminated-by '336' i.e octal value of Þ capital THORN, Icelandic in sqoop command to extract data from netezza to hdfs.
In hdfs file I am able to see the Þ character, when I create an external table on top of the hdfs location I am not seeing the data displayed correctly.
Used the below options
FIELDS TERMINATED BY '222' -- decimal
FIELDS TERMINATED BY 'u00DE' -- hexa
FIELDS TERMINATED BY '336' -- octal
Please let me know if any other alternatives are available.
any help is greatly appreciated.
shell hive hex hdfs sqoop
edited Mar 7 at 21:00
liamhawkins
674623
asked Mar 7 at 19:27
prashanthprashanth
13
I have used --fields-terminated-by '336' i.e octal value of Þ capital THORN, Icelandic in sqoop command to extract data from netezza to hdfs.
In hdfs file I am able to see the Þ character, when I create an external table on top of the hdfs location I am not seeing the data displayed correctly.
Used the below options
FIELDS TERMINATED BY '222' -- decimal
FIELDS TERMINATED BY 'u00DE' -- hexa
FIELDS TERMINATED BY '336' -- octal
Please let me know if any other alternatives are available.
any help is greatly appreciated.
shell hive hex hdfs sqoop
shell hive hex hdfs sqoop
edited Mar 7 at 21:00
liamhawkins
674623
asked Mar 7 at 19:27
prashanthprashanth
13
edited Mar 7 at 21:00
liamhawkins
674623
asked Mar 7 at 19:27
prashanthprashanth
13
edited Mar 7 at 21:00
liamhawkins
674623
edited Mar 7 at 21:00
liamhawkins
674623
edited Mar 7 at 21:00
liamhawkins
674623
674623
asked Mar 7 at 19:27
prashanthprashanth
13
asked Mar 7 at 19:27
prashanthprashanth
13
asked Mar 7 at 19:27
prashanthprashanth
13
13
add a comment |
add a comment |
0
active
oldest
votes
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%2f55051429%2fhow-to-use-hexa-delimiter-in-sqoop-to-be-read-by-using-exteranl-table-delimeter%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%2f55051429%2fhow-to-use-hexa-delimiter-in-sqoop-to-be-read-by-using-exteranl-table-delimeter%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
