Re: ad-hoc queries in BigTable ?

[Michael Hermus]

You should start here: https://developers.google.com/appengine/docs/java/datastore/overview

On Wednesday, June 27, 2012 6:39:00 AM UTC-4, Baraa Mohamad wrote:

Hello,

I'm very interested in BigTable as I'm working with a very huge/ever-growing heterogeneous data.

In order to assure my understanding I have two questions please:

- Can I perform ad-hoc/analytical queries over Bigtable or it's designed for historical queries? 

- I read that BigTable  does not support general transactions across rows keys", I'm not sure that I understood exactly

 this point so some more explications or examples would be very helpful for me.

Thank you for your help ,

Best Regards,

Baraa

[Barry Hunter]

It may first be worth carifying exactly what you talking about. 

'BigTable' as such isnt a product you can use directly. Its a technology developed at Google, and powers many of their projects. 

The closest thing in AppEngine is the Datastore

https://developers.google.com/appengine/docs/python/datastore/ 

Its built with BigTable, but exposes a specific API. (and so can do stuff Bigtable cant do itself)

And for analytical queries, you probably want

https://developers.google.com/bigquery/

which is a separate service. It might or might not be built with BigTable under the hood. 

I dont understand the quote you provided either, but read more about the capablities of the datastore (or bigquery!) at the links above. 

On Wed, Jun 27, 2012 at 11:39 AM, Baraa Mohamad <baraa.iss...@gmail.com> wrote:

Hello,

I'm very interested in BigTable as I'm working with a very huge/ever-growing heterogeneous data.

In order to assure my understanding I have two questions please:

- Can I perform ad-hoc/analytical queries over Bigtable or it's designed for historical queries? 

- I read that BigTable  does not support general transactions across rows keys", I'm not sure that I understood exactly

 this point so some more explications or examples would be very helpful for me.

Thank you for your help ,

Best Regards,

Baraa

--
You received this message because you are subscribed to the Google Groups "Google App Engine" group.
To view this discussion on the web visit https://groups.google.com/d/msg/google-appengine/-/eAkjZtU2BK4J.
To post to this group, send email to google-a...@googlegroups.com.
To unsubscribe from this group, send email to google-appengi...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.

[Baraa Mohamad]

thank you very much for your helpful answers, in fact I'm doing a research on all Nosql technologies and Cloud data management systems in order to develop 

a system for my particular highly heterogeneous data. That's why I need to know what each of them can offer and what are the potential limitations. 

I saw some people using Datastore but they have a replica for there data on a RDBMS only to process ad-hoc queries. So thank you vry much for the BigQuery link 

I didn't hear about it before.

As it's an interesting discussion (I hope for you too), do you think that the other NoSql (hbase, Hive, cassandra ) have the same problem of 

ad-hoc queries and so can we use BigQuery with those databases or it's designed for google projects?

Regards 

Baraa