Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Flex tables and strange json parsing

Hello!

 

I have the following column in a materialized view: 

 

 

public | flextable_view | my_column  | int   |    8 | (MapLookup(flextable.__raw__, 'field'))::int

 

But sometimes it is materialized as Null:

 

select (MapLookup(flextable_view.__raw__, 'field'))::!int, field from flextable_view where field is null;

MapLookup | field
-----------+----------
1988 |
399 |
163 |
2052 |
591 |
105 |
417 |
105 |
1260 |
417 |
1934 |
605 |
1758 |
1721 |
1449 |
1656 |
105 |
2052 |
1934 |
726 |
591 |
591 |
1934 |
591 |
622 |
2052 |

Why is it happening?

 

Thank you,

Petr

 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.