Impala double values not getting loaded correctly












0















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










share|improve this question





























    0















    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










    share|improve this question



























      0












      0








      0








      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










      share|improve this question
















      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






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 24 '18 at 1:43









      Gordon Linoff

      765k35296400




      765k35296400










      asked Nov 23 '18 at 19:29









      prasadprasad

      1818




      1818
























          1 Answer
          1






          active

          oldest

          votes


















          0














          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)
          );





          share|improve this answer























            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
            });


            }
            });














            draft saved

            draft discarded


















            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









            0














            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)
            );





            share|improve this answer




























              0














              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)
              );





              share|improve this answer


























                0












                0








                0







                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)
                );





                share|improve this answer













                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)
                );






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 24 '18 at 1:44









                Gordon LinoffGordon Linoff

                765k35296400




                765k35296400






























                    draft saved

                    draft discarded




















































                    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.




                    draft saved


                    draft discarded














                    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





















































                    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







                    Popular posts from this blog

                    Berounka

                    Sphinx de Gizeh

                    Different font size/position of beamer's navigation symbols template's content depending on regular/plain...