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 <[email protected]> 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 <[email protected]> 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 < >>> [email protected]> >>> 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 <[email protected]> wrote: >>>> >>>> Awesome! Thanks, Kaveen! >>>>> >>>>> Best, >>>>> Yingyi >>>>> >>>>> On Thu, Jun 16, 2016 at 9:56 AM, Kaveen Rodrigo < >>>>> >>>> [email protected] >>> >>>> 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 <[email protected]> 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 < >>>>>>> >>>>>> [email protected]> >>>>>> >>>>>>> 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* [email protected] | [email protected] >>>>>>>> >>>>>>>> >>>>>> >>>>>> -- >>>>>> 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* [email protected] | [email protected] >>>>>> >>>>>> >>>> >>>> -- >>>> 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* [email protected] | [email protected] >>>> >>>> >> >> >
