Is there a way to select rows of column1 and column2 where column1 is distinct and column2 doesn’t need to be distinct?
When I try
select distinct column1, column2 from table1 limit 100 I get the error
Failed to get a high quality cardinality estimation. When I try to use
select column1,column2 from table1 group by column1 limit 100 then I get an error that column2 is not being grouped.
I can understand how this would be problematic, because MapD wouldn’t know which values for column2 to return, but it actually doesn’t matter which of the available results get returned for column2. Can it be done?