Uploaded image for project: 'Sample Applications'
  1. Sample Applications
  2. APP-268

Improve "Zeppelin data analytics demo" demo/documentation

    XMLWordPrintable

    Details

    • Sprint:
      EVA Sprint 4
    • Known workaround:
      Hide

      No workaround is needed

      Show
      No workaround is needed

      Description

      When i have tested "Zeppelin data analytics demo" I have some problem with Cassandra integration. Demo description says that Cassandra Zeppelin interpreter supports only 2.2 or lower version of Cassandra.

      Consequently I have to downgrade the Kaa Sandbox Cassandra or make separate installation of the older version somewhere (e.g. local computer). It is not so hard - I found good manual for Cassandra 2.2.5 here: http://docs.kaaproject.org/display/KAA08x/Installation+guide and it works fine.

      But main trouble of this demo consist in necessity of some Cassandra initial data to successfully finish given demo examples:

      > CREATE KEYSPACE logs WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
      > use logs;
      > CREATE OR REPLACE FUNCTION logs.timeFormat(time bigint) RETURNS NULL ON NULL INPUT RETURNS text LANGUAGE java AS $$ return new java.text.SimpleDateFormat("mm:ss").format(new java.util.Date(time));$$;
      > CREATE OR REPLACE FUNCTION logs.timeDelta(arg bigint, delta bigint) RETURNS NULL ON NULL INPUT RETURNS bigint LANGUAGE java AS $$ return arg - delta;$$;
      

      ("logs" keyspace also needs tables "panel_per_row" and "zone_per_row", but they will be created automatically if you go to Kaa Admin UI and do empty-edit of both according appenders and click Save button)

      When I downgrade Cassandra inside Kaa Sandbox this data was lost.
      And I can't found how to restore it. I solve the issue only by asking one of developers to give me the "rescue" code that you can see above.

      *So it would be desirable to overcome this weak point of "Zeppelin data analytics demo".
      I suggest such alternatives:*

      1. (the most clear and simply-to-use) If possible, include in Kaa Sanbox standalone installation files for older Cassandra version (with pre-configured data for Zeppelin demo: functions and "logs" keyspace with needed tables) in addition to main active latest-version Cassandra installation. Include to demo description instructions how to temporarily launch older Cassandra version (and stop "main" Cassandra process if necessary).
      2. Add to demo description full instructions how to install Zeppelin-compatible Cassandra version (and properly setup Cassandra Zeppelin interpreter settings) and how to setup Cassandra initial data to run "Zeppelin data analytics demo" examples. Cassandra database initialization script (*.cql file) just can be included into demo's source code for simplicity.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              George Postolakiy George Postolakiy
              Reporter:
              Rib Andrey Rybachenko
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 7h
                  7h

                    Git Integration