Hi Sachin, There is no limit to the number of column qualifiers per column family. There is a limit of 256 column families, but within a family there can be an infinite number of qualifiers.
- Doug On Tue, Jun 30, 2009 at 11:30 PM, sanyama <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
