Run multi sql command in the same zeppelin paragraph












0















Hello I have 3 tmpViews I want to show these views in the same zeppelin scatter dashboard I m using Spark interpreter I want to get each view with a color (i.e point of the same view have the same color)
I tried



     %spark
z.show(sql("select valrx, valry from MemArb "))
z.show(sql("select valx , valry from VoisArb "))
z.show(sql("select valrx , valry from VoisArb2 "))


but it gives me only the first view



is there any solution?
thanks in advance










share|improve this question





























    0















    Hello I have 3 tmpViews I want to show these views in the same zeppelin scatter dashboard I m using Spark interpreter I want to get each view with a color (i.e point of the same view have the same color)
    I tried



         %spark
    z.show(sql("select valrx, valry from MemArb "))
    z.show(sql("select valx , valry from VoisArb "))
    z.show(sql("select valrx , valry from VoisArb2 "))


    but it gives me only the first view



    is there any solution?
    thanks in advance










    share|improve this question



























      0












      0








      0








      Hello I have 3 tmpViews I want to show these views in the same zeppelin scatter dashboard I m using Spark interpreter I want to get each view with a color (i.e point of the same view have the same color)
      I tried



           %spark
      z.show(sql("select valrx, valry from MemArb "))
      z.show(sql("select valx , valry from VoisArb "))
      z.show(sql("select valrx , valry from VoisArb2 "))


      but it gives me only the first view



      is there any solution?
      thanks in advance










      share|improve this question
















      Hello I have 3 tmpViews I want to show these views in the same zeppelin scatter dashboard I m using Spark interpreter I want to get each view with a color (i.e point of the same view have the same color)
      I tried



           %spark
      z.show(sql("select valrx, valry from MemArb "))
      z.show(sql("select valx , valry from VoisArb "))
      z.show(sql("select valrx , valry from VoisArb2 "))


      but it gives me only the first view



      is there any solution?
      thanks in advance







      apache-zeppelin






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 14 '18 at 0:42









      Max Belousov

      18918




      18918










      asked Nov 7 '18 at 11:14









      ChaoukiChaouki

      7611




      7611
























          2 Answers
          2






          active

          oldest

          votes


















          0














          Zeppelin 08.0 support to show multiple dataframe in one paragraph, but regarding different colors, it is not supported yet. I'm afraid you need to use other solutions, like using python plot libraries.






          share|improve this answer
























          • Thank u for your response, I can't change the default colors from " zeppelin-0.7.3-bin-allwebappswebappscripts"?

            – Chaouki
            Nov 12 '18 at 9:34



















          0














          You can print result to table display system.



          Begin with '%table ' and then print to csv with separator equals 't'






          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%2f53188377%2frun-multi-sql-command-in-the-same-zeppelin-paragraph%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            Zeppelin 08.0 support to show multiple dataframe in one paragraph, but regarding different colors, it is not supported yet. I'm afraid you need to use other solutions, like using python plot libraries.






            share|improve this answer
























            • Thank u for your response, I can't change the default colors from " zeppelin-0.7.3-bin-allwebappswebappscripts"?

              – Chaouki
              Nov 12 '18 at 9:34
















            0














            Zeppelin 08.0 support to show multiple dataframe in one paragraph, but regarding different colors, it is not supported yet. I'm afraid you need to use other solutions, like using python plot libraries.






            share|improve this answer
























            • Thank u for your response, I can't change the default colors from " zeppelin-0.7.3-bin-allwebappswebappscripts"?

              – Chaouki
              Nov 12 '18 at 9:34














            0












            0








            0







            Zeppelin 08.0 support to show multiple dataframe in one paragraph, but regarding different colors, it is not supported yet. I'm afraid you need to use other solutions, like using python plot libraries.






            share|improve this answer













            Zeppelin 08.0 support to show multiple dataframe in one paragraph, but regarding different colors, it is not supported yet. I'm afraid you need to use other solutions, like using python plot libraries.







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Nov 9 '18 at 13:08









            zjffduzjffdu

            6,6222579107




            6,6222579107













            • Thank u for your response, I can't change the default colors from " zeppelin-0.7.3-bin-allwebappswebappscripts"?

              – Chaouki
              Nov 12 '18 at 9:34



















            • Thank u for your response, I can't change the default colors from " zeppelin-0.7.3-bin-allwebappswebappscripts"?

              – Chaouki
              Nov 12 '18 at 9:34

















            Thank u for your response, I can't change the default colors from " zeppelin-0.7.3-bin-allwebappswebappscripts"?

            – Chaouki
            Nov 12 '18 at 9:34





            Thank u for your response, I can't change the default colors from " zeppelin-0.7.3-bin-allwebappswebappscripts"?

            – Chaouki
            Nov 12 '18 at 9:34













            0














            You can print result to table display system.



            Begin with '%table ' and then print to csv with separator equals 't'






            share|improve this answer




























              0














              You can print result to table display system.



              Begin with '%table ' and then print to csv with separator equals 't'






              share|improve this answer


























                0












                0








                0







                You can print result to table display system.



                Begin with '%table ' and then print to csv with separator equals 't'






                share|improve this answer













                You can print result to table display system.



                Begin with '%table ' and then print to csv with separator equals 't'







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 14 '18 at 18:58









                Max BelousovMax Belousov

                18918




                18918






























                    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%2f53188377%2frun-multi-sql-command-in-the-same-zeppelin-paragraph%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

                    Bressuire

                    Vorschmack

                    Quarantine