Details

      Description

      The web-based query interface allows a user to execute a query from a web browser and get the result. The interface should support giving the user additional details and statistics about the query. The command line interface provides theses details. The web interface will need to connect to the RESTful api and report these to the user. The specific details include: the abstract syntax tree, logical plan, optimized plan, job details, and query statistics.
      The web interface will present these items in an easy to read format that is pleasing to the eye.

      Key tasks:

      • Create a web-based query interface.
      • Present the user with options for receiving additional query details and statistics
      • Tasteful display the result of the query and additional query details

        Issue Links

          Activity

          Hide
          prestonc Preston Carman added a comment -

          The RESTful API needs to be created first.

          Show
          prestonc Preston Carman added a comment - The RESTful API needs to be created first.
          Hide
          dilshanp Dilshan Pathirana added a comment -

          Hi , I'm Dilshan Pathirana a final year undergraduate from Faculty of Engineering, University of Moratuwa, Sri Lanka.I m currently following the course "Computer Science and engineering"

          I 'm interested doing this project as my gsoc project for year 2016.I have a good knowledge in REST APIs, Java,html,javaScript,CSS and databases.I have work with several rest api s in my internship such as the REST api used in elastic search

          Thankyou

          Show
          dilshanp Dilshan Pathirana added a comment - Hi , I'm Dilshan Pathirana a final year undergraduate from Faculty of Engineering, University of Moratuwa, Sri Lanka.I m currently following the course "Computer Science and engineering" I 'm interested doing this project as my gsoc project for year 2016.I have a good knowledge in REST APIs, Java,html,javaScript,CSS and databases.I have work with several rest api s in my internship such as the REST api used in elastic search Thankyou
          Hide
          dilankamr91 Dilanka Rathnayake added a comment -

          Hi,

          I am Dilanka Rathnayake, final year undergraduate student of Department of Computer Engineering, Faculty of Engineering, University of Peradeniya, Sri Lanka.

          I went through the all the project ideas that have been published by 'Apache Foundation' and I think 'Web-base Query Interface' project is more suitable according to the knowledge that i have acquired during my undergraduate courses and the experience gained by doing various projects in my internship program. And also i strongly believe that this would be more beneficial to my future carrier development as well.

          Furthermore I have very good knowledge about Restful APIs, Spring, Struts2, Hibernate, HTML, JavaScript/AngularJs, CSS/Bootstrap.

          And also i went through the following areas to get more familiar with the 'VXQuery'. So that it would help to adept to the project to be done.

          • Subscribed the 'VXQuery Community' dev mailing list.
          • Went through the posted mails and got a brief idea about the 'VXQuery'.
          • Downloaded and installed 'VXQuery'.
          • Executed a small query using 'VXQuery'.
          • Started to study about XQuery Tutorial on http://www.w3schools.com/ and from other various resources.
          • Cloned 'VXQuery Code Base' setup it in eclipse and analyzed it.

          Please be kind enough to provide more details about the project and i really appreciate your cooperation on this matter.

          Best Regards,
          Dilanka Rathnayake.

          Show
          dilankamr91 Dilanka Rathnayake added a comment - Hi, I am Dilanka Rathnayake, final year undergraduate student of Department of Computer Engineering, Faculty of Engineering, University of Peradeniya, Sri Lanka. I went through the all the project ideas that have been published by 'Apache Foundation' and I think 'Web-base Query Interface' project is more suitable according to the knowledge that i have acquired during my undergraduate courses and the experience gained by doing various projects in my internship program. And also i strongly believe that this would be more beneficial to my future carrier development as well. Furthermore I have very good knowledge about Restful APIs, Spring, Struts2, Hibernate, HTML, JavaScript/AngularJs, CSS/Bootstrap. And also i went through the following areas to get more familiar with the 'VXQuery'. So that it would help to adept to the project to be done. Subscribed the 'VXQuery Community' dev mailing list. Went through the posted mails and got a brief idea about the 'VXQuery'. Downloaded and installed 'VXQuery'. Executed a small query using 'VXQuery'. Started to study about XQuery Tutorial on http://www.w3schools.com/ and from other various resources. Cloned 'VXQuery Code Base' setup it in eclipse and analyzed it. Please be kind enough to provide more details about the project and i really appreciate your cooperation on this matter. Best Regards, Dilanka Rathnayake.
          Hide
          prestonc Preston Carman added a comment -

          Dilanka,

          You have got through all the basic steps. Next I would suggest doing one of two things:

          • pick a starter issue and submit a patch
            or
          • give some feedback on the wiki about the web-based query interface

          Preston

          Show
          prestonc Preston Carman added a comment - Dilanka, You have got through all the basic steps. Next I would suggest doing one of two things: pick a starter issue and submit a patch or give some feedback on the wiki about the web-based query interface Preston
          Hide
          dilankamr91 Dilanka Rathnayake added a comment -

          Hi Preston,

          As you recommended earlier I created a simple RESTful API. I used the functions in vxquery-cli for that implementation. Even though I tried to get a result for a given query using that, I am getting an error as follows:
          "org.apache.hyracks.api.exceptions.HyracksException: Job failed on account of: org.apache.hyracks.api.exceptions.HyracksDataException: org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: org.apache.vxquery.exceptions.SystemException: SYSE0001:".

          I will submit the code as soon as I fixed the error.

          I already visited the wiki page (https://cwiki.apache.org/confluence/display/VXQUERY/Web-base+User+Interface). I was unable to add a comment/feedback as there is no comment box like in other projects on wiki page. Do I need any special permission or is it not the way you have suggested?

          Best Regards,
          Dilanka Rathnayake.

          Show
          dilankamr91 Dilanka Rathnayake added a comment - Hi Preston, As you recommended earlier I created a simple RESTful API. I used the functions in vxquery-cli for that implementation. Even though I tried to get a result for a given query using that, I am getting an error as follows: "org.apache.hyracks.api.exceptions.HyracksException: Job failed on account of: org.apache.hyracks.api.exceptions.HyracksDataException: org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: org.apache.vxquery.exceptions.SystemException: SYSE0001:". I will submit the code as soon as I fixed the error. I already visited the wiki page ( https://cwiki.apache.org/confluence/display/VXQUERY/Web-base+User+Interface ). I was unable to add a comment/feedback as there is no comment box like in other projects on wiki page. Do I need any special permission or is it not the way you have suggested? Best Regards, Dilanka Rathnayake.
          Hide
          prestonc Preston Carman added a comment -

          Just realized I have not responded to each individual posting about this GSOC idea. A student will be picked for this project based on their GSOC application. The discussion here should help your application but is not the only thing we consider. The ASF must balance applications for many projects and this is one of them. We are excited about all the interest and look forward to seeing your proposals.

          That being said, I wanted to review some of the preparation steps:

          • Go through the developer starter page [1]
          • Review the wiki page with more details about the UI and Spec [2]
          • Post questions and suggestions to project (Join the community discussion)
          • (Optional) Pick a starter issue and post a patch to fix the issue. (VXQUERY-139 looks like a related issue.) [3]

          [1] http://vxquery.apache.org/developer_get_started.html
          [2] https://cwiki.apache.org/confluence/display/VXQUERY/Web-base+User+Interface
          [3] https://issues.apache.org/jira/browse/VXQUERY-19?jql=project%20%3D%20VXQUERY%20AND%20resolution%20%3D%20Unresolved%20AND%20labels%20%3D%20starter%20ORDER%20BY%20priority%20DESC

          Show
          prestonc Preston Carman added a comment - Just realized I have not responded to each individual posting about this GSOC idea. A student will be picked for this project based on their GSOC application. The discussion here should help your application but is not the only thing we consider. The ASF must balance applications for many projects and this is one of them. We are excited about all the interest and look forward to seeing your proposals. That being said, I wanted to review some of the preparation steps: Go through the developer starter page [1] Review the wiki page with more details about the UI and Spec [2] Post questions and suggestions to project (Join the community discussion) (Optional) Pick a starter issue and post a patch to fix the issue. ( VXQUERY-139 looks like a related issue.) [3] [1] http://vxquery.apache.org/developer_get_started.html [2] https://cwiki.apache.org/confluence/display/VXQUERY/Web-base+User+Interface [3] https://issues.apache.org/jira/browse/VXQUERY-19?jql=project%20%3D%20VXQUERY%20AND%20resolution%20%3D%20Unresolved%20AND%20labels%20%3D%20starter%20ORDER%20BY%20priority%20DESC
          Hide
          ankitladhania Ankit Ladhania added a comment -

          Hi Preston,
          I'm a final year student pursuing Bachelors in Computer Science and Engineering from Indian School of Mines (IIT), Dhanbad.

          I have studied and analyzed VXQuery and I think I would be a good fit for project based on the prior experiences in Amazon, WebEngage and many other projects. I'm a Full-Stack Developer with expertise in Java and Javascript (Node.js)

          I have few queries regarding the project. Should I discuss them in the mailing list or should I post them here ?

          One of the query : the AST of the query is given in the form of text through present system and there is no other way to extract it. Can I make few changes in the Core to get it in desired format ?

          Regards,
          Ankit

          Show
          ankitladhania Ankit Ladhania added a comment - Hi Preston, I'm a final year student pursuing Bachelors in Computer Science and Engineering from Indian School of Mines (IIT), Dhanbad. I have studied and analyzed VXQuery and I think I would be a good fit for project based on the prior experiences in Amazon, WebEngage and many other projects. I'm a Full-Stack Developer with expertise in Java and Javascript (Node.js) I have few queries regarding the project. Should I discuss them in the mailing list or should I post them here ? One of the query : the AST of the query is given in the form of text through present system and there is no other way to extract it. Can I make few changes in the Core to get it in desired format ? Regards, Ankit
          Hide
          prestonc Preston Carman added a comment -

          Lets collect all our comments about this issue on the wiki. If you don't have access, post your username so we can add you to the authorized list.

          As for the results you need to return (AST, result, etc.), the API will need to accomplish two tasks. First would be to collect all the values that need to be returned to the client. Second, would be to consider the format that those results are returned. Both of these ideas can be discussed. At first, I think I would just keep the format of the AST as is and return it as a string. After this process is working, I would then look at improving the formatting to allow for better UI display of the AST. Does this make sense?

          Show
          prestonc Preston Carman added a comment - Lets collect all our comments about this issue on the wiki. If you don't have access, post your username so we can add you to the authorized list. As for the results you need to return (AST, result, etc.), the API will need to accomplish two tasks. First would be to collect all the values that need to be returned to the client. Second, would be to consider the format that those results are returned. Both of these ideas can be discussed. At first, I think I would just keep the format of the AST as is and return it as a string. After this process is working, I would then look at improving the formatting to allow for better UI display of the AST. Does this make sense?
          Hide
          ankitladhania Ankit Ladhania added a comment - - edited

          I dont have access to edit the wiki. My username is : ankitladhania

          -Ankit

          Show
          ankitladhania Ankit Ladhania added a comment - - edited I dont have access to edit the wiki. My username is : ankitladhania -Ankit
          Hide
          tillw Till added a comment -

          You should have access now.

          Show
          tillw Till added a comment - You should have access now.
          Hide
          ankitladhania Ankit Ladhania added a comment -

          Makes complete sense to me. I have added a FAQ section in the wiki.
          Please try to respond to my other queries asked in the mailing list.

          -Ankit

          Show
          ankitladhania Ankit Ladhania added a comment - Makes complete sense to me. I have added a FAQ section in the wiki. Please try to respond to my other queries asked in the mailing list. -Ankit
          Hide
          EnigmaMaker Kaveen Rodirgo added a comment - - edited

          Hello,

          Little introduction on me, I'm Kaveen Rodrigo, second year Software Engineering undergraduate in Informatics Institute Of Technology, Sri Lanka affiliated with University Of Westminster UK.

          After browsing the Apache JIRA for a while I came to the conclusion that this project is well suited for my caliber. Web design / development and mobile development is what I'm passionate on. With various university and freelance projects I have learned and used technologies which will help to make the project a success.

          Some Technologies I'm familiar in relevance to this project : XQuery, Swagger, Git, highlight.js (syntax highliting), HTML CSS UI/UX, Angular JS, JavaScript and Bootstrap.

          After reading the wiki page of this project and VXQUERY-180 and I compiled a stub-server using swagger with the provided YAML[1] with this stub-server I tested and prototyped the Web-interface with the given UI guidelines[2]

          I'm keen on this project and would like to contribute and make this happen.
          cheers,
          Kaveen Rodrigo

          references
          [1] https://cwiki.apache.org/confluence/display/VXQUERY/SwaggerIO+Configuration
          [2] https://docs.google.com/presentation/d/1F1yAaibTAuymG99UV-kuDcd1rGPBWzTZ4vt6TlQzihs/edit#slide=id.g11a78e3fc1_0_17

          Show
          EnigmaMaker Kaveen Rodirgo added a comment - - edited Hello, Little introduction on me, I'm Kaveen Rodrigo, second year Software Engineering undergraduate in Informatics Institute Of Technology, Sri Lanka affiliated with University Of Westminster UK. After browsing the Apache JIRA for a while I came to the conclusion that this project is well suited for my caliber. Web design / development and mobile development is what I'm passionate on. With various university and freelance projects I have learned and used technologies which will help to make the project a success. Some Technologies I'm familiar in relevance to this project : XQuery, Swagger, Git, highlight.js (syntax highliting), HTML CSS UI/UX, Angular JS, JavaScript and Bootstrap. After reading the wiki page of this project and VXQUERY-180 and I compiled a stub-server using swagger with the provided YAML [1] with this stub-server I tested and prototyped the Web-interface with the given UI guidelines [2] I'm keen on this project and would like to contribute and make this happen. cheers, Kaveen Rodrigo references [1] https://cwiki.apache.org/confluence/display/VXQUERY/SwaggerIO+Configuration [2] https://docs.google.com/presentation/d/1F1yAaibTAuymG99UV-kuDcd1rGPBWzTZ4vt6TlQzihs/edit#slide=id.g11a78e3fc1_0_17
          Hide
          tillw Till added a comment - - edited

          Hi Kaveen,

          thank you for your interest.
          I assume that you would like to work on this project in the context of GSoC. Is that right?
          If so, it would be good if you could provide a more detailed proposal for the project that can then be discussed and evaluated in the GSoC proposal selection phase. Of course you are more than welcome to discuss the proposal with the community until March 25 (when the student application period ends).
          Also, you might want to look a little more into the project (if you didn't do this so far) to understand the context and the dependencies a little better to enable you to write a stronger proposal.

          Cheers,
          Till

          Show
          tillw Till added a comment - - edited Hi Kaveen, thank you for your interest. I assume that you would like to work on this project in the context of GSoC. Is that right? If so, it would be good if you could provide a more detailed proposal for the project that can then be discussed and evaluated in the GSoC proposal selection phase. Of course you are more than welcome to discuss the proposal with the community until March 25 (when the student application period ends). Also, you might want to look a little more into the project (if you didn't do this so far) to understand the context and the dependencies a little better to enable you to write a stronger proposal. Cheers, Till
          Hide
          EnigmaMaker Kaveen Rodirgo added a comment -

          Hello,

          Thank you for the feedback.I submitted a draft proposal to Thee GSoC portal, waiting for feedback.

          cheers,
          Kaveen Rodrigo

          Show
          EnigmaMaker Kaveen Rodirgo added a comment - Hello, Thank you for the feedback.I submitted a draft proposal to Thee GSoC portal, waiting for feedback. cheers, Kaveen Rodrigo

            People

            • Assignee:
              Unassigned
              Reporter:
              prestonc Preston Carman
            • Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

              • Created:
                Updated:

                Development