On Wed, Jun 3, 2009 at 11:58 PM, Sachin <[email protected]> wrote: > > Hi, > > In our application, we are going to give serach facility. User can > enter any word and the application will search this word in any of the > columns. Here we will need like operator, as the word to be search can > be anywhere, in start, in middle or at the end. > > For this type of search, can you please advice me how to go ahead? > > I know I am thinking right now in SQL Server fashion. But need some > guideline, so that I can think on this differently.
What you really need is full-text search for this application. Using SQL/HQL is a kludge that would not work very well. Solr, Sphinx etc is what you need to look into. Basically you write a data import query in them and you send your word query to these search engines. __Luke > > Regards, > Sachin > > > > On Jun 3, 2:03 pm, Vicaya <[email protected]> wrote: >> >> 3) Is there any operators in hypertable as like 'IN' and 'LIKE' as in >> >> SQL? >> >> > Not yet. LIKE should be fairly easy to implement. IN may be a little more >> > challenging to do efficiently. >> >> IN on rowkey should be fairly easy to implement though, since the >> client api already support list of intervals. >> >> __Luke > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Hypertable Development" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/hypertable-dev?hl=en -~----------~----~----~----~------~----~------~--~---
