Re: new AsterixDB web interface demo up and running

2016-06-16 Thread Kaveen Rodrigo
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 serv

Re: new AsterixDB web interface demo up and running

2016-06-16 Thread Mike Carey
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/

Re: Unsigned integers data types

2016-06-16 Thread Mike Carey
There are some newer scalar data types that we support that might be useful for at least some "unsigned integer use cases" - namely, the binary type (which is like strings but is just bits). On 6/16/16 4:10 PM, Ildar Absalyamov wrote: I guess my point was not to use unsigned integers int the

Re: new AsterixDB web interface demo up and running

2016-06-16 Thread Ian Maxon
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

Re: AsterixDB build now requires Maven 3.3.9

2016-06-16 Thread Chris Hillery
FYI, my email in the past about upgrading Maven on Ubuntu no longer works for 3.3.9. I've found another PPA: https://launchpad.net/~andrei-pozolotin/+archive/ubuntu/maven3 Request: In the future, can we have announcements to the list and discussion at least a few days *before* committing changes

Re: new AsterixDB web interface demo up and running

2016-06-16 Thread 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

Re: Unsigned integers data types

2016-06-16 Thread Ildar Absalyamov
I guess my point was not to use unsigned integers int the case when int64 is not enough, but to allow using say uint32 instead of int64. > On Jun 16, 2016, at 16:03, Ian Maxon wrote: > > My 0.2c is that int64 is big enough if size was the consideration. Usually, > the times that I have wished I

Re: Unsigned integers data types

2016-06-16 Thread Ian Maxon
My 0.2c is that int64 is big enough if size was the consideration. Usually, the times that I have wished I had unsigned integers in Java, were not related to size constraints, but rather when I had to implement something that required a lot of bitwise operations, since signedness makes that more co

Re: Unsigned integers data types

2016-06-16 Thread Ildar Absalyamov
Things like Spark and Flink don’t do that as well, but because they need integration with proper Java types. > On Jun 16, 2016, at 15:45, Yingyi Bu wrote: > >>> Is there any database or SQL implementation supporting that? > Ok, it turns out MySQL supports that, while Postgres, MS SQL and Hive

Re: Unsigned integers data types

2016-06-16 Thread Yingyi Bu
>> Is there any database or SQL implementation supporting that? Ok, it turns out MySQL supports that, while Postgres, MS SQL and Hive do not have that. Best, Yingyi On Thu, Jun 16, 2016 at 3:40 PM, Yingyi Bu wrote: > >> I guess part of the reason why we do that is because Java used to lack > n

Re: Unsigned integers data types

2016-06-16 Thread Yingyi Bu
>> I guess part of the reason why we do that is because Java used to lack native support of unsigned integers. Is there any database or SQL implementation supporting that? FYI: http://dba.stackexchange.com/questions/53050/why-arent-unsigned-integer-types-available-in-the-top-database-platforms Be

Unsigned integers data types

2016-06-16 Thread Ildar Absalyamov
Hi devs, As I was generating various data distributions for statistics experiments one thing kept bothering me. All Asterix integer types (int8, int16, int32, int64) are signed. However majority of real use cases does not require negative integer values. Seems like we are waisting half of the d

Re: new AsterixDB web interface demo up and running

2016-06-16 Thread Kaveen Rodrigo
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 wrote: > Any valid ADM (asterix data model) instance can be a resu

Re: new AsterixDB web interface demo up and running

2016-06-16 Thread Yingyi Bu
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

Re: new AsterixDB web interface demo up and running

2016-06-16 Thread Kaveen Rodrigo
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, K

Re: new AsterixDB web interface demo up and running

2016-06-16 Thread Yingyi Bu
Awesome! Thanks, Kaveen! Best, Yingyi On Thu, Jun 16, 2016 at 9:56 AM, Kaveen Rodrigo 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 wrote: > > > Very cool!! > > It seems that there is an assumpti

Re: new AsterixDB web interface demo up and running

2016-06-16 Thread Kaveen Rodrigo
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 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 dat

Re: new AsterixDB web interface demo up and running

2016-06-16 Thread Yingyi Bu
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 wrote: > Hello all, > > I h

new AsterixDB web interface demo up and running

2016-06-16 Thread Kaveen Rodrigo
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 doc