ydb icon indicating copy to clipboard operation
ydb copied to clipboard

Non-primitive data types in table schema.

Open UnamedRus opened this issue 3 years ago • 2 comments

Ability to use non-primitive data types in table column definition.

As i understand current workaround is to use Pickle, Unpickle functions with String data type, but it's inconvenient.

For example, i use this construction for value updating and it's not really human readable.

text_list = Pickle(ListExtend(Unpickle(List<Utf8>, unwrap(NVL(text_list, Pickle(CAST(asList() as List<Utf8>))))),[unwrap(text)]))

UnamedRus avatar May 01 '22 18:05 UnamedRus

You can also consider using JsonDocument instead of byte representation with Pickle, this makes it more readable and you can do some processing from YQL queries (JSON_QUERY, JSON_VALUE, ...).

spuchin avatar May 30 '22 12:05 spuchin

Internal ID: KIKIMR-1875

spuchin avatar May 30 '22 12:05 spuchin