ydb
ydb copied to clipboard
Non-primitive data types in table schema.
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)]))
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, ...).
Internal ID: KIKIMR-1875