You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@asterixdb.apache.org by Kaveen Rodrigo <u....@gmail.com> on 2016/06/16 07:20:32 UTC
new AsterixDB web interface demo up and running
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
Re: new AsterixDB web interface demo up and running
Posted by Kaveen Rodrigo <u....@gmail.com>.
Hey Mike,
unordered list , Since I'm parsing the data from the Asterix HTTP API which
returns results using JSON, therefore the JSON encoder at the sending end
has already converted the unordered list to JavaScript Array.
the thing with the existing UI is that UI's result is generated by the
servlet it's hosting the UI (see APIServlet.java), When I initially
discussed about the UI with Ian we wanted the new UI to work with the
Asterix HTTP API which holds the issue of not responding with a proper JSON.
On 17 June 2016 at 06:15, Mike Carey <dt...@gmail.com> 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 <dt...@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 <bu...@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 <bu...@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 <bu...@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
>>>>>>
>>>>>>
>>>>>>
>>>>
>
--
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
Re: new AsterixDB web interface demo up and running
Posted by Kaveen Rodrigo <u....@gmail.com>.
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 <ch...@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 <dt...@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 <bu...@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 <bu...@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 <bu...@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
> >>>>>>>
> >>>>>>>
> >>>>>
> >
>
--
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
Re: new AsterixDB web interface demo up and running
Posted by Chen Li <ch...@gmail.com>.
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 <dt...@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 <bu...@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 <bu...@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 <bu...@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
>>>>>>>
>>>>>>>
>>>>>
>
Re: new AsterixDB web interface demo up and running
Posted by Till Westmann <ti...@apache.org>.
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 <dt...@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 <bu...@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 <bu...@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 <bu...@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
>>>>>>
>>>>>>
>>>>
Re: new AsterixDB web interface demo up and running
Posted by Mike Carey <dt...@gmail.com>.
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 <dt...@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 <bu...@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 <bu...@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 <bu...@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
>>>>>
>>>>>
>>>
Re: new AsterixDB web interface demo up and running
Posted by Ian Maxon <im...@uci.edu>.
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 <dt...@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 <bu...@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 <bu...@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 <bu...@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
>>>>
>>>>
>>
>>
>
Re: new AsterixDB web interface demo up and running
Posted by Mike Carey <dt...@gmail.com>.
@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 <bu...@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....@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 <bu...@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 <bu...@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
>>>
>
>
Re: new AsterixDB web interface demo up and running
Posted by Kaveen Rodrigo <u....@gmail.com>.
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 <bu...@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....@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 <bu...@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 <bu...@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
> >
>
--
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
Re: new AsterixDB web interface demo up and running
Posted by Yingyi Bu <bu...@gmail.com>.
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....@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 <bu...@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 <bu...@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
>
Re: new AsterixDB web interface demo up and running
Posted by Kaveen Rodrigo <u....@gmail.com>.
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 <bu...@gmail.com> wrote:
> Awesome! Thanks, Kaveen!
>
> Best,
> Yingyi
>
> On Thu, Jun 16, 2016 at 9:56 AM, Kaveen Rodrigo <u....@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 <bu...@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
Re: new AsterixDB web interface demo up and running
Posted by Yingyi Bu <bu...@gmail.com>.
Awesome! Thanks, Kaveen!
Best,
Yingyi
On Thu, Jun 16, 2016 at 9:56 AM, Kaveen Rodrigo <u....@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 <bu...@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
>
Re: new AsterixDB web interface demo up and running
Posted by Kaveen Rodrigo <u....@gmail.com>.
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 <bu...@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....@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
Re: new AsterixDB web interface demo up and running
Posted by Yingyi Bu <bu...@gmail.com>.
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....@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
>