Hey Chen, I took down the demo, since my VPS was having some processing power issues, But you can try it out by by cloning my fork and checking out the branch asterixdb-1375-static-servlet
https://github.com/KaveenR/incubator-asterixdb/commits/asterixdb-1375-static-servlet cheers, Kaveen On 13 July 2016 at 03:29, Chen Li <che...@gmail.com> wrote: > This is an old discussion. The URL http://173.82.2.197:19006/ doesn't > work for me now. I assume it's no longer available. Is there any way > to see the new UI? > > Chen > > On Fri, Jun 17, 2016 at 12:10 AM, Till Westmann <ti...@apache.org> wrote: > > Results for multiple queries are not that easy for the new HTTP API > design > > [1] that we’re trying to finish right now. For that design we’re > planning to > > have many statements, but to only return the result of the last > statement. > > The challenge with multiple results is that the newer API also returns > quite > > a bit of metadata (errors, metrics, signature) which would also need to > be > > available in multiples and complicate the structure of the result > further. > > > > Cheers, > > Till > > > > [1] > > > https://cwiki.apache.org/confluence/display/ASTERIXDB/New+HTTP+API+Design > > > > > > On 17 Jun 2016, at 2:45, Mike Carey wrote: > > > >> Sounds like a bug in the underlying http UI?! It would be nice to > >> preserve the multiple-result-area approach that the existing web UI > uses in > >> that case, somehow... It's interesting that this hasn't come up before > - we > >> should have test cases for the basic UI for that, I would think? > >> > >> > >> On 6/16/16 5:24 PM, Ian Maxon wrote: > >>> > >>> Kaveen and I talked about this earlier today actually, the result (from > >>> *DB) for the two above queries is actually fine and parseable JSON. > It's > >>> just a labeling issue as the result is shown as if it were 3 records > >>> rather > >>> than 3 lists. > >>> A more vexing question however that came up is what to do about > multiple > >>> queries in one submission. Right now those come back as multiple JSON > >>> objects appended to each other apparently. > >>> > >>> On Thu, Jun 16, 2016 at 5:14 PM, Mike Carey <dtab...@gmail.com> wrote: > >>> > >>>> @Ian & @Chris: Can you provide some helpful hints in the direction of > >>>> parsing returned ADM? (Since you are kind of addressing that as we > >>>> speak > >>>> for other reasons?) > >>>> > >>>> @Kaveen: Off to a cool start! In terms of the sorts of things that > can > >>>> come back, *conceptually*, the return clause of a query can yield a > >>>> scalar > >>>> value, an ordered list, an unordered list, or a record. (The various > >>>> possible scalar values are all of the data types listed in the ADM > data > >>>> model spec.) A for-clause actually always returns a list of whatever > >>>> the > >>>> return clause says to return - and a let-clause (I believe) or a > >>>> standalone > >>>> expression can return a singleton object (of any of the aforementioned > >>>> forms) if I'm not mistaken. For testing the Web UI, it would probably > >>>> be > >>>> worth coming up with a set of test queries that returns each of those > >>>> things. (Mixed of them are also possible - life in semistructured > data > >>>> land can be messy.) > >>>> > >>>> Cheers, > >>>> > >>>> Mike > >>>> > >>>> > >>>> On 6/16/16 11:11 AM, Kaveen Rodrigo wrote: > >>>> > >>>>> oh I see, Thank you Yingyi, > >>>>> > >>>>> I did update the VPS with the fixes for Q1, the only way to fix Q2 > and > >>>>> the > >>>>> new query is to write a little parser since that output isn't valid > >>>>> json. > >>>>> > >>>>> cheers, > >>>>> Kaveen > >>>>> > >>>>> On 16 June 2016 at 22:59, Yingyi Bu <buyin...@gmail.com> wrote: > >>>>> > >>>>> Any valid ADM (asterix data model) instance can be a result row. > >>>>>> > >>>>>> ADM: https://ci.apache.org/projects/asterixdb/aql/datamodel.html > >>>>>> > >>>>>> A single curly bracket means a record constructor. A record > consists > >>>>>> of > >>>>>> fields, where each field is an name-value pair. > >>>>>> Therefore, > >>>>>> { > >>>>>> [1,2,3], > >>>>>> [2,3,4], > >>>>>> [5,6,7] > >>>>>> } > >>>>>> cannot be a valid result. > >>>>>> > >>>>>> But you are able to get > >>>>>> [1,2,3], > >>>>>> [2,3,4], > >>>>>> [5,6,7] > >>>>>> > >>>>>> by running the following query: > >>>>>> > >>>>>> for $x in [ > >>>>>> [1,2,3], > >>>>>> [2,3,4], > >>>>>> [5,6,7] > >>>>>> ] > >>>>>> return $x; > >>>>>> > >>>>>> Let me know if you have more questions. > >>>>>> > >>>>>> Best, > >>>>>> Yingyi > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> On Thu, Jun 16, 2016 at 10:23 AM, Kaveen Rodrigo < > >>>>>> u.k.k.rodr...@gmail.com> > >>>>>> wrote: > >>>>>> > >>>>>> Hey Yingyi, > >>>>>>> > >>>>>>> I fixed that issue, didn't update the VPS yet. One question Can > >>>>>>> there > >>>>>>> be > >>>>>>> results which returns arrays? > >>>>>>> > >>>>>>> for example > >>>>>>> { > >>>>>>> [1,2,3], > >>>>>>> [2,3,4], > >>>>>>> [5,6,7] > >>>>>>> } > >>>>>>> > >>>>>>> if that's so, if you have some time can you give me an AQl query > >>>>>>> which > >>>>>>> will produce something like that. > >>>>>>> > >>>>>>> thanks in advance, > >>>>>>> Kaveen > >>>>>>> > >>>>>>> On 16 June 2016 at 22:28, Yingyi Bu <buyin...@gmail.com> wrote: > >>>>>>> > >>>>>>> Awesome! Thanks, Kaveen! > >>>>>>>> > >>>>>>>> Best, > >>>>>>>> Yingyi > >>>>>>>> > >>>>>>>> On Thu, Jun 16, 2016 at 9:56 AM, Kaveen Rodrigo < > >>>>>>>> > >>>>>>> u.k.k.rodr...@gmail.com > >>>>>>> wrote: > >>>>>>>> > >>>>>>>> Yikes, Thanks Yingyi, > >>>>>>>>> > >>>>>>>>> I never expected the results array to contain values, I'll get on > >>>>>>>>> it > >>>>>>>>> > >>>>>>>>> On 16 June 2016 at 21:48, Yingyi Bu <buyin...@gmail.com> wrote: > >>>>>>>>> > >>>>>>>>> Very cool!! > >>>>>>>>>> > >>>>>>>>>> It seems that there is an assumption that returned results are > >>>>>>>>>> > >>>>>>>>> records? > >>>>>>>> > >>>>>>>> For example, you can try the following query: > >>>>>>>>>> > >>>>>>>>>> Q1: > >>>>>>>>>> for $m in dataset Metadata.Dataset > >>>>>>>>>> return $m.DatasetName; > >>>>>>>>>> > >>>>>>>>>> Q2: > >>>>>>>>>> 1+1; > >>>>>>>>>> > >>>>>>>>>> Best, > >>>>>>>>>> Yingyi > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> On Thu, Jun 16, 2016 at 12:20 AM, Kaveen Rodrigo < > >>>>>>>>>> > >>>>>>>>> u.k.k.rodr...@gmail.com> > >>>>>>>>> > >>>>>>>>>> wrote: > >>>>>>>>>> > >>>>>>>>>> Hello all, > >>>>>>>>>>> > >>>>>>>>>>> I have been working on the WebUI for AsterixDB during the last > >>>>>>>>>>> > >>>>>>>>>> month, > >>>>>>>> > >>>>>>>> and I > >>>>>>>>>>> > >>>>>>>>>>> would like to get some input from you guys. There are a couple > of > >>>>>>>>>>> > >>>>>>>>>> visual > >>>>>>>>>> tweaks to be applied but the base features are pretty much done. > >>>>>>>>>>> > >>>>>>>>>>> http://173.82.2.197:19006/ > >>>>>>>>>>> > >>>>>>>>>>> please excuse the slow performance of my docker instance, If > you > >>>>>>>>>>> > >>>>>>>>>> want > >>>>>>>> > >>>>>>>> to > >>>>>>>>>> > >>>>>>>>>> check this out locally, It's available here > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>> > >>>>>> > https://github.com/KaveenR/incubator-asterixdb/commits/asterixdb-1375-static-servlet > >>>>>> > >>>>>>> cheers, > >>>>>>>>>>> > >>>>>>>>>>> Kaveen Rodrigo > >>>>>>>>>>> > >>>>>>>>>>> -- > >>>>>>>>>>> Kaveen Rodrigo > >>>>>>>>>>> Personal Website - (lifeofenigma.com) > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> Software Engineering Undergraduate, > >>>>>>>>>>> Informatics Institute of Technology Sri Lanka (Affiliated with > >>>>>>>>>>> > >>>>>>>>>> University > >>>>>>>>>> of Westminster, UK) > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> *Contact Information* > >>>>>>>>>>> > >>>>>>>>>>> *Mobile* +94779684740 > >>>>>>>>>>> > >>>>>>>>>>> *E-Mail* kaveen.2013...@iit.ac.lk | u.k.k.rodr...@gmail.com > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>> -- > >>>>>>>>> Kaveen Rodrigo > >>>>>>>>> Personal Website - (lifeofenigma.com) > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> Software Engineering Undergraduate, > >>>>>>>>> Informatics Institute of Technology Sri Lanka (Affiliated with > >>>>>>>>> > >>>>>>>> University > >>>>>>>> of Westminster, UK) > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> *Contact Information* > >>>>>>>>> > >>>>>>>>> *Mobile* +94779684740 > >>>>>>>>> > >>>>>>>>> *E-Mail* kaveen.2013...@iit.ac.lk | u.k.k.rodr...@gmail.com > >>>>>>>>> > >>>>>>>>> > >>>>>>> -- > >>>>>>> Kaveen Rodrigo > >>>>>>> Personal Website - (lifeofenigma.com) > >>>>>>> > >>>>>>> > >>>>>>> Software Engineering Undergraduate, > >>>>>>> Informatics Institute of Technology Sri Lanka (Affiliated with > >>>>>>> University > >>>>>>> of Westminster, UK) > >>>>>>> > >>>>>>> > >>>>>>> *Contact Information* > >>>>>>> > >>>>>>> *Mobile* +94779684740 > >>>>>>> > >>>>>>> *E-Mail* kaveen.2013...@iit.ac.lk | u.k.k.rodr...@gmail.com > >>>>>>> > >>>>>>> > >>>>> > > > -- Kaveen Rodrigo Personal Website - (lifeofenigma.com) Software Engineering Undergraduate, Informatics Institute of Technology Sri Lanka (Affiliated with University of Westminster, UK) *Contact Information* *Mobile* +94779684740 *E-Mail* kaveen.2013...@iit.ac.lk | u.k.k.rodr...@gmail.com