[dba-Tech] Facebook releases its engine core

Hi Jim

Then, I guess, Facebook has developed a custom interface - can't imagine they have a 1000 users sitting typing commands ...

/gustav

-----Oprindelig meddelelse-----
Fra: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] På vegne af Jim Lawrence
Sendt: 8. november 2013 11:13
Til: Discussion of Hardware and Software issues
Emne: Re: [dba-Tech] Facebook releases its engine core

Hi Gustav:

Good questions. 

On the Presto site I saw a link to documents on the engine: http://prestodb.io/docs/current/

The whole thing appears pretty rudimentary right now, Alpha I understand but just like the Hyper-V server I would suspect a GUI will be built shortly. The good thing is that this is not a Map Reduce engine but a SQL engine. It seems for now we are stuck with a CLI but once installed it will run from any browser so someone will probably assemble a FE similar PHPadmin for MySQL. 

I can still remember when MYSQL only had a CLI... ;-)

Jim

----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com>
Sent: Thursday, November 7, 2013 11:41:17 PM
Subject: Re: [dba-Tech] Facebook releases its engine core

Hi Jim

But how do you "talk" to this engine? I see only a command line interface. 
The sparse doc mentions that "Presto uses HTTP for all communication, internal and external" but how? Via JSON?

Where can some serious documentation or guide be found? The user group looks like a mess with all sorts of nerd questions.

I have an idea for a project which mostly would read data, not in the PB range, just "without limits".

/gustav

-----Oprindelig meddelelse-----
Fra: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] På vegne af Jim Lawrence
Sendt: 8. november 2013 03:03
Til: Discussion of Hardware and Software issues
Emne: [dba-Tech] Facebook releases its engine core

Hi All:

Facebook open sources its SQL-on-Hadoop engine! Cool.

http://gigaom.com/2013/11/06/facebook-open-sources-its-sql-on-hadoop-engine-
and-the-web-rejoices/#!

So the next time you are designing for a client who has a million or more customers and many billions of pieces of data, you have a solution at your figure tips. ;-)

Check out the link: http://prestodb.io/

Jim