Re: new AsterixDB web interface demo up and running

[Till Westmann]

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