Re: new AsterixDB web interface demo up and running

[Mike Carey]

@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