Analytics index boolean

Analytics
1

Hi I have some query and it’s filtered by boolean value:

SELECT 
         col_doc.data.en.date_start,
         col_doc.data.en.date_end
  FROM `deploy_dev`.`tournament`.`testing` col_doc
  WHERE col_doc.data.en.tournament_view=TRUE

When i try to create index i receive error

CREATE INDEX oTournamentViewIdx ON deploy_dev.tournament.testing (data.en.tournament_view:BOOLEAN);

Compilation error: The field ‘data.en.tournament_view’ which is of type boolean cannot be indexed using the BTree index. (in line 1, at column 87)

2

Hi @victorb, currently the indexable types in Analytics are:
INT, DOUBLE, and STRING.

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.