RE: MDAM has sparse and dense mode, for string column, is it possible to use dense mode?

2017-10-23 Thread Dave Birdsall
...@trafodion.incubator.apache.org Subject: RE: MDAM has sparse and dense mode, for string column, is it possible to use dense mode? Hi Dave and Ming, I am not sure I understand why we are not just simply using a probe asking for strictly greater in all cases>? Let say after "ABC", the next pro

RE: MDAM has sparse and dense mode, for string column, is it possible to use dense mode?

2017-10-23 Thread Eric Owhadi
tober 23, 2017 11:35 AM To: user@trafodion.incubator.apache.org; d...@trafodion.incubator.apache.org Subject: RE: MDAM has sparse and dense mode, for string column, is it possible to use dense mode? Hi, I believe the compiler today only uses "dense" for integer data types. It might do

RE: MDAM has sparse and dense mode, for string column, is it possible to use dense mode?

2017-10-23 Thread Dave Birdsall
Hi, I believe the compiler today only uses "dense" for integer data types. It might do it for intervals too; I am not sure. Using "dense" depends on being able to add 1. In principle this is possible for any data type (even float!). But it can be tricky in practice. For example, for VARCHARs: