We are designing a schema for a new product. I would like to know which one of the following is recommended and any issues you see in the options #2
- option #1: row based
my-measurement rig=100,sourceTag=t1 value=100 1465839830100400200
my-measurement rig=100,sourceTag=t100 value=200 1465839830200400200
my-measurement rig=100,sourceTag=t500 value=300 1465839830300400200
- option #2: wide structure
my-measurement rig=100 t1=100,t100=200 1465839830100400200
my-measurement rig=100 t500=300 1465839830100400200
- sourceTag values can be from t1 to t2000 (1 to 2000)
- in option #1, there is only one insert for a given time, rig, and sourceTag (no updates)
- in option #2, there will be multiple inserts for a given time and rig(updates). In the subsequent inserts, only new fields will be added(t1 to t2000) and the rig and the time will be same for few inserts
Currently, this is a single node environment.
Please let me know.