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.
Allowing for configurable search such as that is offered wtih lucene, built into the infrastructure would be a great addition. Microsoft seems to be heading this way and has a lucene library for azure, but you cannot use it for commercial purposes. http://tiny.cc/azurelucene
This is under review for addition to Windows Azure Tables.
Chris Kirby commented
So glad this is under review, we really need the ability to index specific fields on tables. You can do a lot with a solid partitioning strategy today, but in almost every case, I still need this feature to maximize performance.
Akash Kava commented
Storing any textual data on Table Storage is useless until this feature is provided, also we want this to be on Table Storage, not on SQL Azure.
Robert Dytmire commented
Yeah this is a big deal MS...it's been a feature of SQL Server for a LONG time, why the delay in Azure?
Luke Merrett commented
What's the ETA on this request? I haven't seen any activity or blog posts regarding this planned feature for over a year; despite it being commonly requested for SQL Azure.
Alexsandro Pereira commented
:D good nice feature!!
Chris Dostert commented
@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
When is this coming? I will be happy if the answer is "today"--even happier if the answer is "yesterday".
@Jim - Read calvins comment 2 below
"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!
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.
Table storage will be getting full text search as well.
"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?
This is really important! I've tried to use Lucene with Table Storage but the costs are too high!
Adrian Rigby commented
We require this for for moving our systems into SQL azure.
I like lemons.
Joch Robinson commented
We would like to develop our proucts to run on Azure, however to do so we need full text indexing.
Spencer Clark commented
Currently looking to migrate our SQL infrastructure to Azure Cloud Services
However this is not possible without Full test indexes
Lee Thompson commented
Azure is the future...but only with full text indexing. Guys, if you are listening, please add this into your development schedule.
Steve Ross commented
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!
We’d like to get our products running on SQL Azure, but to do so requires full text indexes