How can we improve Windows Azure Data Management: Tables?

Provide me with full text search on table storage

Does what it says on the tin....really need better search capabilities over azure table storage.

565 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    andybritcliffeandybritcliffe shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    planned  ·  CalvinCalvin responded  · 

    This is now on the SQL Azure roadmap, though delivery will be post CY12.

    32 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Chris DostertChris Dostert commented  ·   ·  Flag as inappropriate

        @Will: you can use AWS CloudSearch service with ANY data store.. you just send your object to both storage medium(In-Memory, Azure TableStorage, AWS DynamoDB, SQL Server..etc) and the CloudSearch service. Because search as a service is probably going to be offered by all of the players in the game shortly(Google is also working on theirs and per this page Microsoft as well) I didn't want to tie my most recent project to AWS CloudSearch so I wrote a Search library that abstracts away your search implementation from any specific provider. Hypothetically speaking; when Microsoft and Google catch up and release their Search/Indexing as a Service offerings this library will allow you to use any or all of them without changing any of your dependent code. I haven't taken the time to publish any of it but if there were enough people interested i could publish the source on GitHub or equivalent and maybe put together a Nuget package with some documentation. -CD

      • JerryJerry commented  ·   ·  Flag as inappropriate

        When is this coming? I will be happy if the answer is "today"--even happier if the answer is "yesterday".

      • JImJIm commented  ·   ·  Flag as inappropriate

        "This is now on the SQL Azure roadmap" ????? Hello??? We are asking for this on Azure "Table" Storage. What's the roadmap for this? It will be 3-years soon since it was originally asked for!

      • WillWill commented  ·   ·  Flag as inappropriate

        So glad to hear this is coming, but it needs to be a high priority, as in this CY. Amazon just released a full scale cloud search which is compelling to say the least. We use AWS for everything else we do, and are looking at moving our TS data to AWS DynamoDB and indexing it with AWS Cloud Search unless full text comes to Azure soon.

      • ray247ray247 commented  ·   ·  Flag as inappropriate

        "This is now on the SQL Azure roadmap, though delivery will be post CY12.", but what about people using Table Storage??? Does this mean there will be no Full Text Search feature out of box coming to Table Storage anymore? How do we who are using Table Storage as a backend have this search capability or do we need to re-write everything we did for Table Storage to Sql Azure now? Could you please clarify?

      • MarkusMarkus commented  ·   ·  Flag as inappropriate

        This is really important! I've tried to use Lucene with Table Storage but the costs are too high!

      • Joch RobinsonJoch Robinson commented  ·   ·  Flag as inappropriate

        We would like to develop our proucts to run on Azure, however to do so we need full text indexing.

      • Spencer ClarkSpencer Clark commented  ·   ·  Flag as inappropriate

        Currently looking to migrate our SQL infrastructure to Azure Cloud Services
        However this is not possible without Full test indexes

      • Lee ThompsonLee Thompson commented  ·   ·  Flag as inappropriate

        Azure is the future...but only with full text indexing. Guys, if you are listening, please add this into your development schedule.

      • Steve RossSteve Ross commented  ·   ·  Flag as inappropriate

        We want to push our software developments forward and deliver them through Azure but cannot progress without full text indexing...please force this up your priority list!

      • BobBob commented  ·   ·  Flag as inappropriate

        We’d like to get our products running on SQL Azure, but to do so requires full text indexes

      • BobBob commented  ·   ·  Flag as inappropriate

        We’d like to get our products running on SQL Azure, but to do so requires full text indexes

      • Paul HicksPaul Hicks commented  ·   ·  Flag as inappropriate

        This is a show stopper for us, without it there is no way we could move to Azure.

      • KirstyKirsty commented  ·   ·  Flag as inappropriate

        Please provide a full-text search index over table storage entities

      • MarkosMarkos commented  ·   ·  Flag as inappropriate

        Please provide a full-text search index over table storage entities. Lucene is a good example of creating inverted index. But it has limitations with Azure and performance is an issue and 4GB Azure AppFabric cache limitation (not to mention the cost) is a limitating factor on hosting Lucene index in memory. Maintaining it in each web role is also not the best approach. In short, please provide a way to submit text and associated properties (like Lucene) and index them so that when searching for text, you can find the best matches and get the associated properties (which could be PK, RK in table storage).

      ← Previous 1

      Feedback and Knowledge Base