How can I get the number of unique arrays

[silviucpp]

Hello,

Having a table like:

CREATE TABLE test_array2 (arr Array(Nullable(Float64))) ENGINE = Memory;
INSERT INTO test_array2(arr) values ([1,2]),([3,4]),([5,6]),([7,8]);

How Can I get number of unique arrays ? Seems uniq is not working with array fields

Silviu

[silviucpp]

This function returns if I'm not wrong unique elements across all arrays. not unique arrays for example if I have [1,2], [3,4], [5,6] I expect 3 but returns 6 (1,2,3,4,5,6) Silviu

…

On Thu, Mar 8, 2018 at 11:10 AM, 张健 ***@***.***> wrote: Maybe try arrayUniq Function ? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#2010 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AEl3i90vTJoaOzzKHahqbEamF5Hbg4NZks5tcPVxgaJpZM4SiSLU> .

[silviucpp]

Is this supposed to be fixed ? I still get Code: 48, e.displayText() = DB::Exception: Method getDataAt is not supported for Nullable(Float64), e.what() = DB::Exception when doing select uniq(arr) from test_array2

[alexey-milovidov]

Not yet, I had almost fixed this but not finished.

[silviucpp]

Hello @alexey-milovidov any idea when this bug will be fixed ?

[alexey-milovidov]

It was left unfinished, but thank you for reminder, I'll try to keep up!