asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Carey <dtab...@gmail.com>
Subject Re: new AsterixDB web interface demo up and running
Date Fri, 17 Jun 2016 00:45:03 GMT
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 <dtabass@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 <buyingyi@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.rodrigo@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 <buyingyi@gmail.com> wrote:
>>>>>
>>>>> Awesome!  Thanks, Kaveen!
>>>>>> Best,
>>>>>> Yingyi
>>>>>>
>>>>>> On Thu, Jun 16, 2016 at 9:56 AM, Kaveen Rodrigo <
>>>>>>
>>>>> u.k.k.rodrigo@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 <buyingyi@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.rodrigo@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.2013175@iit.ac.lk | u.k.k.rodrigo@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.2013175@iit.ac.lk | u.k.k.rodrigo@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.2013175@iit.ac.lk | u.k.k.rodrigo@gmail.com
>>>>>
>>>>>
>>>


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message