hi Sanjit, thanks for reply.
Regarding this solution what u have provided about using Column qualifier. If i am not wrong there is an upper limit of 255 on column qualifier per column family (i.e. EmployeeTableKey:Qualifier in your example) and if i am having 1000 EmployeeIds, than how can i use the column qualifier technique in this situation? Could you all please give me suggestion on this issue. Thanks in advance. On Jun 4, 9:20 pm, Sanjit Jhala <[email protected]> wrote: > Yes you could store multiple delimiter separated rowkeys. Another > option would be to use the column qualifiers to store the rowkeys for > the EmployeeTable and just store a dummy value. For example, the > EmployeeName table could contain the column family > "EmployeeTableKey" (in this example I am assuming the rowkey for the > EmployeeTable is an integer): > > Rowkey ColumnFamily:Qualifier Value > > Sachin EmployeeTableKey:240 0 > Sachin EmployeeTableKey:153 0 > Sachin EmployeeTableKey:194 0 > Rahul EmployeeTableKey:250 0 > Rahul EmployeeTableKey:1 0 > > -Sanjit > > On Jun 3, 2009, at 11:27 PM, Sachin wrote: > > > > > > > Thank you very much Sanjit. > > > I got the answer of my first point. But the answer of the 2nd point is > > still unclear to me. > > Here I had asked to search on employeename instead of ID. > > > Name can repeat in many rows. So how can we create the name as rowkey? > > Do we need to take the distinct of the employee name and insert in > > this EmployeeName table? In the EmployeeName table, the value should > > be the rowkey of employee table (means EmployeeId). There can be many > > employees with different IDs and with same names. So in the value, do > > we need to store the EmployeeId in comma seperated or what else? > > > Regards, > > Sachin > > > On Jun 3, 9:50 pm, Sanjit Jhala <[email protected]> wrote: > >> Responses inline below. > > >> -Sanjit > >> On Jun 3, 2009, at 6:10 AM, Sachin wrote: > > >>> Hi, > > >>> One of my team mate Sanyama raised few queries in this group. I > >>> wanted > >>> to raise few more queries regarding this. > > >>> First of all, I am MS SQL Server developer and unfortunately think > >>> according to that. We are using C#.net as a development language. > > >>> Searching through net, we are highly impressed with Hybertable > >>> and so > >>> want to use this (instead of SQL Server) in our new project in which > >>> massive search operations are there. > > >>> Before starting the project we are studying hypertable and would > >>> like > >>> to know how the following things can be achieved: > > >>> 1. Joining the tables - In hypertable joining of the tables is not > >>> there. So do we require to get the data from more than one table and > >>> do the joining in frond end (C#) code? > > >> Doing the join on the front end might not be very efficient depending > >> on the volume of data returned by your queries. The general idea is > >> to > >> design around the lack of "join" functionality by denormalizing your > >> data. Another option could be using a map-reduce system to do joins > >> over large datasets although this is an offline solution. > > >>> 2. Searching on non-key fields - Suppose I have employee table which > >>> have 2 columns: EmployeeId and EmployeeName, and want to search > >>> based > >>> on employee name such as "Show me all employees whose name is Sachin > >>> or all employees in which Sachin exists in EmployeeName". How can we > >>> achieve this? > > >> You could create a separate table with the EmployeeName in the rowkey > >> and the value would be the rowkey(s) of the Employee table. This > >> table > >> is basically an index you create. However, Hypertable does not > >> provide > >> transactions across tables, so the application code needs to be > >> designed to handle potential inconsistency. > > >>> Eager to get response on the above queries. > > >>> Regards, > >>> Sachin- Hide quoted text - > > >> - Show quoted text -- Hide quoted text - > > >> - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
