Monday, June 18, 2012

Cassandra GUI 2.0 - Making things a little bit easier

Update (2014 October 31st)

You can download WSO2 Storage server  1.1.0 which ships Cassandra explorer and many interesting tools to manage storages. Please follow the following links for documentation to use Cassandra Explorer.

Download the product
https://docs.wso2.com/display/SS110/Downloading+the+Product

Extract the binary and run the product. (See "Starting the server" after extracting )
https://docs.wso2.com/display/SS110/Running+the+Product

Documentation about Explorer
https://docs.wso2.com/display/SS110/Explore+Cassandra+Cluster

========================================================================

Cassandra GUI evolved from its first version and new version includes bug fixes and enhanced features.

New features.

  • Complete pagination for Row view of explorer
  • Search rows by their names. (Filtered on the fly as you type.)
  • Filtering non displayable data and label them with warnings.

Bug Fixes

  • Remote connection problem
  • Connect to Remote Cassandra server without restarting the server.

Start the Server


Extract the downloaded product and lets refer extracted folder as CARBON_HOME.

go to CARBON_HOME/bin and run sh wso2server.sh (linux) or
wso2server.bat

Log in to the admin console using https://localhost:9443/
default user name and password : admin, admin

Following screen shots include a quick flow on how it works.


1) Click connect to cluster on right hand side panel. Give connection URL and credentials (if there is any) to connect.

eg: URL = localhost:9160,  or  10.100.3.234:

2) After a Successful connection you will be directed to keyspace listing page. Which will include Keyspaces and clickable column family names. Click on a Column Family to Explore data.




3) Row view Page.
After clicking the column family you have landed in the row view page. It includes rows of your column family and a slice of column data as a summary.

You can search, paginate or change no of items to filter your data. Click "view more" to explore a single row.



4) Column family view page will list all the columns in a single row. You can filter the data with column name,value or time stamp. full numbered pagination is available. 


Posted by at
Labels: , , , , ,

50 comments:

  1. hello,
    I installed your tools,
    I have two remarks:

    1) I can not change data in my keyspaces from this tool, this tool is that just serves to display the data, and not edit or delete them?!

    2) in our project was that data in XML format, and aparament your program, he interprets the XML into HTML, so, I not show my data correctly, but they maquent lot of things.

    voila comment il affiche le XML :

    1X00066655542 PF AFFECTE
    http://trunk.localhost/UTE/enveloppe/v2/1X00066655542 2012-08-03T10:18:50Z 25
    1X00066655542
    01 A12345 118512
    25A123452012-08-03T10:18:50.830Z2012-08-03T10:18:50ZAAAOOO
    2012-08-03T10:18:51Z

    thank you answer me and tell me how to solve these problems.

    ReplyDelete
    Replies

    1. Hi,
      Please find the answers below.
      1) Yes. This tool is only to view /explore the data (As of the current version.)

      2) It was a bug and it has been fixed (Had to escape XML special characters to avoid swallowing xml tags). If you are in urgency to add that patch i can provide you with the steps. Or else will share the released version soon.

      Thanks

      Delete

    2. Java Training Institutes Java Training Institutes
      Java Spring Hibernate Training Institutes in Chennai J2EE Training Institutes in Chennai J2EE Training Institutes in Chennai Java Spring Hibernate Training Institutes in Chennai | Hibernate Training Institutes in Chennai Core Java Training Institutes in Chennai Core Java Training Institutes in Chennai

      Hibernate Online Training Hibernate Online Training Hibernate Training in Chennai Hibernate Training in Chennai Java Online Training Java Online Training Hibernate Training Institutes in ChennaiHibernate Training Institutes in Chennai

      Delete

    3. Online JSF Training JSF Training Institutes in Chennai Java Training Institutes Java Training Institutes Struts2 Training Institutes in Chennai Struts2 Training Institutes in Chennai EJB Training Institutes in Chennai EJB Training Institutes in Chennai

      Delete

    4. I have read your blog its very attractive and impressive. I like it your blog.


      JavaEE Training in Chennai JavaEE Training in Chennai

      Java Training in Chennai Core Java Training in Chennai Core Java Training in Chennai

      Java Online Training Java Online Training Core Java 8 Training in Chennai Java 8 Training in Chennai

      Delete

  2. I get the following error while listing rows from a column family.

    DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.

    ReplyDelete
    Replies

    1. Have you kept the tool idle for a considerable time like 20 mints or more. Were there any error logs at the console. There is a bug that when session got timed out it does not give a proper warning. We will fix it soon. As a workaround you can login through the management console again and continue for the moment.

      Delete

    2. Hi!

      Thanks for the update.

      I've got the same error as muthu.v when I'm trying to browse a CF. I'm trying to open the CF just after loging in so it's not a timeout problem.

      We are using CompositeType in our CF, don't know if it could cause the problem ?

      Delete

  3. Hi, I'd like to use your GUI tool to access to the Cassandra. However, under Windows, when I run wso2server.bat, I got exception like this:

    java version "1.6.0_29"
    Java(TM) SE Runtime Environment (build 1.6.0_29-b11)
    Java HotSpot(TM) 64-Bit Server VM (build 20.4-b02, mixed mode)
    java version "1.6.0_29"
    Java(TM) SE Runtime Environment (build 1.6.0_29-b11)
    JAVA_HOME environment variable is set to C:\Program Files\Java\jdk1.6.0_29
    CARBON_HOME environment variable is set to C:\Program Files\wso2carbon-4.0.0-SNAPSHOT
    Exception in thread "main" java.lang.NoClassDefFoundError: Files\wso2carbon-4/0/0-SNAPSHOT\repository\conf\carbon/xml
    Caused by: java.lang.ClassNotFoundException: Files\wso2carbon-4.0.0-SNAPSHOT\repository\conf\carbon.xml
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
    Could not find the main class: Files\wso2carbon-4.0.0-SNAPSHOT\repository\conf\carbon.xml. Program will exit.

    Did I miss something? Or can you fix this issue? thanks a lot!

    ReplyDelete

  4. Hi Shelan,

    I was looking for simple readonly tool for cassandra data access. Thanks for this information.
    However I was getting same error:

    DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.

    We are storing data in JSON format for cassandra 1.0.7. I am trying with Carbon 4.0.0.

    ReplyDelete

  5. Hi all,

    JSON format error popping due to a limitation in the UI framework used. Whenever there is an exception it is not possible to send it to UI in a proper format, thus resulting this. You can have more details at the backend server log normally. Now Cassandra Explorer is a part of WSO2 BAM server. Can you try it and see if that resolves the problem. You can download it from here. http://wso2.com/products/business-activity-monitor/ . If the error persist could you please share if there are any errors logged at the console.

    ReplyDelete

  6. Hi Shelan, i was also getting same JSON data from server could not parsed error.
    Here are the errors from console:
    [2013-05-23 14:41:47,227] ERROR {org.apache.axis2.rpc.receivers.RPCMessageReceiver} - Cassandra encountered an internal error processing this request: TApplicationError type: 6 message:Internal error processing get_range_slices
    java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

    Caused by: me.prettyprint.hector.api.exceptions.HCassandraInternalException: Cassandra encountered an internal error processing this request: TApplicationError type: 6 message:Internal error processing get_range_slices
    at me.prettyprint.cassandra.service.ExceptionsTranslatorImpl.translate(ExceptionsTranslatorImpl.java:31)
    at me.prettyprint.cassandra.service.KeyspaceServiceImpl$3.execute(KeyspaceServiceImpl.java:163)
    at me.prettyprint.cassandra.service.KeyspaceServiceImpl$3.execute(KeyspaceServiceImpl.java:145)


    Thanks
    -Srinivas

    ReplyDelete

  7. org.apache.catalina.core.StandardWrapperValve invoke
    SEVERE: Servlet.service() for servlet [bridgeservlet] in context with path [/] threw exception [Exception in JSP: /cassandraexplorer/row_datatable_ajaxprocessor.jsp:90

    87: JSONArray valueArray = new JSONArray();
    88: valueArray.add(rows[i].getRowId());
    89: Column[] columns = rows[i].getColumns();
    90: for (int j = 0; j < rows[i].getColumns().length; j++) {
    91: valueArray.add(columns[j].getValue());
    92: }
    93: if (rows[i].getColumns().length < 3) {


    Stacktrace:] with root cause
    java.lang.NullPointerException
    at org.apache.jsp.cassandraexplorer.row_005fdatatable_005fajaxprocessor_jsp._jspService(row_005fdatatable_005fajaxprocessor_jsp.java:129)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:161)

    ReplyDelete

  8. hey I am using Cassandra 2.0.9 with CQL 3.1.1
    My problem is this tool show me the keyspaces present but not the ColumnFamilies (Tables) present in the keyspace.
    So pls help me.

    ReplyDelete

  9. Hi Shelan,
    I do see these errors whenever I start my 'defense4all' application & eventually the application stops running. I checked "cassandra.yaml" & I do see there is an entry for localhost:9160 as rpc address/port. Not sure what exactly I need to do (in cassandra) to make this work. I am able to run Cassandra successfully as foreground process.

    Error Logs:
    =======
    07:56:48,947 INFO [main][] - Host detected as down was added to retry queue: localhost(127.0.0.1):9160 me.prettyprint.cassandra.connection.CassandraHostRetryService.add(CassandraHostRetryService.java:57) [18 Sep]

    07:56:48,948 WARN [pool-1-thread-1][] - Downed localhost(127.0.0.1):9160 host still appears to be down: Unable to open transport to localhost(127.0.0.1):9160 , java.net.ConnectException: Connection refused

    thanks in advance,

    ReplyDelete

  10. I figured out the solution. Hope it helps other..
    In cassandra.yaml, we MUST set start_rpc = true (for me it was false).

    ReplyDelete

  12. Good article with excellent idea! I appreciate your post.Regards Sarkari Result

    ReplyDelete

  13. This Site is very essential for me. Because I have got many information from here.Thank You ..........
    Employment News in India

    ReplyDelete

  19. Hi Shelan,

    I am trying to run WSO2 Server Storage 1.5.0 in Windows 8.1
    and I am getting the error below,

    [2016-02-26 03:34:53,377] ERROR {org.apache.cassandra.service.CassandraDaemon} -
    Exception encountered during startup
    java.lang.NoClassDefFoundError: org/xerial/snappy/SnappyError
    at org.apache.cassandra.config.CFMetaData.(CFMetaData.java:82)
    at org.apache.cassandra.config.KSMetaData.systemKeyspace(KSMetaData.java
    :81)
    at org.apache.cassandra.config.DatabaseDescriptor.loadYaml(DatabaseDescr
    iptor.java:491)
    at org.apache.cassandra.config.DatabaseDescriptor.(DatabaseDescr
    iptor.java:132)
    at org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.ja
    va:216)
    at org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon
    .java:447)
    at org.wso2.carbon.cassandra.server.CassandraServerController$1.run(Cass
    andraServerController.java:46)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: java.lang.ClassNotFoundException: org.xerial.snappy.SnappyError
    at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(Bundl
    eLoader.java:501)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.
    java:421)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.
    java:412)
    at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(De
    faultClassLoader.java:107)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    ... 8 more
    java.lang.NoClassDefFoundError: org/xerial/snappy/SnappyError
    at org.apache.cassandra.config.CFMetaData.(CFMetaData.java:82)
    at org.apache.cassandra.config.KSMetaData.systemKeyspace(KSMetaData.java
    :81)
    at org.apache.cassandra.config.DatabaseDescriptor.loadYaml(DatabaseDescr
    iptor.java:491)
    at org.apache.cassandra.config.DatabaseDescriptor.(DatabaseDescr
    iptor.java:132)
    at org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.ja
    va:216)
    at org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon
    .java:447)
    at org.wso2.carbon.cassandra.server.CassandraServerController$1.run(Cass
    andraServerController.java:46)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: java.lang.ClassNotFoundException: org.xerial.snappy.SnappyError
    at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(Bundl
    eLoader.java:501)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.
    java:421)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.
    java:412)
    at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(De
    faultClassLoader.java:107)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    ... 8 more
    Exception encountered during startup: org/xerial/snappy/SnappyError

    I know the server has not been tested in Windows 8.1 so my issue could
    not has any solution but reading the stacktrace it seems that it could
    be a configuration question that I missed.

    Any idea or suggestion?

    Thanks a lot for your blog,

    Thanks in advance,
    Jose

    ReplyDelete

  20. Thanks for sharing with us that awesome article you have amazing blog........

    AP 10th Results 2016

    ReplyDelete

  25. Wishes are the best way to express you desire and happiness with your loved ones. Here we have the unique collection of Happy Deepawali 2016 wishes and Diwali 2016 greetings that you can use to wish your friends and family members an extremely great HAPPY DIWALI MESSAGES 2016.

    ReplyDelete

  29. 123freshers is one of the biggest Indian Job Site so here you will getBPO jobsso

    ReplyDelete

  31. Sarkari Recruitment is one of the biggest Indian Job Site so here you will getKarnataka govt jobs Latestso

    ReplyDelete

  34. nice blog.thanks for sharing with us for financial services in hyderabad click.
    Home Loans in Hyderabad

    ReplyDelete

  36. Here you can get the Union Public Service Commission (UPSC) latest recruitment notification and current examination details. For more click here
    UPSC Notification

    ReplyDelete

  37. Freelance Best Makeup & Hair Artist in Jaipur with huge experience and Specialization in Bridal and Wedding Makeup,Celebrity Makeup,Professional Makeup,Creative Makeup,Bollywood Makeup and Character Makeup in Delhi,Jaipur,Rajasthan. Natural Makeup that allows your skin to breath with a radiant glow and remains flawless throughout your special day.


    Best Makeup and Hairstyle in jaipur
    Fiza Makeup Academy in jaipur
    Best bridal makeup artist in jaipur(bollywood makeup,creative makeup,Airbrush makeup,character makeup)
    Make up and Hair kit
    Professional makeup artist course in jaipur
    Makeup and hairstyle tips
    Makeup and hair Images
    Makeup and hair tutorials
    Makeup and hair contract


    ReplyDelete

  38. IBPS SO Answer Key released. Get the complete information about IBPS SO Answer Key.
    download here

    ReplyDelete

  39. SBI PO Notification released. Get the latest information about SBI PO Exam Notification.
    SBI PO Recruitment

    ReplyDelete

  40. Check the Telangana ICET 2017 Exam Results now. To get the TS Integrated Common Entrance Test Rank Card 2017 click here.
    TSICET Results 2017

    ReplyDelete


  42. A Pioneer Institute owned by industry professionals to impart vibrant, innovative and global education in the field of Hospitality to bridge the gap of 40 lakh job vacancies in the Hospitality sector. The Institute is contributing to the creation of knowledge and offer quality program to equip students with skills to face the global market concerted effort by dedicated faculties, providing best learning environment in fulfilling the ambition to become a Leading Institute in India.

    cha jaipur
    management college in jaipur
    management of hospitality administration jaipur
    cha management jaipurs
    Hotel management in jaipur
    Best hotel college in jaipur
    Best management college in jaipur
    College of Hospitality Administration, Jaipur
    Top 10 hotel management in jaipur
    Hotel managementin Rajasthan





    ReplyDelete

  44. A Pioneer Institute owned by industry professionals to impart vibrant, innovative and global education in the field of Hospitality to bridge the gap of 40 lakh job vacancies in the Hospitality sector. The Institute is contributing to the creation of knowledge and offer quality program to equip students with skills to face the global market concerted effort by dedicated faculties, providing best learning environment in fulfilling the ambition to become a Leading Institute in India.

    cha jaipur
    hotel management college in jaipur
    management of hospitality administration jaipur
    cha management jaipur
    Hotel management in jaipur
    Best hotel management college in jaipur
    College of Hospitality Administration, Jaipur
    Top 10 hotel management in jaipur
    Hotel management collegein Rajasthan

    ReplyDelete

Subscribe to: Post Comments (Atom)