Impala double values not getting loaded correctly
I have created a simple table in impala like below
CREATE TABLE IF NOT EXISTS my_db.employee
(name STRING, salary double );
And my insert statement is like below
insert into employee (name, salary)
VALUES ("Prasad", 158.17)
But the problem is
My values in impala is getting loaded as
name,salary
prasad,158.1666666666
I don't understand why this is happening. I have tried in other db's like hive but the value is getting loaded as 158.17 but in impala it is 158.1666666666
Can you please help me why this is happening ...
And how to load actual values...
Please guide me
sql hadoop hive impala
add a comment |
I have created a simple table in impala like below
CREATE TABLE IF NOT EXISTS my_db.employee
(name STRING, salary double );
And my insert statement is like below
insert into employee (name, salary)
VALUES ("Prasad", 158.17)
But the problem is
My values in impala is getting loaded as
name,salary
prasad,158.1666666666
I don't understand why this is happening. I have tried in other db's like hive but the value is getting loaded as 158.17 but in impala it is 158.1666666666
Can you please help me why this is happening ...
And how to load actual values...
Please guide me
sql hadoop hive impala
add a comment |
I have created a simple table in impala like below
CREATE TABLE IF NOT EXISTS my_db.employee
(name STRING, salary double );
And my insert statement is like below
insert into employee (name, salary)
VALUES ("Prasad", 158.17)
But the problem is
My values in impala is getting loaded as
name,salary
prasad,158.1666666666
I don't understand why this is happening. I have tried in other db's like hive but the value is getting loaded as 158.17 but in impala it is 158.1666666666
Can you please help me why this is happening ...
And how to load actual values...
Please guide me
sql hadoop hive impala
I have created a simple table in impala like below
CREATE TABLE IF NOT EXISTS my_db.employee
(name STRING, salary double );
And my insert statement is like below
insert into employee (name, salary)
VALUES ("Prasad", 158.17)
But the problem is
My values in impala is getting loaded as
name,salary
prasad,158.1666666666
I don't understand why this is happening. I have tried in other db's like hive but the value is getting loaded as 158.17 but in impala it is 158.1666666666
Can you please help me why this is happening ...
And how to load actual values...
Please guide me
sql hadoop hive impala
sql hadoop hive impala
edited Nov 24 '18 at 1:43
Gordon Linoff
765k35296400
765k35296400
asked Nov 23 '18 at 19:29
prasadprasad
1818
1818
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
This is a problem of floating point versus fixed point arithmetic. If you want the decimal portion to be exact, use decimal
/numeric
for the column:
CREATE TABLE IF NOT EXISTS my_db.employee
name STRING,
salary DECIMAL(10, 2)
);
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',
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%2f53452064%2fimpala-double-values-not-getting-loaded-correctly%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
This is a problem of floating point versus fixed point arithmetic. If you want the decimal portion to be exact, use decimal
/numeric
for the column:
CREATE TABLE IF NOT EXISTS my_db.employee
name STRING,
salary DECIMAL(10, 2)
);
add a comment |
This is a problem of floating point versus fixed point arithmetic. If you want the decimal portion to be exact, use decimal
/numeric
for the column:
CREATE TABLE IF NOT EXISTS my_db.employee
name STRING,
salary DECIMAL(10, 2)
);
add a comment |
This is a problem of floating point versus fixed point arithmetic. If you want the decimal portion to be exact, use decimal
/numeric
for the column:
CREATE TABLE IF NOT EXISTS my_db.employee
name STRING,
salary DECIMAL(10, 2)
);
This is a problem of floating point versus fixed point arithmetic. If you want the decimal portion to be exact, use decimal
/numeric
for the column:
CREATE TABLE IF NOT EXISTS my_db.employee
name STRING,
salary DECIMAL(10, 2)
);
answered Nov 24 '18 at 1:44
Gordon LinoffGordon Linoff
765k35296400
765k35296400
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%2f53452064%2fimpala-double-values-not-getting-loaded-correctly%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