Problem with what is written in cassandra

[2014siavash]

Hi,

I dont know it is an issue or not, but when I want to see what is written in the database, I saw that some variables are written in different columns or just not written in the database such as "bn", "bt" and so on (the null ones). I saw "bn" in the column "n", as you can see in the below. More precisely, in the column "n", we can see for example "some-base-name:voltage", but "some-base-name" is for column "bn" and column "n" should be just "voltage". There are also maybe some other substitutions ("bt" is written in "t" and so on).
Am I wrong?

I used your instruction at http://mainflux.readthedocs.io/en/latest/

thanks for your support.

------------------------------------------------------------------------
channel                              | id                                   | bn   | bs   | bt   | bu   | bv   | bver | l | n                      | protocol | publisher                                                                                                                                                                                    | s | t         | u | ut | v     | vb    | vd | vs
--------------------------------------+--------------------------------------+------+------+------+------+------+------+---+------------------------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---+-----------+---+----+-------+-------+----+----
 743219d8-a8d5-11e7-bb35-0242ac110005 | 1868de00-ac01-11e7-a1bf-f58bd8d3766a | null | null | null | null | null |    5 |   | some-base-name:voltage |     http | eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpYXQiOjE1MDcxMDA5MDMsImlzcyI6Im1haW5mbHV4Iiwic3ViIjoiY2Y2YWRjMTMtYThkMi0xMWU3LWJiMWUtMDI0MmFjMTEwMDA1In0._z_SamNwgo2PMhKAAIyFqnSsWWliN_R2bfNas9SFzu4 | 0 | 1.276e+09 | V |  0 | 120.1 | False |    |   
 743219d8-a8d5-11e7-bb35-0242ac110005 | 187c8d10-ac01-11e7-a1bf-f58bd8d3766a | null | null | null | null | null |    5 |   | some-base-name:current |     http | eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpYXQiOjE1MDcxMDA5MDMsImlzcyI6Im1haW5mbHV4Iiwic3ViIjoiY2Y2YWRjMTMtYThkMi0xMWU3LWJiMWUtMDI0MmFjMTEwMDA1In0._z_SamNwgo2PMhKAAIyFqnSsWWliN_R2bfNas9SFzu4 | 0 | 1.276e+09 | A |  0 |   1.2 | False |    |   
 743219d8-a8d5-11e7-bb35-0242ac110005 | 187cb420-ac01-11e7-a1bf-f58bd8d3766a | null | null | null | null | null |    5 |   | some-base-name:current |     http | eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpYXQiOjE1MDcxMDA5MDMsImlzcyI6Im1haW5mbHV4Iiwic3ViIjoiY2Y2YWRjMTMtYThkMi0xMWU3LWJiMWUtMDI0MmFjMTEwMDA1In0._z_SamNwgo2PMhKAAIyFqnSsWWliN_R2bfNas9SFzu4 | 0 | 1.276e+09 | A |  0 |   1.3 | False |    |   
 743219d8-a8d5-11e7-bb35-0242ac110005 | c5d22d80-ac01-11e7-a1bf-f58bd8d3766a | null | null | null | null | null |    5 |   | some-base-name:voltage |     http | eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpYXQiOjE1MDcxMDA5MDMsImlzcyI6Im1haW5mbHV4Iiwic3ViIjoiY2Y2YWRjMTMtYThkMi0xMWU3LWJiMWUtMDI0MmFjMTEwMDA1In0._z_SamNwgo2PMhKAAIyFqnSsWWliN_R2bfNas9SFzu4 | 0 | 1.276e+09 | V |  0 | 120.1 | False |    |   
 743219d8-a8d5-11e7-bb35-0242ac110005 | c5d25490-ac01-11e7-a1bf-f58bd8d3766a | null | null | null | null | null |    5 |   | some-base-name:current |     http | eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpYXQiOjE1MDcxMDA5MDMsImlzcyI6Im1haW5mbHV4Iiwic3ViIjoiY2Y2YWRjMTMtYThkMi0xMWU3LWJiMWUtMDI0MmFjMTEwMDA1In0._z_SamNwgo2PMhKAAIyFqnSsWWliN_R2bfNas9SFzu4 | 0 | 1.276e+09 | A |  0 |   1.2 | False |    |   
 743219d8-a8d5-11e7-bb35-0242ac110005 | c5d25491-ac01-11e7-a1bf-f58bd8d3766a | null | null | null | null | null |    5 |   | some-base-name:current |     http | eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpYXQiOjE1MDcxMDA5MDMsImlzcyI6Im1haW5mbHV4Iiwic3ViIjoiY2Y2YWRjMTMtYThkMi0xMWU3LWJiMWUtMDI0MmFjMTEwMDA1In0._z_SamNwgo2PMhKAAIyFqnSsWWliN_R2bfNas9SFzu4 | 0 | 1.276e+09 | A |  0 |   1.3 | False |    |
------------------------------------------------------------------------

[mijicd]

@2014siavash we'll check this out.

@drasko did some refactoring on the service, so he'll check out this bug as well.

[drasko]

@2014siavash you are correct, and all SenML sent to Mainflux is now normalized i.e. resolved before it is being written into Cassandra.

Please take a look at SenML spec, chapter 4.4 "Resolved Records": https://tools.ietf.org/html/draft-ietf-core-senml-10#page-8

We should completely remove base values from Cassandra tables, they are not needed anymore.